It would help us if you could post the tables definition, sample data and required output from that data!!

You can't sum on a bit datatype as far as I remember!!

Anyways isn't this what you needed?

Ya that works great for dataflow... but I was under the impression that he just needed to know the existense and work with the flow in th application... maybe my...

Maybe it would be a tad faster to use the return parameter and not create a dataset at all but I don't know how much more speed you're gonna get from...

DECLARE @PageSize INT --How many rows to appear per page

DECLARE @PageNum  INT --What page number to appear

DECLARE @Skip     INT --Working variable for where to start for page

DECLARE @sql     ...

Just curious.  Have you tried using static sql and using a temp table to extract the first derived table then use not exists with that table??

Pretty much unlimitted (32,767 is the limit per server but I've never seen anyone need that).

Wouldn't this be a case where a cube might come in handy (sorry but I cna't offer more than that)??

Don't worry about the newbie thing, we all started there some day . However I have no idea how to fix that problem...

It's very nice but it would be even greater if you could include the "save the db someday" part .

I've never seen such a need... Why do you have to put the whole db case sensitive?

Sorry but not idea... I'll leave that one for other dbas.

How large is the clustered index (columns definition)?

How many indexes do you have on that table??

What is the databases recovery mode?

Thanx... forgot to type that .