Ditto.

Doing some code cleanup today, running into lots of this

insert into <someTable>

select <a bunch of stuff>

...

Manic Star (12/8/2016)

---

Luis Cazares (12/8/2016)

---

Ed Wagner (12/8/2016)

---

Revenant (12/8/2016)

---

Kaye Cahs (12/8/2016)

---

Manic Star (12/8/2016)

---

crookj (12/8/2016)

---

Brandie Tarvin (12/8/2016)

---

Stuart Davies (12/8/2016)

---

Ray K (12/7/2016)

---

whereisSQL? (12/7/2016)

---

Manic Star (12/7/2016)

---

Ed Wagner (12/7/2016)

---

djj (12/7/2016)

---

Luis Cazares (12/7/2016)

---

Ed Wagner (12/7/2016)

---

DamianC (12/7/2016)

---

Revenant...

You don't need coalesce here. NULL values are neither equal nor unequal when compared to other because NULL is unknown. Does a bag with an unknown number of apples have...

I'm a little late here but actually started a solution on Friday that I just now had time to finish.

First and foremost: unless someone has an example of how...

Turner

patelxx (12/1/2016)

---

I am learning and new to CREATE FUNCTIONS - how to I add a WHILE LOOP in a function:

CREATE FUNCTION fn_list_the_number(@count INT)

RETURNS TABLE

AS

RETURN

(

WHILE (@count <= 10)

BEGIN

PRINT CAST(@count AS...

Some DDL and easily consumable data would help circumvent any confusion but here's some sample code to get you started. Thom referred you to a calendar table article - that's...

Ditto Grant's recommendation. I also like Idera's SQL Diagnostic Manager. It's been about 6 years since I last used it but, as a DBA I really liked it and the...

N_Muller (11/30/2016)

---

Alan.B (11/29/2016)

---

My solution can be totally optimized and simplified but here's a solution that uses DelimitedSplit8K (see the link in my signature):

You'll notice three UNION ALL's. The first query...

My solution can be totally optimized and simplified but here's a solution that uses DelimitedSplit8K (see the link in my signature):

-- your sample data

declare @table table ( Col varchar(100) )

insert...

Using this sample data:

CREATE TABLE #myTable (dt date UNIQUE NOT NULL);

WITH E AS (SELECT v FROM (VALUES (1),(1),(1),(1),(1),(1)) t(v))

INSERT #myTable

SELECT CAST(DATEADD(DAY, ROW_NUMBER() OVER (ORDER BY (SELECT 1))-1, '20140101') AS...

Very interesting read - I was not aware of this tool. Cool stuff - well done!

Of that only works with the "numbers dash numbers dash letters" formatting.

Plus it boring... My "just for the fun of it" solution answered (what I thought) was a more interesting...

First - If you are using SSAS 2012 then look at this link: https://msdn.microsoft.com/en-us/library/ms170208(v=sql.110).aspx (what you posted was for SSAS 2016).

Second, ignore the second link for now (the one...