I found my answer..

If I use the ODBC function TIMESTAMPADD() I can get what I need.

I've added the following and get exactly what I was looking for:

>= {fn TIMESTAMPADD(SQL_TSI_DAY,-2,getdate())}

I...

To the topic "are you experienced with performance tuning":

I am the T-SQL developer for my company but NOT a SQL Server performance tuning expert. Since I "live" in SQL everyone...

This is awesome!

I got this to work with my production data!!

Thank you very much.. I was tearing my hair out trying to get this done (and I have very little...

With our new server we installed SQL Server 2008 Standard.

I haven't even scratched the surface of it's features (SSIS, etc) but I LOVE the InteliSense that SQL Server 2008 has....