I was going to mention that it's pointless to use the same expression in both the...

Ralph L. Wahlert (8/1/2016)

---

Thanks John.

If this is how I have my data flow tasks configured, see below, where would I place the error output?

Between the lookup and the...

michael.lock@aer.ca (7/26/2016)

---

You've hit upon the "twist" part. I could be approaching this wrong. I'm assuming a recursion approach because to me this looks like a classic instance of...

I haven't seen anyone mention LAST_VALUE, yet.

SELECT

mt.Applicants_ID,

mt.APPL_CURRENT_STATUS,

mt.APPL_CURRENT_STATUS_DATE,

LAST_VALUE(mt.APPL_CURRENT_STATUS) OVER(PARTITION BY mt.Applicants_ID ORDER BY mt.APPL_CURRENT_STATUS_DATE ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) AS lv

FROM #myTable mt

I use ROW_NUMBER() if I want to...

Why do you think that recursion is the correct approach here? I don't think it is, because a recursive query needs to maintain the same "shape" throughout and I...

djj (7/26/2016)

---

Eirikur Eiriksson (7/26/2016)

---

Sean Lange (7/26/2016)

---

Jack Corbett (7/26/2016)

---

Apparently the person I'm going to be interviewing shortly has access to and knows how to use DBCC TimeWarp since they...

I think that it's possible, but it's going to be very complex, and it might just be easier to do it manually.

Here are some of the issues that you'll need...

J Livingston SQL (7/26/2016)

---

is it as simple as this ....??

SELECT * FROM (

SELECT * FROM #City

UNION ALL

SELECT * FROM #Subcity) x

ORDER BY Years DESC, Citycode, subcitycode

edit....just rechecked my results.....aint...

Alternatively, you could cast your DATETIME data as DATE and compare those.

WHERE CAST(DateCol AS DATE) = CAST(DATEADD(DAY, -1, GETDATE()) AS DATE)

Since CASTing from DATETIME to DATE is still SARGable, this...

As long as they are in the same transaction, changes to table A do not need to be committed in order to be available to table B. Generally, people...

fergfamster (7/22/2016)

---

John-

Please bare with me, Im sure you have done this a million times. So I add the output inside the Update statement as below then I can query that...

Since all of these methods depend on the table having an identity column, and the...

djj (7/21/2016)

---

I just remember that one of the...

Actually, I think that the Quirky Update[/url] method might be the fastest approach to doing this. You have to be very careful to follow ALL of the rules.

Drew

That's because LAG is for a relative position. FIRST_VALUE and LAST_VALUE are for absolute positions. You do have to get a little tricky, because you need to ensure...