Hi friends!!

I want to simulate the DISTINCT clause in SQL SERVER 2000 using a single SQL query or nested SQL query. Basically, I have a table containing Campaigns for Prospects(ssProspectCampaign). The "ssProspectCampaign" table contains record like :

Campaign CampaignName ProspectName
ID
----------------------------------------
1 Aviva Frenkel
2 Bahamas Promo AON
2 Bahamas Promo Marsh
3 ASPSalesource AON
4 ICICI Ebix
5 E-Global HSBC
5 E-Global Marsh
6 Auto Ins AON
7 Bajaj Cap Frenkel
8 Worker Comp HDFC
9 Commercial Ins AON
9 Commercial Ins Marsh
10 New York Max Marsh
        LifeIns
Now, I want all the campaigns and their names but I want them
to appear only once and I want to do it without the "Distinct" clause....Can somebody help...I'm trying hard on it.

thanks



cheers,
debsoft

__________________
cheers,
debsoft

Why don't you want to use distinct? What you are asking is a little like saying I want to run in a marathon but I don't want to use my legs. There are ways of doing this, but distinct would be the best way to do it.

regards
David Cameron

Hi Cameron!

Thanks for ur very fast response...I just want to simulate the Distinct clause in SQL query...I mean just wanted to find some alternative to it...Actually I was aksed this question by someone before but at that time I didn't hve any answer to it...nor do I hve a valid answer now...just trying hard to think a solution to this...Do you have any method by which one can simulate Distinct???

Thanks

cheers,
debsoft

i think you can use group by:


select PC.[Campain ID], PC.CampainName
from ssProspectCampain PC
group by PC.[Campain ID], PC.CampainName


defiant.

Would this work?

SELECT CampaignName, COUNT(CampaignName)
FROM <TABLE>
GROUP BY CampaignName

Then get rid of the second column

Hi Ioates!

Thanks for ur reply...I think it wud work fine.

cheers
Debsoft

This does still leave us with the original question. Why don't you want to use distinct?

regards
David Cameron