david.wright-948385 (11/17/2009)

---

Lynn Pettis (11/17/2009)

---

Dietmar Weickert (11/17/2009)

---

... finally trying to argue that the whole thing were for educational purposes is even more cynical. I hope nobody ever had or will have...

Don't know. Can you post the DDL you used to create the schemas?

English please?

Your problem is you are trying to pass the name of a table as a paramater, or as a variable. You can't use a variable in the FROM clause....

Try this:

CREATE FUNCTION dbo.fnTest ()

RETURNS int

WITH SCHEMABINDING

AS

BEGIN

RETURN 1

END

GO

I disagree. To answer...

Toreador (11/17/2009)

---

Ah, that old chestnut.

I've never been Prime Minister either, but I still get to say what I...

Daniel Wood (11/17/2009)

---

Thanks for the replies

More information

Buffer cache Ratio seems to be 90 - 96

There is also an issue with high IO on the data drive which the System team...

Toreador (11/17/2009)

---

Lynn Pettis (11/17/2009)

---

Yes, getdate() and getutcdate() return different values, just look at what they return when you run them. However both functions return values that are equivelent to...

ARRRRGGGGGG!!!!

I'm heading out to the desert for a while just in case you don't see me for a few days.

david.j.campbell (11/17/2009)

---

You on the same longitude as Greenwich England, Bitbucket?

This is the first time I can think of that I've been discriminated against based on my geography.

While the values may...

Okay, I give up. No one is really paying attention to the concept that the question was trying to bring out. Everyone is concentrating on the actual values...

Cliff Jones (11/17/2009)

---

I work with date time functions all of the time and would contend that since the Time Zone is not returned as part of the result, the times...

7:00 AM <> 2:00 PM, true

7:00 AM MST = 2:00 PM UTC, true.

That is the concept that the question is trying to address.

Been there, done that in other areas. Not a biggie.

😉