Hello friends,
I'm trying to delete a bunch of keywords that are just clutter at this point. I wrote a code to identify which performances they are associate with (it gave me a cranky error when I tried to delete them because they're still associate with performances.)
Anyone have any thoughts on how I now remove them in bulk from those performances?
This is what I wrote. It returned about 150 lines:
select P.perf_code, I.tkw, T.description from T_Perf as P join TX_INV_TKW as I on I.inv_no = P.perf_no join TR_TKW as T on T.id = I.tkw where I.tkw in (203, 204, 205, 206, 207, 208, 209, 21, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 328)
Thanks!!
Nicki
You can do it keyword by keyword, season by season in Season Maintenance, but you can also modify your query to delete, replacing the select line with "delete I". Always in Test first!
Keywords and keyword categories should have an inactive option...
Hi Gawain,
Would I have to do "Delete (these keywords) from (these performances)?
Nope, you literally replace "select P.perf_code, I.tkw, T.description" with "delete I". That will delete every row in TX_INV_TKW that matched your query.
https://learn.microsoft.com/en-us/sql/t-sql/statements/delete-transact-sql?view=sql-server-ver16