roryp 96873 (10/6/2014)

---

Ha! Ya, a...

Steve Jones - SSC Editor (10/4/2014)

---

LutzM (10/4/2014)

---

Steve Jones - SSC Editor (10/2/2014)

---

Dev Updates:

Top priority for the IT team, which manages dev, is reducing SPAM. They are looking at integrating with...

Definitely the weekend. I guess it is time to take a break from SSC.

Congratulations to both Jason and Jack. Both are well deserved.

david.dartnell (9/30/2014)

---

Hi ChrisM@Work,

I am trying to better understand your solution, towards this end I have started with the inner most brackets -

SELECT DATEDIFF(MONTH, 0, GETDATE())

Upon first inspection I expected this...

BWFC (9/30/2014)

---

Four thousand plus points....

Anyway, could I possibly prevail upon the folks around here to do a little testing for me please. ...

GilaMonster (9/30/2014)

---

pietlinden (9/28/2014)

---

DECLARE @currMonthNum INT,

@lastDayMonth INT

SET @currMonthNum = DATEPART(MM, GETDATE())

IF @currMonthNum IN (1, 3, 5, 7, 8, 10, 12)

SET @lastDayMonth = 31

IF @currMonthNum = 2

SET @lastDayMonth = 28

IF @currMonthNum IN...

How silver spoon can you get???

david.dartnell (9/28/2014)

---

Hi Everyone,

I have written some SQL that is intended to populate a variable (int) called '@lastDayMonth' with the last day of the current month.

Instead of seeing a day number...

Well, it works great, now I just need to figure out what it is telling me.

I am curious about part of it. The QueryStatement column is blank in all...

I SO want to...

SQLRNNR (9/29/2014)

---

Not an XSL, but it is better than that.

Here is a deadlock shredder by Wayne Sheffield.

http://blog.waynesheffield.com/wayne/code-library/deadlocks/shred-deadlock-graph/

You can take the xml from the graph that is produced by XE and...

Any help here would be appreciated. I am going to go get sleep as I have been up all night (work nights here in Afghanistan).

Read up on RESTORE in BOL (Books Online). If you are doing reporting from the database it sounds like you maybe able to use the WITH STANDBY option.

Eirikur Eiriksson (9/24/2014)

---

Lynn Pettis (9/23/2014)

---

Eirikur Eiriksson (9/23/2014)

---

Try this for a size

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA ([ID number],DateOfArrival,DateOfDeparture)

AS (SELECT * FROM (VALUES

(2031,'2014-03-20','2014-03-26')

...