Thanks a lot. That works.

Thanks a lot for all the replies. Much appreciated. I am going to remove the sub queries and see how it works. Will also ask the DBA for the execution...

I am trying commands separately to understand. Will update if I have any questions.

Thanks a lot. Much appreciated.

So far this solution gives me the result I am looking for. Much appreciated. Will be testing this with live data. Again apologies as the requirement was changed in the...

Thanks for the response. Much appreciated. It worked for that sample data because the dates were the same.

When I have different dates, it resets the counter.

My apologies, if I am...

Is it possible to make the count start only for non XXX. With the following sample data, column gives me 3 and 4. But I want it to give 1...

Thanks a lot for the response. Works great.

Unfortunately, there is no sort order. This is a 3rd party database. I don't have control of how they save data. Script should go through the data and take the...

Agree 100%. Will do the needful next time. Already got another one about a script that I did. Just putting everything thing (with the code that I already wrote). Appreciate...

• This reply was modified 1 year, 7 months ago by  don075.

Thanks for the response. I am a bit newbee when it comes to sql. Still learning.

Great. Thanks for the reply. Works well.

Sorry, my bad. It works. Thanks for all the replies.

Thanks for the reply. I am getting Incorrect Syntax near ')'

;WITH CTE AS
(
    SELECT DISTINCT [VID],[OrdDate],[Prg1],[Prg2],[Prg3],[Prg4],[Prg5],[Prg6],[RowUpdatDateTime]
      FROM #new
),
CTE2 AS
(
...

Thanks for all the replies. Much appreciated.

I agree that I don't need to compare data in the new table with the existing one.

I created a temp table to test the...