Thank you very much Eirikur Eiriksson , your Quick suggestion made my day . you deserve a round of applause

Thanks Bhanu 🙂 , this solved my issue

Thanks Luis 🙂 , this solved my issue

Hi Jack ,

Thank you very much for your response , your example solved my issue

Thank you very much

Hey Dwain,

Could you please explain how this query executes to get the count.

Thanks in Advance

ok

Thanks you very much Artoo.

NO for representing values i have used 1 it may contain more than one

yes i tried with this option .by selecting the Url under report manager it's prompting me for user ID and Password as of now i didn't create any user

sorry.

With above reply it Giving following Error Message

Column '#TempA.LOGIN_ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Thank you very much for help i got solution for my problem from above examples

hi opc .i Got the Answer with below logic but is there any another best way to achieve this

BEGIN TRAN

create table #temp

(

col1 varchar(2),

col2 varchar(2),

col3 varchar(2)

)

insert #temp

values('a','d','')

insert #temp

values('','b','')

insert #temp

values('','','c')

declare @listValues varchar(580)

create...

hi opc . i hope u r funny but the above answer will not suits i think

aNULLNULL

NULLbc

NULLNULLd

i need out put as "abcd" from above data.please help how to get this done