Lynn Pettis (9/6/2012)

---

Okay, you're...

sku370870 (9/6/2012)

---

Unfortunately, the 8 or so apps that use this database - which are all timeline driven - don't use a calendar table. In other apps I have a calendar...

pelusodm (9/6/2012)

---

I need to combine multiple rows into one row for each id number so that I can display multiple corresponding trans_amt columns for each person. A person may have...

a4apple (9/6/2012)

---

CREATE TABLE Iss

(

id BIGINT,

name Varchar(50)

)

CREATE TABLE Jou

(

id BIGINT,

iss_id BIGINT,

created_on DATETIME

)

CREATE TABLE Jd

(

id BIGINT,

jou_id BIGINT,

VARCHAR(10),

old_value varchar(10),

new_value varchar(10)

)

CREATE TABLE

(

id BIGINT,

name BIGINT

)

INSERT INTO (id, name) values (1,'Phase')

INSERT INTO (id,...

sku370870 (9/6/2012)

---

Thank you both very much for your help. I was slow replying to Mark to thank him as I was working on the most awful bit of code -...

Ahh there is the challenge...

cms9651 (9/6/2012)

---

Eugene Elutin (9/6/2012)

---

The MAT column will be ordered randomly, but Tot will still come as a last one per DVD.

I agree, that setup needs clarification about Total: is it...

ScottPletcher (9/6/2012)

---

Interesting....

sunny.tjk (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

sunny.tjk (9/6/2012)

---

I'll be sending the execution plan in a bit.

I've a question, I ran the following query and when I looked at the execution plan it's just...

Eugene Elutin (9/6/2012)

---

Try to add one more data row:

INSERT INTO...

The rollup option suggested previously is not what you want here. I have to admit I don't quite understand why your query is so complicated. It seems you introduced a...

derek.colley (9/6/2012)

---

Point taken, it's a join, not processed row-by-row, so not subject to overhead of 'decoding' the date functions then comparing, then doing over again in a loop. So...

I'm not much of a dev guru so can't test this from an external application call, but I reckon it would be possible to fool a call to the SP...

Actually the functions in your where clause should not render nonSARGable as Derek suggested because it is not a row based call.

It is pretty hard to tell why the...

derek.colley (9/6/2012)

---

Good point. You'd merely get the string inserted...