DECLARE @tab char(1) = char(9)

EXEC msdb.dbo.sp_send_dbmail

@recipients='xxxx@xxxx.com'

@subject= 'Inventory',

@query= 'SET NOCOUNT On;

SELECT "Item" AS Item_id

, "Qty" AS qty_on_hand

, "Acct" AS acct

, "Date" AS date_entered;

SELECT RTRIM(j.item_id)

, j.qty_on_hand

, j.acct

, j.date_entered

FROM...

Thank you's to both Lynn Pettis and pietlinden. I had tried the nested query but obviously didn't have it correct. I hadn't even thought about the row_number. Both methods work...

I assume you mean like this? I appreciate the guidance.

SELECT id

, CASE

WHEN L1 > L2 AND L1 > L3 THEN L1

WHEN L2 > L1 AND L2 > L3 THEN...

Fantastic. Know I know how to post better code when I need help again. Thanks.

Luis Cazares (7/8/2015)

---

I'm not sure which of the 2 HAVING clauses you need so I'm including both so you can test.

I also changed the pivot approach to a cross tabs...

Lynn Pettis (7/8/2015)

---

jcobb 20350 (7/8/2015)

---

I have a table with items, sales locations, and product groups. The product group can be different for each location for the same item. I need...

In all the posts, I completely missed the solution posted by LinksUp. This works great. Thanks so much.

Lynn Pettis (6/29/2015)

---

jcobb 20350 (6/29/2015)

---

Lynn Pettis (6/29/2015)

---

jcobb 20350 (6/29/2015)

---

J Livingston SQL (6/29/2015)

---

I have a table that writes daily sales each night but it adds the day's sales to the cumulative...

Lynn Pettis (6/29/2015)

---

jcobb 20350 (6/29/2015)

---

J Livingston SQL (6/29/2015)

---

why...

J Livingston SQL (6/29/2015)

---

why dont you just query...

Correct in assuming SQL2008. I hope to be on 2014 by year end.

I don't think LEAD LAG is quite the answer though. I looked at Pinal Dave's page and...

Fantastic. I need to read up and understand the PARTITION BY a little more, but this did exactly what I needed. This is a snippet of what will be in...

That's what I'm looking for. Wow. Now to digest it a little so I can implement. Thanks so much. I would not have figured this out without help.

Here's a create table with an insert for the same sample data as earlier.

CREATE TABLE sample_sales

(customer_id varchar(8) not null

, period decimal(3,0) null

, year_for_period decimal (4,0) null

, total_amount decimal(19,4) not...

You're right, I don't think I need the period or year in my return because then I get muliple lines of return. What I have is a table of sales...