Skip to content

Instantly share code, notes, and snippets.

@swaters86

swaters86/RemoveReports.sql

Created July 15, 2015 18:30
Show Gist options
  • Save swaters86/e67c056e38cac64e2e4c to your computer and use it in GitHub Desktop.
Save swaters86/e67c056e38cac64e2e4c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
RemoveReports.sql
/* Logically delete the report */
UPDATE ChangeGear.dbo.CG_ReportEntity
SET GCRecord = 12345
WHERE NAME = 'New Pie Chart'
/* Check the GCRecord field for the report record*/
/* If it's null, then that means it's not deleted */
/* If it's a numeric value, then that mean it is deleted */
SELECT GCRecord
FROM ChangeGear.dbo.CG_ReportEntity (nolock)
WHERE NAME = 'New Pie Chart'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment