some food for thought 😀

-- create some data

with produce (id,fruit, varieties)

as (

SELECT 101,'Apple', '3' UNION ALL

SELECT 101,'Banana', '2' UNION ALL

SELECT 102,'Orange', '1' UNION ALL

SELECT 103,'Melon' ,'2'...

LutzM (9/8/2011)

---

There's another option besides getting your boss to start reading up on Normalization:

You could use your design approach (which I consider to be valid btw) and create views to...

this article should get you started

http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

🙂

Hi clubbavich

good luck....I will also be watching this thread for any further posts 🙂

whilst I might not have been able to directly help you..... I have expanded my (very...

ok...sorry 😛

a few ideas

http://www.4waysolutions.co.uk

http://www.softcat.com

www,greymatter.com

http://www.bechtle.co.uk

there are many others

kind regards

http://lmgtfy.com/?q=SQL+Server+2008+Standard+5+cal+UK+prices

ok...forgive me if I have missed some posts, but I do not see any set up scripts or...

Have been playing around a little more and was keen to see if any improvement could be made on SQL 2008 R2...especially getting the server AND device\max date

ended up with...

I have run Jeff's code on two different machines both with 2008R2 (both dev ed)

and I cannot get the results he did.

My results are almost identical to MM's and...

Debra

sorry that I have been unable to help you.

you mentioned a text file...if you care to post it I will try and take a look later.

kind regards

debra

....do we assume data is coming later?

nairdeepa (9/5/2011)

---

no that would update everything..while i want a.the last session time and b. if last session time placement = criteria i gave before then find the last session...

...I dont have much time either.

looking again at your logic isnt this just a simple update along the lines of

UPDATE TMPDATA

SET order_attribution =...

debra

please provide some test data that fully demonstrates your problem

in this format please:

INSERT INTO [dbo].[TMPDATA]([client_order_number], [order_date], [session_start_time], [mmc_vendor], [mmc_placement], [mmc_item])

SELECT N'H4246723', 20100813, 20100813111301, N'email', N'_bmuy', N'welcom' UNION ALL

SELECT N'H4246723',...