Cheese

Jason A. Long (12/4/2015)

---

here's a different option...

IF OBJECT_ID('tempdb..#Dates', 'U') IS NOT NULL

DROP TABLE #Dates;

CREATE TABLE #Dates (

WeekendDate DATE

);

INSERT #Dates (WeekendDate) VALUES

('11/01/2015'),

('11/08/2015'),

('11/15/2015'),

('11/22/2015'),

('11/29/2015');

IF OBJECT_ID('tempdb..#Product', 'U') IS NOT NULL

DROP TABLE...

SQL-DBA-01 (12/4/2015)

---

Hello Experts

Can you please tell me what happens in this scenario?

I have a database for which tlog backup job is configured to run in every 15 mins. Now one...

A SELECT TOP 1...ORDER BY would also do the trick.

Nice work, Jason. I like the way you questioned BOL and looked at actual data to find the answer that lies beneath the answer.

Wabbit Season

Brandie Tarvin (12/4/2015)

---

Luis Cazares (12/4/2015)

---

Jeff Moden (12/4/2015)

---

Is anyone else not getting notifications from posts? I haven't gotten a 1 since Nov 29th. I sent an email to the...

crookj (12/4/2015)

---

Season

Glad to be of help. Thanks for the feedback.

Good question. I still like the datetime data type.

Brandie Tarvin (12/4/2015)

---

Ed Wagner (12/4/2015)

---

SQLRNNR (12/3/2015)

---

Lynn Pettis (12/3/2015)

---

SQLRNNR (12/3/2015)

---

Lynn Pettis (12/3/2015)

---

Walk away, yes, that individual did start a CTE with a semicolon, just let it go...

Party in the TitD! ...

No, the CTE was just a demonstration of how to hit a column. You can run it against a table by replacing the CTE with your table. Example:

SELECT...

SQLRNNR (12/3/2015)

---

Lynn Pettis (12/3/2015)

---

SQLRNNR (12/3/2015)

---

Lynn Pettis (12/3/2015)

---

Walk away, yes, that individual did start a CTE with a semicolon, just let it go...

Party in the TitD! Let's blow off so...

Reader

Jeff Moden (12/3/2015)

---

himanshu.sinha (12/1/2015)

---

Thanks Jeff for the idea of putting the while loop in TRAN , I think I understand the logic behind that . I hope if anyone...