Slightly confused, exactly what are you looking for here, a count of records for today, yesterday, and the past 7 days excluding today?

As this is in a SQL Server 2008 forum, another option:

with Latest_Transactions as (

select

row_number() over (partition by AcctNum order by TransactionDate desc) as rownum,

...

Have to agree, it would have been nice if there had been more on creating the WMI alert. Others (like me) may have benefitted from the information.

crookj (5/6/2010)

---

sing4you (5/6/2010)

---

Don't forget Texas. It may be hell to...

If you figured it out, proper forum ediquette would have you post your solution. Others may have a similar problem, and your solution may...

GilaMonster (5/6/2010)

---

Lynn Pettis (5/6/2010)

---

GilaMonster (5/6/2010)

---

Lynn Pettis (5/6/2010)

---

I have asked questions for clarification and not come back, but usually it's because others have jumped in and helped, just not needed then...

CirquedeSQLeil (5/6/2010)

---

Lynn Pettis (5/6/2010)

---

Jeff Moden (5/5/2010)

---

Something that people either aren't aware of or have forgotten... the option of in-house training by the resident experts is a powerful tool that's...

Jeff Moden (5/5/2010)

---

Something that people either aren't aware of or have forgotten... the option of in-house training by the resident experts is a powerful tool that's frequently over looked....

MeltonDBA (5/6/2010)

---

I would start with this matrix of SQL Server 2008 features:

http://msdn.microsoft.com/en-us/library/cc645993.aspx

(1) SQL Standard edition if you want the BI and SSIS tools.

(2) With the small number of users I...

True, but looking at the Sales and SalesOverride tables, just made sense to qualify it so that it was clearer.

I use a similar technique for permissions overrides in a process...

crookj (5/6/2010)

---

Lynn Pettis (5/6/2010)

---

crookj (5/6/2010)

---

CirquedeSQLeil (5/6/2010)

---

bcsims 90437 (5/6/2010)

---

CirquedeSQLeil (5/6/2010)

---

Lynn Pettis (5/6/2010)

---

Actually, the problem is I'll need a vacation from the vacation. A week from Sunday will be 14+ hours...

GilaMonster (5/6/2010)

---

Same, sometimes because...

crookj (5/6/2010)

---

CirquedeSQLeil (5/6/2010)

---

bcsims 90437 (5/6/2010)

---

CirquedeSQLeil (5/6/2010)

---

Lynn Pettis (5/6/2010)

---

Actually, the problem is I'll need a vacation from the vacation. A week from Sunday will be 14+ hours of driving (coming...

Lowell (5/6/2010)

---

-- COALESCE returns the first non-null value from the list provided; it is a param array, so an large number of arguments can be passed to check for non-nulls.

SELECT...

CirquedeSQLeil (5/6/2010)

---

bcsims 90437 (5/6/2010)

---

CirquedeSQLeil (5/6/2010)

---

Lynn Pettis (5/6/2010)

---

Actually, the problem is I'll need a vacation from the vacation. A week from Sunday will be 14+ hours of driving (coming home...