SQL Trick And Tips, Interview questions,Queries, examples to make developer's life easier than ever before..
My aim to create this blog is to write all such tricks and tips in SQL queries which will be helpful to my friends all over the world.
I want to share my experience about the SQL and hence i am too excited to start with....
Hope you all take me further over the web with my genuine intention to help you out with enjoyment of the technology......
Saturday 31 July 2010
COALESCE- Convert Row values to Comma Separated value
DECLARE @EmployeeList varchar(100) SELECT @EmployeeList = COALESCE(@EmployeeList + ', ', '') + CAST(c AS varchar(5)) FROM Employee Select @EmployeeList
