Can't really drop that into SQL Server and play with it. Help us help you. Read this[/url].

You could use ROW_NUMBER() and maybe select the columns you need and filter by ROW_NUMBER() to put them into separate records.

Please show your desired output. (My psychic skills are...

Crosspost... original is here:

http://www.sqlservercentral.com/Forums/Topic1739452-3077-1.aspx#bm1739455

(Should actually be in 2014).

Could you please post your expected output?

If you're using 2012, use LAG to get the previous record, then you can compare/do math on the two in the same row.

The spam this weekend is insane... is the filter taking the weekend off?

Could you explain why you need a recursive query for this? Performance of recursive queries will probably be really slow. If you have a dummy database outside of work,...

Mario,

I hope your math is wrong, because mine doesn't match what you're getting. For the moment, I'll pretend it does.

I think the whole hierarchy bit is a red herring....

Where's the ProductID in your dataset? Either my psychic powers or my eyesight must be failing.

How did my solution not work?

maybe...

SELECT P1, MAX(P2) AS MP2, MAX(P3) AS MP3

FROM

(SELECT 35 AS P1,NULL AS P2,NULL AS P3

UNION ALL SELECT 35,NULL,290

UNION ALL SELECT 35, 659,NULL

UNION ALL SELECT 14,NULL,NULL

UNION ALL SELECT 14,NULL,296

UNION ALL SELECT...

If you have Enterprise, you can use Data Driven Subscriptions. If not, I think you can use Jason Selburg's solution.

http://www.sqlservercentral.com/scripts/Miscellaneous/31733/

You could use RANK/DENSE RANK in your query and then create a calculated expression in SSRS.

IIf(PersonRank>5.6,PersonRank)

then just group on [PersonRank]

Here is okay. Could you post the data as a UNION query, or CREATE TABLE query with INSERTS to make it easier for us to help? It sounds like...

Something like this should work:

Value:

=DateDiff(DateInterval.Hour,Today(),Now())

Then you could just choose your ranges for red/yellow/green, as long as the ranges don't overlap and there's only one red/yellow/green value range per day.

I am assuming you have a table of dates in your database or a Calendar table (basically a contiguous list of dates). Because dates are continuous, you could just...