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
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Data with semicolon delimiter

Author  Topic 

Avinash N
Starting Member

6 Posts

Posted - 2008-04-18 : 00:04:37
Hi all......

I have an issue

There are 2 tables... source and target...

Data from source goes into target table under same field...

ISSUE IS -

Data from 'n' no. of records from source table goes into a single record in the target table with delimiter being a semi colon (;)...
where(n >=2)...

For example - if the source table has 'src1', 'src2' and 'src3' as the data then target table will have a single record with semicolon as delimiter as 'src1;src2;src3'

How do we compare the data under this particular field now...

Do we have to use a if then loop for identifying when the ; ends in target data...

kindly help by giving a example...



Thanks,
Avi.

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2008-04-18 : 05:22:50
Answered here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101084

Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page
   

- Advertisement -