SELECT DISTINCT(USER_ID) FROM marketing_dataset WHERE EMAIL_CAMPAIGN IN

(SELECT TOP 1 WITH TIES EMAIL_CAMPAIGN

FROM marketing_dataset

GROUP BY EMAIL_CAMPAIGN

ORDER BY SUM(REGISTER_WEBINAR)/COUNT(DISTINCT (USER_ID)) DESC)

Thanks a lot man, You guided me to solve...

Jason Selburg (6/27/2011)

---

The 'ID' column in the Generation CTE is an Alias for the Mother and Father fields in the source table. You can also write it like this ...

--...

I was able to find a solution for the problem and I am posting the same for the benefit of others:

http://msdn.microsoft.com/en-us/library/ms175972%28SQL.90%29.aspx

Look under section J of the article....

Sorry for the missing info. FYI all 3 columns are nvarchar(max). Table name is WODetails.

I am re attaching the sheet with updated info.