--If we mention same alias name for all columns, all column values will be merged
--To overcome the above problem
-- Method 1 :
-- Method 2 :
above Method 1 & Method 2 query
Will it be Ok to add to June Guru Contributions contest?
Ya sure Naomi N ....
I did it for this article. I believe you recently contributed another article (forgot its title). You may want to do the same with it as I did with this - add to main contributions page, add link at the bottom, add more tags
Naomi - thanks for adding my XML article to the contest , anyways iam not quite sure about adding technet wiki articles to contest ,here is my another post - social.technet.microsoft.com/.../17777.t-sql-remove-leading-and-trailing-zeros.aspx ,kindly add this too if it is eligible to participate in the contest :)