All,

Yes easy, but helpful. We are in the process of converting a whole mess of 10-15 year old Access/SQL Server applications and we are finding some "@Var =...

All,

Good points everyone on the perils and pitfalls of getting a well formed question.

I would like to also add that when answering the questions that the some...

churlbut (4/18/2013) I don't understand why someone would get annoyed by a forum post asking for interview questions, sounds like there are quite a few people that are kinda snobby...

Good and Timely Question,

Even though the text type is deprecated in 2008 and later versions, this just came up last week when we were asked to create a "archive/log"...

Good question, but I learned from the question a new option when doing an insert statement. Inserting multiple rows with one SQL statement.

INSERT T1

VALUES ( 1 ),

(...

All,

The one thing I really appreciate about this site is how much I can learn something new from what seems like a simple list in interview questions. Never...

Due to the additional checking for nulls/blanks and removing blank rows from the returned table I figured efficiency would be seriously compromised. So I tested this revision against the original...

The performance of this is amazing, as is the thought behind the code. These kind of posts really make you think and learn a whole new set of features...

The best reason for doing the questions of the day is when you get one wrong, you learn quite a bit.

Thanks for the question and the follow up...

Oops, I was in the percent, who answered it wrong. I totally glossed over the table variable and that the second insert said shovel instead of hammer.

It falls...

From Earlier: "Sarcasm or not, this is where you should have made the effort to talk to the end users" I think something is missing here. Not every developer...

From The Article: Communication failed and I am sure that as a result, the HMO users felt, at least to some extent, that the project had failed. So who failed,...

You are so right chopeen...

Been There, Done That. Our setup around here is better than it once was. The developers has full control of both test and production databases....

Thanks For The Quick Reply,

I finally go it working by reversing changing the = otherwise it was bringing 8000-ItemQty records back for each record in the source table...

Cool...Thanks Again....

Select...

Thanks for all of the help in getting me over my brain fart.    The queries work fantasic.  

Anton