GilaMonster (1/19/2009)

---

Exactly.

Would you mind editing your earlier post to do the same? It's nothing to do with the data or values, it's just to prevent the...

You can say that again 😀

munishprathap (1/19/2009)

---

its a new table didnt hav any values in that column.

assume that column 1 has Id as bigint ,column 2 has Date as datetime

my aim is to alter the...

When comp_indcode contains more than one value, it's a comma-delimited list and this won't work: capt_code = comp_indcode . This isn't because there are pesky commas everywhere, it's because you...

What does this column presently contain? Can you post a range of values?

Oops...try MIN as well!

Hi Krypto

Which solution did you decide to use? Would it be possible for you to post it, for the potential benefit of others who may experience the same or a...

This may be doable with a preaggregated derived table instead of a correlated subquery:

-- current query

SELECT e.coCRN, e.deptCRN, e.county, e.orderNo, MAXuserID = (SELECT TOP 1 userID FROM #events e2

WHERE...

Adi Cohn (1/16/2009)

---

Actually when you have legal weapons there are procedures in air lines that lets you fly with your weapons. You won’t be able to have any weapons...

Steve Jones - Editor (1/15/2009)

---

Well it is steel, and likely move's fast in Gail's hands, but no, it's not a bike.

http://en.wikipedia.org/wiki/Katana

Got to play with sticks last night, Filipino style last...

GilaMonster (1/15/2009)

---

Chris Morris (1/15/2009)

---

They take a few moments to string, speshly in the dark, so if Mr Catburglar comes visiting then your best move would be to pin him to...

Grant Fritchey (1/15/2009)

---

Chris Morris (1/15/2009)

---

Grant Fritchey (1/15/2009)

---

Oh yeah, two bows in the house, one a flat native american style long bow and the other a d-shaped english longbow with a...

Grant Fritchey (1/15/2009)

---

Oh yeah, two bows in the house, one a flat native american style long bow and the other a d-shaped english longbow with a Victorian riser and horn...

GSquared (1/15/2009)

---

Grant Fritchey (1/15/2009)

---

Oh now, don't...

Get yourself a little snub-nosed handgun...