This gives the logic you asked for, however, not the expected results, for example i do not get the following value:

Source Target StartDate EndDate

-------...

You haven't actually asked a question here. What are you trying to achieve (yes I know you've given expected results, but how do you get these)?

Without knowing what you're trying...

greeshatu (12/23/2016)

---

@thom-2 a:Thank you for formatting my question .

That is what I exactly want . Could pls help me out

Actually My data will be huge So When I use the...

Have a look at Understanding the OVER clause[/url], which explains the ROWS BETWEEN clauses.

Fully Windowed, and VALID included.

WITH CTE (EVENT_ID, EVENT_RANK, MIN_AGE, MAX_AGE, C_MIN, C_MAX) AS

(

SELECT A.EVENT_ID,

A.EVENT_RANK,

A.MIN_AGE,

...

olibbhq (12/22/2016)

---

Thank you Thom, I am very grateful.

I will try this with a larger dataset and see how it gets on.

I am curious you moved away from windowing to joining...

This gives me the right results, however, this is quite a small dataset, you might want to check on others.

Also, what is the logic for VALID? I have omitted this...

olibbhq (12/22/2016)

---

Thank you for posting the table Thom and for your window function. I understand what you have done and I too get the correct results in a much more...

For those that can't see the image above.

SELECT 1205, 1 AS EVETN_RANK, NULL as MIN_AGE, 55 AS MAX_AGE, NULL AS RUNNING_MIN, 55 AS RUNNING_MAX, 1 AS VALID

UNION

SELECT 1205, 2,...

Can we get some expected results? This gives me a right result at the end, but i'm pretty sure EVENT_RANK 3 is wrong with a C_MIN of 23, and a...

Considering that your error is "Invalid object name 'XYZTable'" this sounds like either a permissions error, or the statement is pointing the the wrong database/schema.

If you're object names are different...

Semicolons won't be a problem at all (notice that...

Jim-S (12/22/2016)

---

*edit* Sorry should have mentioned, we aren't deploying to the catalog, we are still using the package deployment model at the moment but i'm not sure this will have...

You'll find it unlikely that anyone will be happy to open that RAR file of yours, as we don't know what's contained inside it (especially as many of us browse...

This is not dynamic, if you have more than just products A, C, P and NULL, but as I said above, I have little information to go on. if you...