Here is my scenario:
I have a table with around 100 columns. I want to loop through all the columns and extract all the records where 10 of the columns are NOT empty/null and the other 90 ARE empty/null.
How do I write a stored procedure to do this? By the way, if it matters, I am still on SQL 2000.