Hi Thorn,
Its take ID has primary key  and I am only taking  ID count.
ID=1 is available 3 times.so for ID=1(Multiple value available for this particular ID) if any of...

Thanks Jeff for sharing your experience.....

Regards,
Saravanan

Hi Jeff,

Thanks for point it out and your contribution to SQL is immense . I am a tester when I run my query it usually takes lot of...

Thanks Thorn.. It worked....

Thanks Thorn. If possible can you kindly explain with a example...

Regards,
Saravanan

Thanks Allen... 
Can you kindly  tell me how to generate two result sets...
Regards,
Saravanan

Can you kindly check the syntax 

Goal is: if HEDGE CLASS CODE is null and DC_ManagerCode is null then:FundCode--->(Why semicolon is used in front of column name)
if...

Hi Roger,

I got your desired output by using the below query. See if fits your requirement:
select customer,SUM(consolidated_amount)as total_amount from
(
select b.customer,b.purchase,SUM(amount) as consolidated_amount
from orders b

This is the query your looking for  I Think:
select * from (select acctno,custid,title,name,empeeno,reflresult,datereferral,
RANK() over(partition by acctno order by dateprop desc) as ranking
from #customer)b
where b.ranking=1...

Hi ,
This might be answer your are looking for :

select distinct a.productcode,
case when a.franchisegroup='B1' and a.franchisevalue=b.B1 then b.FranchiseCode
when a.franchisegroup='B2' and a.franchisevalue=b.B2 then b.FranchiseCode
else a.FranchiseCode...

Thanks Bro..

Thanks Thorn

Thanks Thorn ... I really appreciate your efforts . But I am not able to understand Cross Apply... Could you pls provide any useful link for it.. If you got...