Oops, I forgot to mention...SQL SERVER SERVICE BROKER. :hehe:

Woof...how it will?:unsure:

mmm...impresive...nice solution

Ofcourse better we can make a as UDF...Wont it?

DECLARE @EmployeeIDCSV varchar(100)

SELECT @EmployeeIDCSV = COALESCE(@EmployeeIDCSV+ ', ', '') + CAST(Emp_ID AS varchar(5)) FROM Employees

SELECT @EmployeeIDCSV

We can also use this...So compact...

Hai Guys try this...

Reading the File

The files will be read into a File Stream and then the File Stream will be converted into byte array using BinaryReader in order to...

Use Visual studio whenever you build xml schamas. This will avoid such kind issues being populated.

otherwise you can use EditiX Lite Free Version to build schemas.

Hei 100000 thanks to you....Its cool...Yahooooooo

It should work

SELECT COVERT(VARCHAR,GETDATE(),111);