Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 insert into one table from another select stmt

Author  Topic 

sanjeevka08
Starting Member

18 Posts

Posted - 2012-10-05 : 03:07:01
I have a split function that splits a string with limitter ','. i want to insert entry into table that contains 2 columns with one column id with same value and send column date with data returning from split function

for example..

consider table item

columns-id int, item varchar
table must be like this in one insertion


id item
1 a
1 b
1 c
1 d


this a,b,c,d is returned by function split..
please give me a soluton

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-10-05 : 03:17:21
Provide Expected Output.......


--
Chandu
Go to Top of Page
   

- Advertisement -