Here is something to look at. I have to get back to work so cannot work on it today.

WITH cte1 AS (

SELECT DISTINCT Year_From FROM...

r_slot (4/28/2015)

---

Hello experts,

I want to show a resultset from the table mentioned below that only shows the longest range. In this example we talk about archery, an olympic event that...

TomThomson (4/27/2015)

---

Grant Fritchey (4/27/2015)

---

I reject your test as completely invalid and a waste of my time and superior intellect along with my ability to craft nonsensical run-on sentences for no...

Apex

Pizza

Copper

Unfortunately the date is along for the ride in this case. Normally the MatterNum and Date are the important information to the auditors, however in this case we want...

Thank you for the reply.

I did not think it was too big, but as I say I do not have experience with large amount of data.

As to blocking, I doubt...

wcarvalho (4/23/2015)

---

Hello.

I have the Person table with the following fields:

Id_Person

Nm_Person

Id_AddressResidential

Id_AddressCommercial

Another table called Address with the following fields:

Id_Address

Ds_Street

I want to make the relationship between these tables so that when deleting a...

Relativity

Master

Neverland

You cannot use the alias within the select. (ORDER BY yes)

There are several ways to do this. Some are recalculate, use a CTE, create a temp table

Finish

Ed Wagner (4/21/2015)

---

Eirikur Eiriksson (4/21/2015)

---

djj (4/21/2015)

---

Ed Wagner (4/21/2015)

---

djj (4/21/2015)

---

Revenant (4/20/2015)

---

SQLRNNR (4/20/2015)

---

TomThomson (4/20/2015)

---

Eirikur Eiriksson (4/20/2015)

---

Ed Wagner (4/20/2015)

---

Eirikur Eiriksson (4/20/2015)

---

Ed Wagner (4/20/2015)

---

crookj (4/20/2015)

---

Eirikur Eiriksson (4/20/2015)

---

Ed Wagner (4/20/2015)

---

Eirikur Eiriksson (4/20/2015)

---

djj (4/20/2015)

---

crookj (4/20/2015)

---

Ed Wagner...