Viewing 15 posts - 136 through 150 (of 222 total)
Good question. This happened before on my network - it clarifies the pieces of the puzzle.
December 2, 2008 at 6:35 am
Jim,
Out of the box SQL 2005
declare @myTab table( ExtRef varchar(9), IntRef decimal(38,19))
insert into @myTab(ExtRef,IntRef) values ('$1.00',0)
insert into @myTab(ExtRef,IntRef) values ('2.1',0)
insert into @myTab(ExtRef,IntRef) values ('A',0)
update @myTab
set IntRef = case when...
November 20, 2008 at 6:54 am
declare @myTab table( ExtRef varchar(9), IntRef decimal(38,19))
insert into @myTab(ExtRef,IntRef) values ('1',0)
insert into @myTab(ExtRef,IntRef) values ('2.1',0)
insert into @myTab(ExtRef,IntRef) values ('A',0)
update @myTab
set IntRef = case when isnumeric(ExtRef) = 1 then ExtRef...
November 20, 2008 at 6:46 am
I love the last answer - just go home. That one is the winner. :w00t: Gotta love it when someone has a sense of humor. ...
November 11, 2008 at 5:26 am
The negative ("This option may NOT be specified...") - urrgh... semantics. Does it mean that it can be but that you shouldn't because it doesn't make sense but it is...
November 5, 2008 at 5:16 am
if a thesaurus is consulted new words may be introduced and if it is possible that these words are stopwords then they would need to be processed after being introduced.
Makes...
October 17, 2008 at 5:22 am
Good Question.
Once you understand what stopwords are there is only one logical processing order.
Mark, can you explain how you arrived at this conclusion? I am with some of...
October 16, 2008 at 10:53 am
I wasn't aware of the ODBC datatype. Good question. Answer was obvious after the following worked:
DECLARE @ts timestamp, @dt as datetime
set @dt =...
September 30, 2008 at 5:46 am
The concepts behind the spatial indexes are, by far, one of the most interesting aspects of 2008 SQL queries. I'm not sure it deserves three points, but please keep...
September 26, 2008 at 5:45 am
Gee... I figured I would get this one wrong. It was so obvious that the question was not specifically including log files when the statement asked for database files, that...
August 28, 2008 at 6:27 am
There was also that new
grin nullgroup means no one invited
keyword NULLGROUP not far from the DINNER subquery.
August 26, 2008 at 5:39 am
MIN_ACTIVE_ROWVERSION (Transact-SQL)
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
This question is good but a bit confusing. It...
August 12, 2008 at 6:41 am
"Exclusive or" ouch - I was thinking exponential also.
Arguments expressing dismay that mixing numeric types provide incorrect results, hmmm, isn't that a big part of programming?...
August 8, 2008 at 4:53 am
No apology necessary - I always get them wrong when I am sure I know the answer. I learned something - that's more important than the points (frosting).
July 30, 2008 at 9:53 am
Viewing 15 posts - 136 through 150 (of 222 total)