Steve Jones - SSC Editor (8/3/2012)

---

Great player, HOF worthy for his accomplishments over time (3K hits, games played, All stars, 5 gold gloves, WS MVP, Rookie of the year, etc....

patrickmcginnis59 (8/2/2012)

---

bitbucket-25253 (8/2/2012)

---

I am rather surprised at the low percentage of correct answers.

And the implications this could have to...

MarbryHardin (8/1/2012)

---

Scott D. Jacobson (8/1/2012)

---

MarbryHardin (8/1/2012)

---

Yes, that's my point. Between does not logically imply a comparison order, but SQL Server imposes one.

And consider if you want to supply variables...

So your second statement is seeing if 0 >= 0.05 AND 0 <=...

sqlfriends (7/30/2012)

---

roryp 96873 (7/30/2012)

---

ISNUMERIC will return a 1 if the value that is being tested can be converted to a int, bigint, smallint, tinyint, decimal, numeric, money, smallmoney, float, or...

ISNUMERIC will return a 1 if the value that is being tested can be converted to a int, bigint, smallint, tinyint, decimal, numeric, money, smallmoney, float, or real datatype. ...

I've used it to parse out address fields that have city, state and zip in one field. It's usually easier to look through it backwards with the idea that...

I think the STUFF function is what you are looking for.

declare @txt varchar(20) = 'RA99999-99'

select STUFF(@txt, 3, 0, '0')

Lol!

In all seriousness though, I selected the judge your skills option thinking it meant more than your SQL Server skills, but also you reasoning and logic...

Or at the risk of being wrong again, I think a catch-all query may be what you are looking for.

Does

WHERE Agent = @test-2 AND Agent <> ''

not work?

Edit: Nevermind that, I read your question wrong.

honza.mf (7/16/2012)

---

rhythmk (7/16/2012)

---

It is upto you if you want to learn you can use in such cases where it is hard to count the characters (exactly 30 in b option)...

You could just pick the ones where the second order id is greater than the first.

select *

from OrderItem o1

join OrderItem o2 on o2.itemid = o1.itemid and o2.orderid > o1.orderid

john.arnott (7/11/2012)

---

SQLDCH (7/11/2012)

---

Being a Giants fan, I'm pretty excited to see the boys in orange and black do well. It helped to justify their place in the game even...

SQLDCH (7/6/2012)

---

roryp 96873 (7/6/2012)

I think the Reds and the Nats will be shaking off that "doormats of the league" reputation over the next few years at least. Both are...