Are you using SS2K or SS2K5?

Based on the forum you posted in I assume SS2K, but need to make sure before posting a non-working/inefficient solution.

I'm glad I could be of some help!

Even though Microsoft claims that the PIVOT function is kind'a easy to handle it still takes some time/effort/experience/t&e to finally get it to...

Hi Tom,

when I look at your first solution, you're using

Select ... FROM TestTable

WHERE TimePeriod >= ...

AND Area = ....

In Wayne's solution he's using:

Select ... from #TestTable

where Area =...

I just used the CTE sample code I provided in post http://www.sqlservercentral.com/Forums/FindPost714447.aspx and

added the following lines to the table, without modifying the CTE's:

INSERT into #Table

SELECT 3456, 'Z', 2.30 UNION...

Please don't cross post!

I'd recommend to continue the thread on http://www.sqlservercentral.com/Forums/FindPost713955.aspx

since it contains more input from the OP so far...

Hi,

you should consider using a calendar table.

A start point would be the code posted by GSquared in http://www.sqlservercentral.com/Forums/FindPost513748.aspx

Hi Todd,

I used the first example from BOL (see "Using PIVOT and UNPIVOT") and modified it slightly to match the column names in order to get the following result without...

You might want to look up "XQuery" in BOL.

The following link would show you a list of XML related threads of this forum with examples for almost every approach.

http://www.sqlservercentral.com/Forums/Forum21-1.aspx

If you...

What have you tried so far?

Did you look into DATEADD/DATEPART functions in BOL?

Hi,

the reason why a Pivot cannot be used with the original data is that you're not referring to an existing element.

Example:

For CUST_NO 1234 and 2345 Rule1 = 'I' but for...

Manie Verster (5/10/2009)

---

...but there is one thing that stabs me straight to the heart and that is the generalization of developers. ...

Now here is a generalization for you. I think...

Since the number of PriceRules has a known limit, the following proposal should work:

step 1: use ROW_NUMBER to identify the first, second a.s.o. PriceRule per CUST_NO

and step 2: select the...

First, I need to apologize for not paying enough attention that there is a link which refers to complexity theory. :angry:

I was under the impression that the question is regarding...

Did you look into SUM(Field) OVER (PARTITION BY ...)?

For more detailed information to we need more information from you.

Please see http://www.sqlservercentral.com/articles/Best+Practices/61537/ on how to post sample data.

It seems like some of you folks had a chance to look at the 3rd-party code I'm struggling with at the moment...

You'll find almost everything that's mentioned already, but within...