RE: sql query

just an FYI, because I haven't followed the entire thread.

there are various 'split' UDF that people have offered.

for instance:

http:// sqljunkies.com/WebLog/amachanic/articles/ PatternSplitString.aspx

rob

Mark Pawelek < mark.pawelek%40ntlworld.com">mark.pawelekntlworld.com> wrote: T-SQL does not support arrays

Consider using a table variable

Mark P.
________________________________________
From: AspNetAnyQuestionIsOk%40yahoogroups.com">AspNetAnyQuestionIsOkyahoogroups.com
[mailto: AspNetAnyQuestionIsOk%40yahoogroups.com">AspNetAnyQuestionIsOkyahoogroups.com] On Behalf Of manisha kadam
Sent: 12 June 2007 07:05
To: SQL; asp; asp; ASP; c_sharp_world%40yahoogroups.com">c_sharp_worldyahoogroups.com; l
Subject: [AspNetAnyQuestionIsOk] sql query

DECLARE CatalogueNo varchar(50)
SELECT CatalogueNo = CatalogueNo + ', ' FROM ProductCatalogue
WHERE productid = 117

in table ProductCatalogue
i have 5 different CatalogueNo like 1, 2, 3, 4, 5

i want to store each value of CatalogueNo in a variable CatalogueNo
but it just gives me 5

how can i do it
thanks

---------------------------------
Looking for a deal? Find great prices on flights and hotels with Yahoo!
FareChase.

[Non-text portions of this message have been removed]






---------------------------------
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.

[Non-text portions of this message have been removed]

Messages in this topic (0) Reply (via web post) | Start a new topic

.