Yup - got it. Sounds like you already found the discrepancy, though - are you all set?

Then they're not user transactions. Check out what ALZDBA pointed out. It's background stuff.

No. not at all. In a cross join - there's no join criteria whatsoever.

In a FULL join,...

Name's Matt by the way.

What are you trying to match this up to?

The statement earlier (The total number of users matching the date range is not the same...

Every time I hear "paging", I think "range scan"....which leads me to clustered index.

If you do have to be doing that amount of paging, that might be the time to...

Cross JOIN is also what is called a "cartesian product". Meaning - it essentially matches up every row of table X with ever row of table Y.

If you're sure you want to roll stuff back...just type ROLLBACK in a query, and keep hitting execute until it whines at you....

Of course - you could also try committing...

About the same as Gsquared - either should work, I think

select cityname as City, groupname as [Groupname],

isnull(subqty.qty, 0) as Qty

from (select groupid, group.name groupname, city.name Cityname, cityid

...

Are you looking to start from a list of all groups matched up against all cities? If not - where's the list of all groups by city?

Art - use Jeff's suggestion a few posts up. It's precisely to deal with issues just like that.

Meaning - use a "less than april first" syntax.

I'm thinking you should be setting each of those up as

bobJones.Customer

JaneDoe.Customer

BrianSmith.Customer

By using schemas (and associating those user logins with the correct schemas), you'd be able to write that as...

All right - you wanted it - you go it.... a 2 Million row table.(sorry - 1M was still a bit wimpy on this test).

Add the following expressions to this...

You're talking about cross-tabulating... Look up "SQL 2000 Cross Tab" and you'll come up with a bunch of examples, including this one:

http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/%5B/url%5D

I just had a Bladerunner moment....

"Do Jeff's DBA's dream of flying porkchops?"

Definitely time for...

I'm not sure differences that small are significant. I just ran it against something a bit bigger ( okay, a 2M row table instead of a 2K row table),...