There're a whole bunch of articles out there on naming conventions alone - none that I've seen that justifies starting any name with an underscore...I've also seen spaces used in...

I think your new job is erlaly keeping you on your toes...you seem to be back in full swing - think Steve is the only one you have to beat...

Of course you can read...didn't you have to be able to read in order to study ?!?! 'sides, it's better than not being able to write..."erlaly"..

I agree with Ninja's RGR'us' suggestion!

I have never put DBA on my resume yet get emails for DBA positions all the time - I got interviewed last week (& an...

Just wanted to second that....I love that book and it still remains a top favourite that I pick up from time to time...simple & well written!!!

For that the articles would have to be flagged in some way and/or the site-owners would have to read the comments & response posts to every single article..kinda monumental..that task...

Tom - you can always run your t-sql through the parser in QA to help you debug...

You have 2 joins in your first line without specifying what column(s) you're joining...

Sandy socked it away in a sock

huffing & puffing and in a pant

A breach in the administration, an administrative breach

to each his own, but in a....BREECH ?!?!

got too big for...

well - there's 0 or 100 that gives you hh:mm in AM/PM - would that work ?!

You missed the boat on this one...has been discussed (at least) twice already.....

Bent Corner ads

Advertising

Bagath - you'd be better off posting the whole code so someone can take a look at it and possibly identify the error spot...

If temp tables are allowed, then you can do...

select distinct(column)

into #table

from table

select count(*) from #table

Not at all..that was addressed to rookies who don't know any better and don't script them right the very first time...not "Old (& capable) hands" like you....

Or maybe a variable to store the @@ROWCOUNT ?!?!

So now we have everything sorted out what's with all this funky display ?!