Thanks for your reply on my question Lynn. However, I have got only read only rights on the database. Cant alter the definitions.

Is there a way I can achieve my...

Thank You. That should help.

I will try that way and will let you know if I encounter any challenges ahead.

Thanks,

Prasune

Thanks Sunil.

That looks quite a handy and easy approach. I will definitely give it a try.

However, as of now I am using a different approach of triggering the Subscription IDs...

Thanks Neeraj, It was my lack of pre-knowledge on CTE which was preventing me to interpret your suggested solution correctly. I googled about CTE and then came back to apply...

I am sorry Neeraj, but unfortunately that does not work.

Ok, can u please give me a query to just increment the 'Time_In' value by 1 minute whenever the 'RO'...

This is the error that I got:-

"Recursive common table expression 'DTAGatHERTZ_RO' does not contain a top level Union All operator."

I had tried this:

WITH DTAGatHERTZ_RO

(RO,Time_In,Ranking)AS

(SELECT RO,Time_In, Ranking = DENSE_RANK() OVER (PARTITION...

Thanks for your reply Neeraj and my apologies for the delayed response due to the Weekend.

I tried your solution but unfortunately it gave me some errors.

I have attached the...

Yes Hugo, thats right. I am using SQL Server 2005. Thanks for the info. 🙂

I got the answer right but only after removing 'Null' from the declaration of the Local Variable.

When I parse my declaration of the Local Variable, it says "Cannot assign a...