Good question but not well presented. Try it on a database which is case sensitive and you get "none of the above"! Case is always important and as they say...

See 4 posts back for the fix to the error in your query

Ooops, think I hit the wrong button, this post might be duplicated.

Here is your solution:-

set @sql = ' SELECT x.SaleYear, x.TotalSales

FROM (SELECT SaleYear,

TotalSales= ISNULL((SELECT SUM(TotalSales)

FROM InsSales

WHERE...

Here you are!!

set @sql = ' SELECT x.SaleYear, x.TotalSales

FROM (SELECT SaleYear,

TotalSales= ISNULL((SELECT SUM(TotalSales)

FROM InsSales

WHERE region= ''NE''

AND SaleYear = y.SaleYear and salesPerson in (''' + @SalesPerson...