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...

I have a stored procedure that accepts start and end date as parameters.

In my VSS project, I selected "Import From Data Source"

Select Microsoft SQL Server

Selected "Write a query that will...

Thanks for all the replies. Will check this out. I have 2 databases (SQL and Oracle) with identical tables. Hopefully this will work with Oracle too. Fingers crossed.

I just tried to simulate the issue. So didn't create any indexes. Indexes are on VID, AcNo and Orddate

It will be easier to delete and insert a row than update...

Excellent. That's exactly what I was expecting.

Thanks for the suggestions. Much appreciated.

That will reduce the displayed no of rows. I still want to see all the rows and the where condition should be applied only for the count.

Thanks for the reply. How do I add the where condition to it (where t1.[Prg1]='P1')?

Thanks for the response. Will contact the vendor.

All tables in the database should keep data only for 15 days. There is an automated task by the software vendor to delete data older than 15 days. But this...

Thanks for all the replies. Much appreciated. Yes the date value could be the same for many records. Unfortunately, I don't have any other data to uniquely identify each row....

Thanks a lot for the replies. It works.

Thanks. Almost what I need. Is it possible to compare the values? If the same value exists, I don't want it to count.

insert into #t1 values('11111','2022-01-10 13:37:06.000','P1','P2','P3','','','')
insert...

Thanks for the response. Unfortunately, I have no control over the data. It's a 3rd party database. This is how they designed it.

Your solution groups by vid and orddate.

What I...

• This reply was modified 2 years, 5 months ago by  don075.