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)
But I need something that can load in more than one at a time.
'10921876', '11009008','11444900', '11473236', '10922118', '11825240', '11241201', '11013032',
Any advice would be great, thanks in advance.