Garadin (9/16/2009)

---

Did you see my edit? You actually had 2 problems.

This code works perfectly fine:

--// lets create the source data

CREATE TABLE tblSource

(

...

the where clause was one problem... what did you find was the other ?

hehe yes I did forget the where clause... but... and maybe im being a little dense......

Wow thanks for the replies... definitely gives me something to think about. Handling the the variable column widths and data types are going to be a challenge... but...

hey again 🙂

I figured it out

-- original problem

Select Transaction_id,fieldName, oldvalue

from (

Select

Transaction_id

, acmc_id

, company_id

, company_type_id

, activity_company_id

, Addr_1

, Addr_2

, Addr_3

from activity_company_master_copy

Where CharIndex('Original',user_action) > 0

and transaction_id is not null) as aammc_src

unpivot

(oldvalue...

Garadin (9/10/2009)

---

My pleasure. Take some time to get familiar with that piece and then post back once you start broadening it to meet your overall goal with any questions...

heh I think I was refereing to the

;WITH UnPivotCTE AS (

at the beginning of the code piece.... as I said I am going to need to study this a...

looks like some code is missing....?

lol im going to have to study this a bit....

Hi Seth,

Currently there is no way to link the 2(orig and new) rows to a single transaction. However in the ongoing days I will be adding a transaction key...

Thanks for the reply and yes you misunderstood... i did as you advised and went the link. Here is the script to illustrate my question and problem:

--// create temp...