I have a table that I need to add in multiple numbers into one column. I have an insert statement setup, but I have only had to 1 PCS Number. Now I have about 80 to add. Is there a way to do this in one shot?
Here is my insert statement below that works out great.
insert into [ProviderFinder].[dbo].[ExcludedPCS] (ClientID ,PCS)
select 8,'12345678'
But I need something that can load in more than one at a time.
'10921876', '11009008','11444900', '11473236', '10922118', '11825240', '11241201', '11013032',
You can use
Excel
Put all numbers into one column
Put insert statement in the topmost cell to the left
Then double click that cell
At the bottom right corner
Please let me know if you have
A place to share video recording