The second problem I am having is more complex. I am trying to figure out 2 things.

1) How to get the column headings (and totals)

2) How to have a report...

I am having a problem getting this to do what I want... First problem, I cannot seem to get the procedure to take a query as an argument in parenthesis...

This looks like a pretty good solution. I will play with it.

CREATE TABLE dbo.Flags

(

position INT ...

I was trying to figure out if there was a way to do it without every possible combination.

For example, suppose the values available are 2, 4 and 8 (just to...

Of course, now I had to do the other table so that I could not accidentally delete a record that is being referenced.

It would be nice if there were...

I did a little more testing, and came up with a simple solution using a trigger:

CREATE TRIGGER [dbo].[BitTrigger]

ON [dbo].[Table2]

FOR INSERT, UPDATE

AS BEGIN

DECLARE @Result BIT

DECLARE...

Brilliant!

This is awesome, much easier to code, and very fast. Thank you SO much!