ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Where have...

David Burrows (10/1/2015)

---

Many many moons...

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Where have you found ESB...

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

The Ale&Pie...

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

Here is a quick solution that fits nicely for simple usage.

😎

Your plan shows a seek for a double-wildcarded parameter...must play with this at home. Thanks for posting,...

The Ale&Pie on High...

This made me spill my ESB all over the Pub lunch

😎

Here is a quick solution that fits nicely for simple usage.

😎

Test data set for demonstration

USE TEEST;

/* Safe place to play in */

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.Person') IS NOT NULL DROP TABLE...

Here is a quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_SIZE INT = 365;

DECLARE @FIRST_DATE DATE = CONVERT(DATE,'20141231',112);

DECLARE @ZERO_DATE DATE...

andy 61637 (9/30/2015)

---

Can someone look over this script and tell me why I'm getting an "Incorrect syntax near 'Go'" error right at the line above the dashes

(about line 18)?

This...

WayneS (9/30/2015)

---

Luis Cazares (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

An unsolicited email has just dropped into my Hotmail inbox from a recruitment agency touting a permy dev DBA role in Soho (London)...

Brandie Tarvin (9/30/2015)

---

Grrr. The way he phrased his thank you. Yes, I piled on. But believe me, what I posted was far more polite...

ignacio.jose (9/29/2015)

---

This is odd. It's the first time I am using an aggregate with the OVER clause.

Running the script is fast less than 1 second but when I say...

Event

joshdbguy (9/29/2015)

---

I'm working on a complicated SSIS package in SSDT 2012. One of the final tasks requires me to send files to FTP locations. Unfortunately, the table that provides those...