Monday, 10 November 2014
Convert Column results to delimited string in TSQL
Use the below to convert the results of a query from this
123
125
156
254
214
To
123,125,156,254,214
DECLARE @result varchar(1000)
SET @result = ''
SELECT @result = @result + cast(order_id as varchar) + ',' FROM tblorders WHERE tblstatus = 2
select substring(@result, 0, len(@result))
This has worked for me no problems you can change the delimiter by changing the ' ,'
Original code that this was based on can be found here
Subscribe to:
Post Comments (Atom)
-
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
-
If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro... -
Do you charge your device in a public or on a non secure work space ? if the answer is yes then you are leaving your device open to be hac...
No comments:
Post a Comment