I want to create a temporary table and add 2000 zipcodes in it. I do have list of zipcodes. But i dont know how do i add to table. If i manually di, It gonna take long time.
Where is the "list of zipcodes" you have? If that's in a text file or spreadsheet, you can load that into SQL Server without having to enter them yourself.