Need to use cursor?

[sds814]

I have a table with the table name, column name, column values and whether the column values should be included or excluded.

This table is used to filter what data should be loaded. Here is an example

TableName ColumnName ColumnValue Include/Exclude
tblProduct ProductID 1 Exclude
tblProduct ProductID 2 Exclude
tblProduct ProductName Keyboard Include
tblProduct ProductName Mouse Include
tblOrder OrderID 1 Exclude
tblOrder OrderID 2 Exclude
tblOrder OrderName PackageA Exclude
tblOrder OrderName PackageB Exclude

So the queries should be:

DELETE FROM tblProduct WHERE ProductID NOT IN (1,2) AND ProductName IN ('Keyboad','Mouse')

DELETE FROM tblOrder WHERE Order NOT IN (1,2) AND OrderName NOT IN ('PackageA',''PackageB')

Do I have to use a cursor to loop thru each of the column name and filter on the column values?

 

[1DMF]

I'm not sure I understand the what you are asking, but this might help with your Cursor conundrum :

http://wiki.lessthandot.com/index.php/Cursors_and_How_to_Avoid_Them

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music