Thanks Jeff and David

It works.

Seems I was trying char(10) and char(13) in the wrong order.

It works only in a specific order

First char(13) and then char(10)

Thanks again

Sunny

Thanks Jeff

I had actually tried using char(13) and char(10) nut it didnt help

Regards

Please let me know if this works

Select distinct A.StatusDate,

(select Count(Distinct B.AssetID) from dbo.Tbl_EMStatusHistory B where B.DeviceType = 'Monitor'     and B.StatusDate = A.StatusDate and B.AssetStatus = 'IN') Monitors,

(select Count(Distinct...

But Count(fieldName) is required in case you want to eliminate Nulls from the count. Am I right?