I was wrong here. but the right query will be

SELECT

customerID, count(city) as 'Count'

INTO CustomerCities

FROM Customer

GROUP BY CustomerID

other wise it will not execute.....

definitely CustomerCities...

Thanks a lot for writing this wonderful SQL Code. it gave me relax that i could not get 2 days.

i used this code in BULK Insert from .txt file data.with...