To add to the confusion, here is a BOL page that states there is always exactly one system endpoint: sys.endpoints. On the same page, it also states "An...

Ahhhhhhhh. Thank you Stefan. I wasn't thinking about the ASCII value of a space, even though you put that in your note. It makes perfect sense, and now I can...

Thanks Stefan, I didn't know that it padded the strings out before comparing. I don't understand how that changes the way the sort works though - wouldn't it still...

A good observation. I thought about going with a varbinary field, but hesitated due to concerns about readability (to check what was in the field) and sorting, but maybe...

If no one has any ideas, does the result at least look as odd to you as it did to me? Or am I just crazy and missing something...

Made me think...

The Dixie Flatline (7/22/2010)

---

Try to find an online server for "Diplomacy". Similar in concept to Risk, but no luck is involved. Only one turn per day,...

I've done something similar with Chess (+ more than a dozen...

WayneS (7/22/2010)

---

Please don't.

For every whiner there are 100 people* who are glad to have a QOD to look forward to every day.

I got...

I'm going to take a guess and give you the outline for an answer, hopefully this is something close.

Try this code:DATEADD(MINUTE, (DATEDIFF(MINUTE, 0, MyDateField) / 30) * 30,...

Thanks for the question Jghali. Didn't know about the UDF part, so I picked up something new today!

Chad

Yup, very disappointing. Been watching for over 10 years now and...

In order to get the value, you need to grab the output from the stored proc, like this: DECLARE @newID int

EXEC @NewID = dbo.usp_GenPK

SELECT @newID

I used INTs since I don't...

I missed it too - I took a guess at what the question was trying to test and thinking it was something else missed the question. Oh well. ...

Oh no - don't answer all the questions. Just take a look and see if anything jumps out at you. I'm thinking the first one might be the...