Hi,
Could you please elaborate reg what you did in that query as I am not getting it?
You can please provide the acript for the tables you are using so that at least we can execute the query to see the result.
I am working in SQL server 2005.
Thanks & Regards,
SS