And to add to Luis, there is a reason we have a datetime datatype in sql. Please us it and not some horrible integer/string disaster. It will cause you and...

+1 😀

Good question. Made me stop and think before my first...

Here is my take on what you need to do. You should read the article at the first link in my signature, the one about best practices. Keep in mind...

I saw that post and got very quiet as I...

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...