I'm going to say this so that everyone gets the point... 😉

No, No, No, No!!!!

Now that I have your attention, the reason why I'm being so adamant is because...

All good replies... but they all seem to miss the mark a bit. This question seems to be more about what you can and cannot do with variables in...

All good conversation and good information from all. Guess the answer to the OP's question should be, "Yes" or maybe even "Yes, most definitely". 😀 Some of...

Dennis D. Allen (2/6/2008)

---

What do folks think about adding directly to a datetime and allowing implicit conversions to take place?

CREATE FUNCTION dbo.DateRange( @start DATETIME, @length INT )

...

jerryhung (2/6/2008)

---

Weird, your CTE code took 16 seconds (twice) on my SQL Server

that is not VERY VERY fast. Anyway, we don't have the need for it, I was just curious

16...

The server needs to be able to "see" and "read" your "specified folder". That's why I was asking what its physical location was.

Good luck.

AM,

Ian is absolutely correct... for very small groups of rows by account, the example he gave will work just fine albeit a little slower than you may expect (just as...

Is that file path on the server... or on your desktop box?

"New" view, available in 2k5, is called sys.Objects and will likely be available in 2k8, as well.

I don't think I wrote an article on "DateDiff Usage"... so it would be interesting to find out how my name got on this...

Anyway, nice trick you've found. I...

And, maybe learn how to post sample data to get better answers...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Heh... right there with ya, Gus... seems like the long way to spell "Death by SQL", though 😀

That should do it... nicely done, John.

You said that you wanted to pass parameters to the stored procedure in the trigger. That smacks of RBAR and single row processing which is a form of "Death...

Then, you need to post the exact code you're getting the error with and the exact error... because the code I posted gives no such error on my machine. ...