Ed Wagner (1/5/2016)

---

sartis (1/5/2016)

---

Thanks MMartin1 and sean, I plugged this into SQl Server management studio and it appears to be kicking back results in the correct manner. Sorry for all...

MMartin1 (1/5/2016)

---

Or if you want to make this look more to what you may be familiar with, drawing off of your example ,

USE tempDB;

GO

/* ----------------------------- */

CREATE TABLE #stakeholder_notes(

note_id INTEGER...

MMartin1 (1/5/2016)

---

sartis (1/5/2016)

---

MMartin1 (1/5/2016)

---

You provided sample data and the tables structure. Can you also provide what you want the final output to look like? We may be able to fill...

understood.

Sean Lange (1/5/2016)

---

sartis (1/5/2016)

---

Sean, Thanks for trying to help. So the page in my web app where I want to display this timeline is called details.cfm . It's a page...

MMartin1 (1/5/2016)

---

You provided sample data and the tables structure. Can you also provide what you want the final output to look like? We may be able to fill in the...

Sean, Thanks for trying to help. So the page in my web app where I want to display this timeline is called details.cfm . It's a page where I show...

Sean Lange (1/4/2016)

---

This is much better. Thanks.

Now we have the next challenge which I asked previously also. Is there something that states which row(s) from sh_asset belong to a...

DROP TABLE stakeholder_notes;

CREATE TABLE stakeholder_notes(

note_id INTEGER NOT NULL PRIMARY KEY

,note_stakeholder_id NVARCHAR(50)...

Here is a select from 2 tables in my database:

SELECT TOP 1000 [email_id]

,[email_to]

,[email_cc]

...

I apologize, ok, so i have several tables I want to select data from, one of the columns in each table is a date column. So, I guess my question...

Hey Craig, So i moved my where statement into my join statement and I got it to work correctly, thanks for trying to help.

I guess I'm not explaining it well enough....If I remove the where statement I get back too many items.

I have a table(projects) that lets say has 6 rows...I want all...

Hi, Thanks for looking....I'm new here and did not know about the Forum Etiquette...sorry

In the where clause the 5142 is an id of the person.....so that is why is restricts...