fetch next from c1 into @db_name,@table_name,@date,@col

WHILE (@@FETCH_STATUS = 0)

begin

set @sql = 'delete from ' +@db_name +'.dbo.'+@table_name+'insert into '+@db_name+'.dbo.'+@table_name+' SELECT distinct top 100* FROM [112.64.104.210,3824].'+@db_name+'.dbo.'+@table_name --+ 'WITH (nolock)'--...

Can you post the DDL and DML scripts in readily consumable format...

Thanks Lynn..however, I will continue to use CS collation...

Thanks Lynn...It says CS (Case sensitive), but its grayed out...how do i change that now?

Mohit...The code you gave doesnt work here i believe...

My direct expected result should be in table as below:

ID -- value

1 ...

SQL SERVER 2000...

Thanks matt..I got the Tally Concept**

Now for learning Sake....How would you accomplish reverse of this?

I mean to say..

If the table looks Like

ID -- ...

Yup..I got what tally table means.Thats Awesome...It rocks...

I have a table where in i have all the values concatenated with "-"..now i have to split them into multiple rows to insert into a new table..

Please let me...

Thanks a lot sergiy...it works..

thanks a lot...

Dear experts..can any one please give direction to this problem?

Thanks for the reply Girish. These options looks fine. but linked servers are not permitted to us. do you have any idea on making the excel file as XML string...