I guess the real point of my post was not to offer competition to DelimitedSplit8K (or any of its variants).

Rather to see if anybody has ever seen this "short-circuiting of...

Srl832 (3/10/2015)

---

I do not think I am getting right results. I compared the results from the top and bottom half of the query by changing the @fromDate to 3/1/2015...

Erikur,

My results with your harness confirm what you got after I changed from DelimitedSplitL8K to DelimitedSplit8K.

T_TEXT ...

I'm not sure I really understand your requirement, nor do I see exactly how your input relates to your desired output. Nice job of providing DDL and sample data...

Srl832 (3/9/2015)

---

Please help with the following query:

declare @fromDate datetime

declare @toDate datetime

set @fromDate = '2015-3-1 0:0:0'

set @toDate = '2015-3-9 21:43:00'

SELECT SUM(ALERTS) as TOTAL_ALERT

FROM

(SELECT COUNT(MessageId) ALERTS

FROM DeliveryMessage with...

Whoohoo! Finally a chance to contribute to this thread. Possibly. Someone please check me on this.

Below is a rather simplistic test harness that assumes we have a...

Looks like a data smear to me:

Filling In Missing Values Using the T-SQL Window Frame[/url]

As Sean has advised, there's no reason to store that information when there's various ways to...

+1. My first thought when I read the question.

Snargables (3/9/2015)

---

i have a project server select thats selecting a single record. the holdlock ,updlock is locking up. If i change it to rowlock it runs fine. Can someone explain...

ZZartin (3/9/2015)

---

dwain.c (3/8/2015)

---

I don't really subscribe (generally) to the notion that breaking a query into separate pieces using temp tables makes it any easier to understand.

To me, properly formatting the...

CELKO (3/9/2015)

---

I'm going to go out on a limb here and suggest that, since calculating a product price probably requires no data updates, that should be done using an in-line...

Michael L John (3/9/2015)

---

At the risk of sounding harsh, if you cannot understand a complex query that has more than X number of joins, then is that something you really...

Joseph Miano (3/5/2015)

---

I have a table which is updated daily using a MERGE statement. As records are insert, updated and deleted, I am saving the OUTPUT from the MERGE...

t.mounika01 (3/6/2015)

---

can anyone provide me real time scenarios where you build stored procedures, triggers, cursors? Also, I am confused on how the real time work happens.. i mean i...

I'm going to go out on a limb here and suggest that, since calculating a product price probably requires no data updates, that should be done using an in-line Table...