Tom Brown (5/15/2009)

---

GilaMonster (5/15/2009)

---

Luke L (5/15/2009)

---

Nope I was referring to the link Tom Brown posted. It seemed like he was trying to post a location and ended up putting...

Gift Peddie (5/15/2009)

---

I would hope that things are changing and I would encourage more women and minorities to enter the IT field. The diversity would be of great benefit to...

Gift Peddie (5/15/2009)

---

My, obviously hamstrung, interpretation of what Cherie was saying is that, regardless of the length of the list of bullet points, degrees are -more- used as employment and...

You need to use dynamic sql to accomplish what you are trying to do. I don't know if you can use INSERT ... EXEC(...) to populate a table variable...

Oh? When did you move to Virginia? You look like you live close...

What does this query return?

SELECT T2.*

FROM TESTDATA T1

INNER JOIN CUST.TABLE2 T2 ON T1.GENL_ID = T2.GENL_ID

WHERE

T1.UDEF_ID IN ('F', 'FLS', 'FLP', 'FMLP', 'FMLS', 'FMPS') and

T1.GENL_ID = T2.GENL_ID

My 3 cents. I don't agree. I should not have to pay more for a Kindle format ebook just to use the Kindle's text to speech capability. ...

At this point we really need the DDL for your tables, sample data (in a readily consummable format), expected results, and the code you have already completed.

For assistance in this,...

Reason we logged all FTP data transfers directly to a SQL database was that we used insert triggers to start our import tasks upon a successful transfer from our LOB...

Couldn't help but notice the two football pitches near by! Of course, just seeing the area makes me want to visit England...

Paul White (5/14/2009)

---

America is just really so big!

And hey your area is...

Well, since we are showing about where we all live, here is where I live.

Bob Hovious (5/14/2009)

---

Calm you must be, Lynn. Dwell on them you should not.

For though their numbers are legion they are not strong in the...

I'm still not sure what your problem is. Your statements are just too vague to know what your are actually asking us for. T make a simple guess,...

Is there a question here? I see code but no explanation as to what you are trying to accomplish or what error message(s) you may be receiving.