Home
Blogs
Forums
Downloads
Site Search:
Sign in
|
Join
|
Help
This Blog
Home
Contact
Common Tasks
Syndication
RSS
Atom
Comments RSS
Receive Email Updates
Subscribe
Recent Posts
How to avoid the dreaded 'divide by zero' error
Function to 'Proper' case a string
How to tell if a temp table exists in SQL Server
Code to monitor the size of DBs on a SQL Server
Enabling and disabling a SQL Trigger
Tags
aggragate
comma
mail
Recovery Model
semicolon
sp_OACreate
sp_OAMethod
SQL 2000
SQL 2005
sql mail
sql server
sqlmag.com
streamwriter
syscolumns sysobjects
sysobjects
text file
truncate log
Archives
October 2008
(5)
August 2008
(3)
July 2008
(1)
June 2008
(1)
May 2008
(2)
April 2008
(1)
January 2008
(3)
December 2007
(5)
November 2007
(3)
October 2007
(3)
August 2007
(7)
June 2007
(1)
May 2007
(1)
April 2007
(2)
March 2007
(5)
February 2007
(3)
January 2007
(9)
SQL Server (T-SQL)
Comments and notes on SQL Server 2000, 2005, and T-SQL
Browse by Tags
All Tags
»
comma
»
aggragate
(
RSS
)
semicolon
sqlmag.com
Semicolon separated contatoncated output in SQL Server
This script will give you a comma separated (or semicolon separated) list in SQL Server 2005 SELECT c.sopnumbe, STUFF ( ( SELECT ',' + CAST (itemnmbr AS VARCHAR ( MAX )) AS [ text ()] FROM ( SELECT DISTINCT rtrim (itemnmbr) as itemnmbr FROM sop10200 AS...
Posted
Jan 18 2007, 08:32 AM
by
Steve Gray
with | with
no comments
Select Tags...
Save
Cancel
Filed under:
sqlmag.com
,
semicolon
,
aggragate
,
comma
[Edit Tags]