I have reports under a company where if they are unchecked, they should be deleted. To do that, I wish to write it in SQL but I am unsure of how to write whether a report id is checked or unchecked in SQL.
This is my pseudocode,
valsql2 = valsq2 & ";DELETE FROM CompanyReportListTable WHERE ReportID <> chk"
How would I delete an unchecked report in SQL or delete all noncheckpoints?
Aucun commentaire:
Enregistrer un commentaire