Loner (11/14/2008)

---

Jeff

Don't even get me started with outsourcing. In my last company, I spent 4 days to finish a very complicated report. The outsourcing company had two...

AndrewMurphy (11/14/2008)

---

Jeff....

"Um... for what? Using a paltry 40 MB of TempDB?"

...if you read the original message...he was getting TEMPDB full....the only reason TEMPDB was being returned to 40MB was...

You bet... thank you for the feedback.

Heh... and a "classic" homework question at that... that's why I asked "what have you tried so far". When people don't...

Sure... you want all the rows of Summary Van No. to be the same?

Whichever, can you make it easy on me by providing the CREATE TABLE statement and some code...

K. Brian Kelley (11/14/2008)

---

I would disagree that this is RBAR. RBAR implies you're doing a set-based type of operation. Checking a password for complexity, at the end of the day...

MikeM7 (11/14/2008)

---

I'm seeing the light on Tally tables. Especially the solution Hugo provided for David Jackson. This a great article and has given me reason to re-think and...

Try the following...

SELECT COUNT(*) FROM Master.dbo.SysColumns

If it doesn't work, there are one of two problems... either you don't have the privs to read from the master database (very unusual) or...

upperbognor,

Would you also post the code for the dbo.fn_patindexEnd function? Thanks.

Dooza... what version of SQL Server are you using? Also, just to be absolutely clear, would you post the exact code that you're using so I can try to...

I'll take a look, Dooza...

Oh yeah... almost forgot... the reason why the WHERE clause actually works is because of my friend, the NULL value. It's not comparable using most relational operators unless someone...

I thought I'd throw my 2 cents in here... both Seth and Chris did a cool job on this. But, being ever vigilant for every micro-second of performance, I've...

Heh... no problem. I hate typing the code off the top of my head so I keep the script handy at all times.

Heh... firing porkchop #1... [font="Arial Black"]SLAP![/font] 😛 Ya gotta put a clustered index or, better yet,...