Hi,

Could some one help me with this 🙁

Thanks,

Debra

Hello Gah,

Thanks for responding. The tables have not changed at all. Just one column is added which is order_attribution. To start from scratch, below is the code which creates and...

Hello Gah,

Based on your query, I was able to modify mine. Many thanks to you..My query now looks like below 🙂

use crm_project;

go

;With abc as

(select client_order_number as 'client_order_number'

,(convert(datetime,(left(session_start_date,4)

+ substring(session_start_date,3,2) +...

Hi Gah,

Sorry about my earlier post, I forgot to put the right parameters. 'email' is written as ' email' with space in my dataset. your solution works for me, and...

Thanks Gah for the clarifications. I will follow the forum requirements as suggested.Regarding your solution, I did try to execute the same, but it does not give me any results....

Hi Jeff,

I am not clear on what you just said. could you please elaborate?

Many thanks,

well i solved the problem..was excited to share how i did it:

with abc as

(select client_order_number,mmc_vendor,max(session_order) as 'max_session' from

dbo.tmp_coremetrics_order_lookup

group by client_order_number,mmc_vendor)

,abc1 as

(select * from dbo.tmp_coremetrics_order_lookup x

where x.client_order_number in (select...

below is the raw text file to make things clearer which uses the above script:

client_order_number order_date session_start_time mmc_vendor mmc_placement mmc_item

H4246723 20100813 20100813111301 email _bmuy welcom

H4246723 20100813 20100813111302 email...

Here is the script i am using

select client_order_number as 'client_order_number'

,order_date as 'order_date'

,((convert(datetime,(right(session_start_date,4)

+ substring(session_start_date,3,2) + left(session_start_date,2))))+

(session_start_time)) as 'session_start_datetime'

,mmc_vendor as 'mmc_vendor'

,mmc_placement as 'mmc_placement'

,mmc_item as 'mmc_item'

,rank() over (partition by client_order_number

order by...

i want to choose the latest one..

complication arises in the following format:

ordernumber session_time session_id email_id

H78278 2011-09-09 10 54 1 welcome

H78278 2011-09-08 11 12 2 _BCvgsjhj

H78278 2011-09-08 11 18 3 _BCvgsjhj

H78278 2011-09-08 16 14 4 _Bnhjuik

here the...

hello,

so the result would be

email_id = _BCvgsjhj created 1 order

debra

yes, how to send the xml file?

sorry nothing is there still..i know its pretty annoying thing!

Thanks..

that field in Action expression is empty..i dont know where else to look