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)
Passwords Made Easy
Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...
-
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...
-
If you have a situation that requires an application to always be up then try Restart program after a crash downloadable from https://w-s...
No comments:
Post a Comment