Lynn Pettis (8/6/2012)

---

rodjkidd (8/6/2012)

---

Koen Verbeeck (8/6/2012)

---

opc.three (8/5/2012)

---

WayneS (8/3/2012)

---

Steve Jones - SSC Editor (8/3/2012)

---

FYI, since some of you submit questions. I'm no longer accepting images of code.

Please feel free to debate...

Try this

http://msdn.microsoft.com/en-us/library/ms175495.aspx

2011-12-182011-12-192011-12-202011-12-212011-12-222011-12-232011-12-24

Sunday Monday Tuesday WednesdayThursdayFriday Saturday

Now let me ask...

Is this what you are looking for:

DECLARE @d DATETIME

SET @d = '2011-12-24' -- user passed value

SELECT SUM(Salesweek)...

JasonRowland (8/4/2012)

---

Ok, I think I understand why this is. There is an implicit conversion from varchar to int and you might think that when converting '' to int it would...

As previously stated you can use CAST or CONVERT. But like many items in T-SQL "It depends". As an example ... be aware of your system date...

+1 Me

And forget about my E statement was made tongue in cheek ..

A. I consider the QOD as...

WayneS

I was checking SQLSat156 (Providence, RI) to see if the speakers had been selected yet, and I count 5 Threadizens that have submitted for it. Sure would be nice if...

I am rather surprised at the low percentage of correct answers.

And the implications this could have to those designing...

Nice thanks added it to my SANDBOX for future use

Try reading this to see if it helps you, if NOT come on back and someone can give you further assistance

http://msdn.microsoft.com/en-us/library/ms188790.aspx

Although the link is to a reference to sQL 2005,...

Nice easy question to start the week ...

L' Eomot Inversé (7/28/2012)

---

Nice easy unambiguous question.

A restful finish to to the week (for some), and a pleasant start to the week for others.

Published a little before its...

Rose Bud

Thanks