Results 1 to 5 of 5
Dec 27, 2004, 06:10 #1
- Join Date
- Jul 2004
- 0 Post(s)
- 0 Thread(s)
MS SQL: How do i count the empty columns
how do i count the empty columns in a table and assign it to a variable.
I have a table in my db, that keeps the items a user makes in his selection/subscription for items available.
1. there are a maximum of 6 options a user can subscribe to.
2. Minimum of 1
Once a subscription is made, the options are kept in a table e.g.
Now, if a user subscribes to a maximum of e.g. 3 or 4.
I would want to be able to count, the number of empty columns and the number of subscriptions and assign it to a variable.
How do i do this EFFICIENTLY