Forum Replies Created

Viewing 15 posts - 46 through 60 (of 716 total)

  • RE: Type

    Nice question, thanks!

    April 26, 2011 at 3:45 pm

    #1316278

  • RE: Less Pay, More Convenience

    Revenant (4/26/2011)

    Two points you can make to your (prospective) employer.

    First, telecommuting saves the employer about $500 per month for workspace..

    How do you figure? ($500/month/workspace seems like a lot more than...

    April 26, 2011 at 10:10 am

    #1315996

  • RE: Are we in all these cities?

    terrykzncs (4/22/2011)

    Who uses a ';' anyway? it's not yet standard practice and if you do, you should realise that it would cause problems in the middle of a statement.

    For starters...

    April 25, 2011 at 10:14 am

    #1315494

  • RE: Round up or down III

    terrykzncs (4/22/2011)

    So... in the following code

    declare @result decimal(12,8);

    set @result = round (5/3.0, 4,3);

    select @result;

    I get 1.66660000

    The operation (5/3.0) completes and the rounding is done according to the variable...

    April 25, 2011 at 10:08 am

    #1315493

  • RE: Consistent Data Presentation

    Thanks for the question!

    I am surprised at the number of wrong answers so far...

    April 19, 2011 at 11:32 pm

    #1313730

  • RE: Service Broker Poison Messages

    Thanks for the question and the exposure to Service Broker.

    April 18, 2011 at 11:00 pm

    #1313167

  • RE: Money and Decimal Datatypes

    Nice question thanks! I wish SQL Server had an option to require that all variable declarations include the size parameters.

    April 18, 2011 at 11:09 am

    #1312965

  • RE: What's Today?

    Of course it isn't this year, taxes are due on April 18th...

    From: http://www.irs.gov/newsroom/article/0,,id=233910,00.html

    Taxpayers will have until Monday, April 18 to file their 2010 tax returns and pay any tax due...

    April 14, 2011 at 11:40 pm

    #1311934

  • RE: Weird error when selecting from view.

    HowardW (4/14/2011)

    Ah, sorry, I misunderstood. So EOracle is a SQL Server DB and clm_edit_wq_clm is a view on it that uses a linked server to Oracle?

    Yeah, that driver is a...

    April 14, 2011 at 10:46 am

    #1311731

  • RE: Weird error when selecting from view.

    HowardW (4/13/2011)

    Odd that it fails with a compatibility mode of 100 - I wonder if it's something to do with mapping from Oracle's dates to the new date/datetime2 data types.

    Would...

    April 13, 2011 at 2:58 pm

    #1311346

  • RE: Dating for DBAs - a second date

    CirquedeSQLeil (4/13/2011)

    paul.knibbs (4/13/2011)

    Oh, I agree, the question was perfectly clear--... 😀

    I agree - I felt the question was very precise and clear in the meaning and intent.

    I can only assume...

    April 13, 2011 at 10:03 am

    #1311147

  • RE: Dating for DBAs - a second date

    Another great question, thanks!

    April 13, 2011 at 9:41 am

    #1311109

  • RE: PatIndex

    Gald we could help. Out of curiosity, do you know what "date" was causing the problem?

    April 12, 2011 at 11:13 am

    #1310541

  • RE: Logged Operations

    Lynn Pettis (4/12/2011)

    SanDroid (4/12/2011)

    You are correct. I should have provided something that proved what I was stating was correct.

    I have no hard data from a DMV, but I think this...

    April 12, 2011 at 11:10 am

    #1310538

  • RE: Foreign Keys

    Hugo Kornelis (4/12/2011)

    UMG Developer (4/12/2011)

    How does that design pattern represent dead people with an unknown date of death without using NULL?

    Assuming that the distinction between "dead, date unknown" and "alive"...

    April 12, 2011 at 10:49 am

    #1310522

Viewing 15 posts - 46 through 60 (of 716 total)