Could you post the actual SQL you are trying to generate. I'm a little lost from the what you posted and knowing what the final result that would be...

If you are splitting a VARCHAR(MAX) or NVARCHAR(MAX) string, you should look at using a CLR splitter instead of a T-SQL splitter.

Please check out this article for information: http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Also, in...

Sergiy (1/11/2016)

---

Kedazs (1/11/2016)

---

Yes. I also use CTE's to "clean up my code". Especially if it is something being called multiple times within the select. I do not think...

Eirikur Eiriksson (1/10/2016)

---

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to convert this into...

Jason A. Long (1/8/2016)

---

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to convert this...

Tallboy (1/8/2016)

---

Hi Guys,

Looking for a cte which will list all dates between 2 dates 7 days apart. May want to change to 14 days apart later.

Here is my code....but gives...

TomThomson (1/8/2016)

---

Brandie Tarvin (1/6/2016)

---

djj (1/5/2016)

---

There all over the internet.:-P And I...

simon-hulse (1/8/2016)

---

I'm new to posting on this site although I have worked with SQL for over 20 years I tend not to post as 9/10 times you end up in...

simon-hulse (1/8/2016)

---

I'm new to posting on this site although I have worked with SQL for over 20 years I tend not to post as 9/10 times you end up in...

Sergiy (1/7/2016)

---

Compare...

You have to remember that many times threads go off on tangents, and sometimes the tangents actually impart knowledge that may not have been provided otherwise.

I don't believe that this...

Toreador (1/7/2016)

---

Rich Mechaber (1/6/2016)

---

This, for example, throws an error:

SET LANGUAGE british

SELECT CAST('2003-02-28' AS datetime);

Server: Msg 242, Level 16, State 3, Line 4

The conversion of a char data type to a...

Stephanie J Brown (1/5/2016)

---

mjh 45389 (1/5/2016)

---

Stephanie J Brown (1/4/2016)

---

I'd like to learn more of the "language of business", so I can find better ways to communicate IT needs to our...

Sergiy (1/6/2016)

---

Lynn Pettis (1/6/2016)

---

Unfortunately you failed to recreate the function as originally coded. You are relying on the existence of a tally table in the database. The original...

Sergiy (1/6/2016)

---

Here you go:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[DelimitedSplit8K_NoCTE]

--=====...