Converting Column data into a single Row
STUFF(( SELECT DISTINCT '],[' + ltrim(str(YEAR(OrderDate)))
FROM Sales.SalesOrderHeader
ORDER BY '],[' + ltrim(str(YEAR(OrderDate)))
FOR XML PATH('')
), 1, 2, '') + ']'
posted by Bineesh | 2:51 AM
SQL NET - A Place to talk on MS SQL Server and other database tools
Talks on SQL Server, database development, data management techniques,SQLBI/SSIS/SSAS/SSRS etc. Want to publish something db related ? mail to bineeshthomas@gmail.com with subject line starting as "SQLNET"
SQL NET FORUMPortal Maintained By : BINEESH THOMAS
- Rows to Column transpose
- Tips - Grant and Revoke
- SYSOBJECTs-List All Database Objects in SQL Server...
- Insert Generator SP - SQL Server
- SQL PUZZLE:UPDATING 0 AS 1 AND VICE VERSA IN A BIT...
- To get number of actual decimal places for a numbe...
- To get number of actual decimal places for a numbe...
- Getting Comma seperated string from data in an sql...
- How to stop SSRS service from application ?
- Get foreign key hierarchy of all DB tables- Omri B...
0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Home