I'm going to go out on a limb here since I am not an "SSIS guy" either and say that if you can use DelimitedSplit8K you can also use PatternSplitCM...

Sounds like you want a rolling 3 quarters total, is that right?

Various methods exist and this article compares the performance you can expect:

Calculating Values within a Rolling Window in Transact...

"The general technique for transforming a Uniform Random Number (URN) into a non-uniform random number (NURN) is to multiply the URN by the inverse of the cumulative distribution function (CDF)...

Something like this might also work:

WITH Tally(n) AS

(

SELECT 0 UNION ALL

SELECT TOP (SELECT MAX(DATEDIFF(day, FROM_DATE, TO_DATE)) FROM #dates)

...

It could very well be that that is where I remembered this from.

Not to be casting aspersions on Jeff's fine solution mind you, but I'd probably do it something like this:

WITH PreAggregate AS

(

SELECT OrderNo, SubTotal = SUM(Amount)

...

I think I said in the article that ROW_NUMBER() and the other ranking functions are all good performing options over trying to code the same thing yourself a different way.

I...

Perhaps something like this might work for you:

SELECT t1.id,name

FROM table1 t1

INNER JOIN table t2 ON t1.id=t2.pid

INNER JOIN table3 t3 on t1.id=CASE type WHEN 'A' THEN t3.id ELSE t1.id...

Perhaps this?

WITH SampleData (UniqID, UniqClient,PhoneNumber,EmailWeb) AS

(

SELECT 3, 66,'4164445555','' UNION ALL SELECT 5, 66,'','fstest1@test.com'

)

SELECT UniqClient, PhoneNumber=MAX(PhoneNumber), EmailWeb=MAX(EmailWeb)

FROM SampleData

GROUP BY UniqClient;

Why not just do it like this?

WITH SampleData (Date_Month) AS

(

SELECT 'APR 2012'

UNION ALL SELECT 'JAN 2012'

UNION ALL...

SQLRNNR (2/20/2014)

---

Yes, I have been told that many times. They always want things...

Thanks! I worked pretty hard for that "Worked for the OP" stamp.

What do you think of the new thought question in my signature links?

zulfansari (2/20/2014)

---

Woohoo, I just went from Grasshopper to a Rookie 🙂

I did change the 9 to 3 and it's working beautifully 🙂

How about if I want to see the...

zulfansari (2/20/2014)

---

Now, not changing the requirements and trust me I tried to follow your last script but it's a little too much to digest right away, I know I will...

zulfansari (2/20/2014)

---

Hi Dwaine,

I would like to apologize and say that I didn't mean to say it the way it came out, I know you guys are here to help everyone...