Copy and Paste into MS does not validate. Error at line 3 = sign.

What is the difference and implications of utilizing #TempTableName and @TempTableName ?

Andy:

I have been working with SSIS for some time and basically learned most of the tricks the hard way. I'm looking forward to your future articles and would like to...

Actually the ROW_NUMBER() was the key. This worked correctly:

SELECT [State],

[City],

ROW_NUMBER() OVER(PARTITION BY [State] ORDER BY [City]) AS [City_Cnt]

FROM [dbo].[MySalesDataTableAggregatedMonthly]

WHERE [State] IS NOT NULL AND [City] IS...

No I need to count each city in each state. Removing distinct just gives the total count of cities. Nice guess.