We had a similar issue. I used the Shrink file option in SSMS - "Empty file by migrating to other files in similar filegroup." That worked for us. We were...

Matt,

It was a silly mistake on my part. Your (and GSquared's) query works just fine and the numbers match up.

Thanks a lot for your help.

- sg

Matt,

Unfortunately not.

Now that I understand what Cross join is supposed...

Matt Miller (3/13/2008)

---

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...

Thanks Matt & Gsquared for the explanations. Learnt something new... can't believe I've been doing Sql for so long without knowing this.

Thanks for pointing that out.. I feel so stupid not to notice that.

The sub-query returns the right number of rows. I had fixed the where clause when I tried your suggestion to use >= & <=.

So that's the same as "Full join" right?

Thanks for the reply "Hall of Fame".

This one doesn't seem to work as well (the same as gsquared's). The number of rows returned are fine but totals don't match up.

Thanks for the reply gsquared.

The number of rows returned are correct... but somehow the count is messed up. I am trying to figure out why. The total number of users...

That's right.... I am trying to get a count of users for each of the groups in each of the cities. So if there are no users in Marketing group...

RBarryYoung,

Thanks for the prompt reply. But that doesn't work. It brings back users only for cities and groups that match the date criteria. If there are no users in a...