Viewing 15 posts - 31 through 45 (of 50 total)
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 =...
June 5, 2013 at 7:48 am
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...
June 5, 2013 at 7:38 am
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...
April 18, 2013 at 7:16 am
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"...
April 11, 2013 at 2:02 pm
Good question, but I learned from the question a new option when doing an insert statement. Inserting multiple rows with one SQL statement.
VALUES ( 1 ),
March 15, 2013 at 2:24 pm
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...
February 28, 2013 at 7:56 am
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...
January 16, 2013 at 1:40 pm
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...
January 16, 2013 at 9:22 am
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...
December 21, 2012 at 1:05 pm
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.
August 31, 2012 at 11:58 am
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...
April 30, 2007 at 10:05 am
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,...
April 30, 2007 at 7:13 am
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....
June 16, 2005 at 7:08 am
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...
May 26, 2005 at 1:24 pm
Thanks for all of the help in getting me over my brain fart. The queries work fantasic.
June 22, 2004 at 8:12 am