Ninja's_RGR'us (7/22/2011)

---

That debate however has no end in sight as far as I can imagine, untill everybody takes 100% responsibility for their own life. Now that could start another...

GO YOU!!

well done bud 🙂

bopeavy (7/20/2011)

---

I agree the question was misleading!! I ran it 20 times and always returned 5 rows! If the question was in reference to the UNION ALL it should have...

jcunningham (7/20/2011)

---

I had a developer telling me that his Where column like 'A%' was not returning all of the expected results. Took me forever to realize he was running...

cheers bud

Toreador (7/20/2011)

---

Sadly that's not the case. There have been many recent questions...

Well, I think this was a useful reminder to us to actually look at the code. Yeah you might have missed a point and there's an 'incorrect' answer against your...

lol although...

I'd prefer 2 pints...

...to the pub!

nice to see people properly dry running it! when I was at college 5/6 years ago the teachers were allways banging on about dry running code and none of the...

I dont have SQL 2008 here so couldn't test to be 100% sure before posting.

should work exactly the same, but I'm not one to release untested code 😉

thanks 🙂

My team leader got it wrong.. 😀

Cheers guys.

I will have a play with service broker - I think it would be a useful skill to have anyway. I though about scheduling jobs, but I dont want...

Cheers Guys.

I shall look into service broker.

Lut - Good advice ta, but I already have run this sproc in paralel - i just kick off 13 queries in management studio...

Believe it or not theres a verse in the bible that mentions this... (yes the bible is applicable to databases)

ecclesiastes 9:11 states; "time and unforseen occurence befall us all"

dont think...