very nice.. very good query.. outstanding .. good knowledgeable.. thank you very much:-):-):-)

i tried below query .. this is not working .. Could you suggest correct change? Thanks

WITH LatestDates AS (

SELECT

[MDDS01_MDD_STORE_GU_D]

,[MDDS01_CATALOG_D]

,[MDDS01_LAST_UPDT_S]

,ROW_NUMBER() OVER (PARTITION BY [MDDS01_CATALOG_D] ORDER BY [MDDS01_LAST_UPDT_S] DESC) AS RowNo

FROM...

Hi John,

Any luck?? Thanks

yes.. SELECT statement is to see latest timestamp rows..

DELETE statement is for to delete older timestamp rows and which will keep latest timestamp rows.. this is fine.

before going to execute...

Hi John, Thank you very much for delete query.. how can I ensure which records will get delete by this query? I want to verify data before deleting. Could...

apologies.. pls ignore my previous post about NULL comment.. Thanks

sorry.. pls ignore..

thank you very much for the delete script.. i'm just testing it ..will come back.. thanks you once again

Did you got what I posted??? Thanks

we have are having total 1600 NULL value rows. I could not share all these in insert statement to you. so I gave 5 NULL rows. becoz of more NULL...

Thank you John.

Both the queries are working. but it is giving 2 rows instead 1 row for NULL values for column [MDDS01_PORTFO_D]. one row is having latest timestamp as...

Hi Drew Allen,

Thank you very much for the answer. Sorry for my previous question. Now, again, i posted my requirement as below with DDL, DML. Please assist to get...

Thanks for the response. So, where can I post my requirement? Bcoz I need it. Thanks in advance..