Why don't you add the UPC code to the database and use that to link the various records together?

Drew

Terje Hermanseter (6/3/2016)

---

I've been too sloppy. I need to be more consistent and start to use them even when I...

arihantjain121189 (6/2/2016)

---

It is not the pivoted table.. Its a table with attributes stored in columns and in the input i can get any attribute to update data into the final...

There are actually several different approaches you can use. Here are two:

; -- Use a table value constructor with the ranges

WITH sample_data AS (

SELECT *

FROM (

VALUES

(11, 1)

,(12, 1)

,(13, 2)

,(14,...

You should test the code for your sample data before posting it. When I ran the code, I got an error, because the Start_Date is set to NOT NULL,...

Your FinalResult table looks like it's the result of a pivot or crosstab. It would be easier to make the updates before the pivot/crosstab rather than after the fact....

[rant on]

If you don't...

I actually prefer to use the XML concatenation method, which also automatically handles NULL values, and--unlike CONCAT--works in SQL2008, and is easier to check that you're getting the correct values.

Update...

Please don't cross post. It fragments the replies. Please respond to http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx

Drew

However, there are problems when the data is even a little more complex. For instance, a person might switch from one email to another and then switch back to...

Using SQL Profiler for traces has been deprecated. You should start using Extended Events.

Drew

yb751 (6/1/2016)

---

Ok so after a few voodoo spells and a couple chickens later I came up with this. If it looks weird, that's because it is. I'm pretty...

To answer your question, equality columns are columns that generally appear in JOIN/WHERE clauses with an equal sign; inequality columns generally appear with some inequality, e.g., <=. Equality columns...

jc85 (6/1/2016)

---

Sergiy (6/1/2016)

---

Now you're gonna hit your head again asking "why did not i think of it?".

It's so easy. 🙂

You group you'd events by day:

dateadd(dd,0, datediff(dd,0,b.start_time)) as [date]

But what you...

I think the following code

(LOTHIST.TransDate) > GETDATE()- 90

should be

(LOTHIST.TransDate) < GETDATE()- 90

Also, the parens around LOTHIST.TransDate are completely unnecessary.

Drew