Again, answer the question asked below, what value do you expect this...

yuvipoy (4/14/2014)

---

FROM

--TABLE1 M (NOLOCK), -- Use of NOLOCK is HIGHLY Suspect and can provide erronous data

--TABLE2 OM (NOLOCK) -- including missing and/or...

Miller (4/14/2014)

---

Yes, Thanks for the test. I fixed the problem noted. Had to use DATALENGTH throughout instead of LEN to handle trailing spaces.

SELECT * FROM [dbo].[BetterSplit] ('the; quick; ...

Sean Lange (4/14/2014)

---

Lynn Pettis (4/14/2014)

---

Sean Lange (4/14/2014)

---

Lynn Pettis (4/9/2014)

---

Sean Lange (4/9/2014)

---

Yes indeed. One suggestion I would offer is...

halifaxdal (4/14/2014)

---

As WITH is not allowed in this case, I did some replacement:

FYStart = DateAdd(mm,-2,DateAdd(yy,DateDiff(yy,0,DateAdd(mm,2,Getdate())),0))

FYPrevStart = DateAdd(yy,-1,FYStart)

FYPrevStart = DateAdd(yy,-1,DateAdd(mm,-2,DateAdd(yy,DateDiff(yy,0,DateAdd(mm,2,Getdate())),0)))

...

Sean Lange (4/14/2014)

---

Lynn Pettis (4/9/2014)

---

Sean Lange (4/9/2014)

---

Yes indeed. One suggestion I would offer is to include an order...

Reformatted your code and made some annotations. Be sure to read them.

SELECT

M.*,

COL1, -- Based on the DDL you provided all of...

Jeff Moden (4/13/2014)

---

Miller (4/13/2014)

---

Thanks for your post. I wonder if you considered using the LEAD function to improve your split. The LEAD function is significantly faster than CHARINDEX. Below is...

As much as I hate saying this, since semicolons are statement terminators not statement begininators, try putting a semicolon in front of the WITH of the CTE declaration. I.E....

Port1433 (4/12/2014)

---

Hi All,

I can't grasp the meaning of instance as it is being used in various contexts. For example SQL SERVER 2000,SQL server 2005, SQL Server 2008 and 2012 are...

Okay, based on the following call to the procedure:

EXEC @return_value = [dbo].[zzNewTable2]

@fromRec = 0,

@toRec = 9,

@OrderType = N'asc',

@OrderBy = N'posteddate'

It appears that you want to sort the data being returned...

Based on the sample data, what is the output supposed to look like?

At this point I would suggest contacting Microsoft regarding this issue rather than relying on volunteers who may not have experienced the same problem as you are having at this...

There is another way, look at the last Fiscal Year calculation:

WITH SAMPLE_DATE(XDATE) AS

(

SELECT CONVERT(DATETIME2(0),XDATE,120) AS XDATE

FROM (VALUES

...

Actually, you still haven't provided anything we can work with here. Please post the DDL (CREATE TABLE statement) for the table(s) involved, sample data (in the form of INSERT...