Thanks for the reply.

I was trying to see if I can set a variable of type uinqueidentifier to the value of an item that is of the type varchar?

Actually it worked. I already inserted the record. Thank you so much for your help.

Thanks. I will try it.

This is the correct answer:

This gives the result I am looking for:

Select LOSS_SRIP = sum(case I.IT_Code when 'SRIP' then 1 else 0 end),

LOSS_TA...

Thank you so much for your efforts. I just wanted to mke sure that the alternative to having two statements does not yield better performance.

I just want counts returned to two variables displayed in a single row.

Thanks

This is the result I get from running your query statement:

However, this is not what I want. My query should give:

Loss_TA Loss_SRIP

______________________

3 ...

Thanks again. your solution was great.

It worked.

Thank you very much.

Thanks. I will try it.

It worked.

thank you very much.

I will try the Sum Statement.

Thanks

it did not work.

I will try it.

Thanks