Convert Access Query to MSSQL Query

Convert Access sql statement to Microsoft SQL Server SQL statement. Converted SQL query must work on SQL Server 2008. Access query use sub-queries and is rather complicated. The Query to be done which is in the database which is in the attachment is called "SMLNSHR". But if you can do the rest of the queries or some of them then in your bid mention if you will be doing all the queries, or just the "SMLNSHR" or SMLNSHR plus the number of other queries you will be doing. I don't need NPODATE1, NPODATE2 or SMLNSHRDATA done. The database mentions a 2009ArtsNonProfits file. The second attachment is the database that 2009ArtNonProfits references. The worker will have to add the 2009 table from the 2009ArtsNonProfits db into the query as if the table were in the original database. ## Deliverables 2009ArtsNonProfits