Wednesday, 18 February 2015

Selecting multiple rows as single row in sql server

SELECT STUFF((SELECT DISTINCT ','+CONVERT(VARCHAR(10), MO_CC_ID) from NEWMAKE_OFFER WHERE MO_FU_ID=546 for XML path('')),1,1,'')
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Extracting Nupkg files using command line

Rename it to zip first then extract files as below 1.     Rename-Item -Path A_Package.nupkg -NewName A_Package.zip 2.     Make sure to repla...