Welsh Corgi (11/3/2011)

---

Lynn Pettis (11/2/2011)

---

First, I'll look at the date manipulations a bit later. Looks like the date manipulation code in my blog on ssc is just what you...

Read the first two articles I reference below in my signature block.

Does this do basically what you are looking for?

create table #Account (

AccountNo int,

RepCode char(4)

);

create table #Accountdim (

...

Also what indexes exist on both tables as well as if there are any foreign keys defined.

Might be useful to see the actual execution plans.

garethmann101 (11/3/2011)

---

Thanks to you both. Why an earth does Microsoft assume people know these things? They are supposed to be the leaders in this stuff. If anything when you hover...

Paraphrasing here.

You want the current info from Account, but you want the last record from Accountdim before the RepCode changed to what is in Account, correct?

ankita.patel01 81294 (11/3/2011)

---

sorry. i was in the process of putting my thoughts together so i can show you what i meant in the comments...

i know i missed to include this,...

raotor (11/3/2011)

---

Hello,

I am new to SQL and am slowly llearning, so please forgive me if I ask a dumb question.

I was reading through a couple of articles on the web...

Here is another option:

with cte_maxacc as (

select

acc.AccountNo,

acc.RepCode,

max(ad.CurrentDate) as MaxDate

from

dbo.Account acc

inner...

David Moutray (11/2/2011)

---

Here you go. Let me know if you have any questions.

;WITH [PreviousUpdate]

AS

( SELECT AccountNo

,MAX(RecordDate) AS...

Fixed my code a bit:

with cte_Accountdim as (

select

AccountNo,

RepCode,

CurrentDate,

row_number() over (partition by AccountNo order by...

Try this for a starting point.

with cte_Accountdim as (

select

AccountNo,

RepCode,

CurrentDate,

row_number() over (partition by AccountNo order...

elkucho (11/2/2011)

---

Thanks for the reply.

So if the records doesn't exist it will do to a OLD DB Destination, right ?

But if it does exist, what is the next component after...

First, I'll look at the date manipulations a bit later. Looks like the date manipulation code in my blog on ssc is just what you need with some minor...