ALZDBA (2/11/2008)

---

Learn to work together with your SAN-admin(s).

Don't exceed thier level, but hand over the needed hints, so they can figure out for themselves your guidance makes sence !...

Ok... what would you do to return more information from each row using that method?

Heh... I guess I get carried away a bit on the "little" stuff, Johan. 😉 But, you're correct... it's a crucial error that both Newbies and those that write...

Dunno what to say... like I said, the following code which you posted, works fine on my machine... no errors of any sort...

[font="Courier New"];WITH T1 AS

( SELECT CAST('2007-01-01' AS DATETIME)...

Of course, not being always swayed by "official" documentation, I've tried it... only to be frustrated by the very same error messages as Kalhara was. I'd have to agree...

Ok... understood...

Run the following query from SSMS and let's make sure that the "server" (your Developer's Edition) can see the file...

EXEC master..xp_fileexist 'C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll'

I know... you said that before...

WHICH MACHINE is that on! Is it on the SQL Server or on your DESKTOP computer?

Now we're talking! Verifiable documentation from MS (usually) works for me! Thanks, Chris!

Heh... maybe the 3rd time will be the charm...

PLEASE copy and paste the exact error you're getting... I get no errors when I run the code you posted in the...

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.