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

Assuming Jason's interpretation of the OP's requirement is correct and the requirement was to have all the numbers in a single column separated by spaces (which looks correct but who...

Its...

I just deleted a table named dbo.deleteme from our Dev box. This upset some people. Nothing surprises me anymore.

rajemessage 14195 (11/22/2016)

---

this one has alias, so that u can find which col belongs to which table.

1) select * from abc where abc.abcid =(select top 1 xyz.abcid from xyz...