Forum Discussion

dariopalermo1976's avatar
dariopalermo1976
Copper Contributor
Feb 13, 2024

Help with delete query

Hi guys, I need help creating a delete query...   The table has 4 relevant fields:   ComputerName (nvarchar) LastContact (datetime) guid (nvarchar)   When something changes on the computers,...
dariopalermo1976's avatar
dariopalermo1976
Copper Contributor
Feb 23, 2024

Cheef87 

The select will only show this output:

 

rn

2
2
2
2
2

 

bye,

Dario

Cheef87's avatar
Cheef87
Copper Contributor
Mar 04, 2024
Sorry just seeing this. You just need to include additional columns in your CTE to see more about the rows that are being deleted.

Resources