What exactly are you trying to do? You posted some sample data but every column other than the first 2 are all NULL. What you have posted appears to be...

BWFC (1/24/2014)

---

Hi Sean

I've had a tinker with my proc and using the CTE approach works just as quickly as temp tables when using my method to create the combined column....

+1 Agreed!

BWFC (1/23/2014)

---

Thanks Sean. I did try using CTE's when I was testing but oh boy did it slow down. I'd forgotten about STUFF, I'm very new to SQL...

netmikem (1/23/2014)

---

Thanks for the feedback.

The job ad definitely says SCUD. Here is the particular qualification statement ...

"Must have minimum eight years' experience with SQL, coding queries, SCUD, stored procedures and...

This is a basic cte. Please use google for examples.

Once again you post another thread with partially useful information and calculations with no explanation. How do you expect us...

Here is another to do this using cte's. This produces the same results as your query except that for OrderNo 1003 it includes "Reach the Spanish Main" which is the...

Your sample data won't load. The last row for logins is invalid, not a huge deal I just skipped it.

However, the rows for [ProposalProfitSplitWorksheet] all fail the foreign key...

rho_pooka (1/22/2014)

---

Would something like this work? I wrote it in "notepad" so not sure if syntax is correct...

SELECT *

FROM Table

WHERE Time_Open <= GETDATE()

AND Time_Open >= DATE_SUB(MONTH, DATEDIFF(MONTH, 0, GETDATE())...

Dieselbf2 (1/22/2014)

---

So now we have the tables. We still need a few rows of sample to do much here. If I understand correctly you want to make sure you have...

You need to test the code you post. The idea here is for me to be able to recreate your tables on my system. This...

Dieselbf2 (1/22/2014)

---

Sean Lange (1/22/2014)

---

Dieselbf2 (1/22/2014)

---

Here is what I have so far. I am just trying to get the trigger to check the 2 frid that are on different tables before...

Dieselbf2 (1/22/2014)

---

Here is what I have so far. I am just trying to get the trigger to check the 2 frid that are on different tables before inserting the LgID...

Dieselbf2 (1/22/2014)

---

Thank you! I think this is what you are asking for.. My Boss wants a Trigger and the reason is maybe to just get me use to writing more...

Hi and welcome to the forums. It is very difficult to figure out what you are trying to do with nothing more than a couple of queries. Can you post...