Hugo Kornelis (12/1/2015)

---

I missed the most important correct answer: you'll get fired. 😀

Luckily Shane does indicate in the explanation that using this type of table names is not a good...

As usual, a great question Hugo, but even better are your explanations!

I have no link for "documentation" per se, but this page has a nice example of a pass-through situation...

nickm_GR (11/10/2015)

---

Thanks to everyone for the thoughtful answers. I wish I was insightful enough to have thought through the scenarios that percolated up in the replies.

Why question was much simpler...

Here's another approach: convert the integers for run_date and run_time to an actual DATETIME value, then compare using a standard date-time clause. Warning, functions in WHERE clause predicate. ...

g.britton (11/3/2015)

---

This might do it:

SELECT j.NAME

, s.next_run_time

FROM dbo.sysjobschedules s

CROSS APPLY (

SELECT datepart(YEAR, getdate()) * 10000 + datepart(MONTH, getdate())...

Jeff Moden (11/9/2015)

---

Rich Mechaber (11/9/2015)

---

Jeff Moden (11/6/2015)

---

sknox (11/6/2015)

---

Luis Cazares (11/6/2015)

---

Rich Mechaber (11/6/2015)

---

Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think...

Jeff Moden (11/6/2015)

---

sknox (11/6/2015)

---

Luis Cazares (11/6/2015)

---

2...

Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations are straightforward.

Rich

Ooooooookay, I think we've learned something here: Steve hasn't had his coffee yet today.

😉

Hugo Kornelis (10/26/2015)

---

The explanation tells you where the problem is, but not what it is.

[font="Courier New"]select '19.4615381' * -1.0;[/font] uses constant expressions, for...

Got it right, but only because I read the question too quickly and was looking for "1" as a possible answer, b/c I thought the question read "How many rows...

hlsc1983 (12/16/2013)

---

this is my first SQL server project.. student registration system using SQL server 2008 and VB.net.

can you please help me in designing the database?

the system will be...

Awesome, thanks for the question, I learned something from this:

I didn't realize you could DROP multiple tables with a single DROP statement (DROP TABLE #t1,#t2,#t3);

😉

Rich

Xavon (8/28/2015)

---

rmechaber (8/28/2015)

---

Easy question, though I did have to think about it, as other combinations not provided as QotD options would have worked: 1, 3, 2 for example. Strip...

Easy question, though I did have to think about it, as other combinations not provided as QotD options would have worked: 1, 3, 2 for example. Strip out foreign...