Sort by Year, month

You can use expressions in the browse to or drill down functions.

Go in the options of a textbox, then action...

let us know if you need further...

Ya, I just realized that I'm picking only in the same month... sorry about that.

Thanks Michael.

I understand that. I guess I just misunderstood part of the requirement.

So you're all set?

Here you go. But I'm not sure this is what you want to do. You were talking about groups and I see nothing about that in the query.

DECLARE...

It just came to me that I can actually hand you the data over. It's not like it's proprietary or anything. :hehe:

You'll just have to edit the holiday names...

Just for the sake that you may use this join often in your report(s). You might want to add this index to speed up the self join.

CREATE NONCLUSTERED INDEX...

Here's the query. I'll post my Calendar definition too but I lost the script that loaded it.

SET DATEFORMAT YMD

DECLARE @test_dt DATETIME

SET @test_dt = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) ...

Grant Fritchey (5/17/2011)

---

Excellent! I didn't want to bring it up, but this is a perfect solution, and one that uses very few disk resources to give you...

Do you have a calendar table?

Eric M Russell (5/17/2011)

---

There is only a 53 point spread between "Say Hey Kid" and...

When you disable a constraint like a FK or check, the server marks it as untrusted because there can be some bad data in there.

If you reenable it with NOCHECK,...

Ninja's_RGR'us (5/17/2011)

---

It's one of the errors in ss that leaves very little room for interpretation :hehe:.

The only other option I was considering was an untrusted constraint that previously had the...

It's one of the errors in ss that leaves very little room for interpretation :hehe:.

The only other option I was considering was an untrusted constraint that previously had the error...

that can still be done in t-sql.

Put the results into #temp table.

Then delete where grouping in (SELECT Group from #tmp group by Group HAVING SUM(transaction) > 0)

The filter is still...