SELECT * FROM mytable

WHERE Date between dateadd(dd,-10,getdate()) and getdate()

What is a reason for passing a complete statement as a parameter, what are you trying to accomplish?

In our company we have a separation of duties. Our DBA don't do development. On our development team we have a very knowlegable boss who actually knows DBA part as...

This is datawarehousing termin : ETL - Extract, Transform and Load.

Not really familiar with this.

For the @SQLText part:

If you using the same value over and over again create a variable to hold this value:

declare @Maxdate as datetime,

...

What are you trying to do - pass a delimited string of parameters and then process each as separate parameter or include in a search like

select smth from...

Try to build a query string (@sqltext) and then execute it thru the EXEC (@sqltext) or SP_EXECUTESQL @sqltext

quote:

---

Was there a scecific script you were refering to that show how to process incoming mail queries?

-JG

---