It now executes ok but is returning the wrong row(s).

Thank you.

Trying the last example I get these:

Msg 207, Level 16, State 1, Line 4

Invalid column name 'LocationID'.

Msg 207, Level 16, State 1, Line 4

Invalid column name 'LocationID'.

Msg 207, Level...

I wanted to let everyone who helped me know what I ended up doing.

1st I get all the location ID's on a specific route (usually about 20 rows).

SELECT tblLocation.ID

FROM...

This does work after all. I was using the wrong test route.

I feel extra dumb now, but I did learn a lot here.

Thank you.

SELECT tblLocation.ID

FROM tblLocation

WHERE tblLocation.Route IS NOT...

This gives an idea of what I need:

SELECT tblLocation.ID

FROM tblLocation

WHERE tblLocation.Route IS NOT NULL

AND tblLocation.Route <> '0-0'

AND tbllocation.Inactive = '0'

AND tblLocation.Route LIKE '1010-%'

AND tblLocation.ID NOT IN

(SELECT...

Thank you.

You have some problems in your SQL code. First, why are you using DISTINCT for all the...

What I have so far was not meant to be the final product. I know the loops are poor.

I do what most of you do, I get it working any...

Eugene Elutin (8/11/2010)

---

Sorry mate, no one said that your solution need 1000+ stored procedures and 400+ views and 350+ temporary tables. Actuallty, no one here in position to advise about...

Eugene Elutin (8/11/2010)

---

No offence, but do you seriously believe that writing "enough" in C# makes you good in it? 😉

Hornestly,...