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...

Hair

aymanahmed88 (9/29/2015)

---

i design SP for insert data in 2 tables

i need to store list of array in one parameter to complete my query

i try the table value but...

Grant Fritchey (9/29/2015)

---

For queries, execution time and the number of reads. I do use extended events for this all the time now. I've found that STATISTICS IO tends to mask...

Thanks for this nice piece Luis!

😎

rwitt 95744 (9/28/2015)

---

Greetings, all.

I'm curious what are the most important/relevant stats, query plan aspects, etc., that you look at, when trying to determine if one T-SQL coding approach is more...

Since it...

Quick thought, the posted solution works but it imposes quite a lot of work which can be avaided, here is a more efficient alternative.

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'sbo..#demo') IS NOT...