Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: a view randomly lost/corrupted metadata

    Grant Fritchey (5/1/2012)


    The error seems pretty clear. Something changed. Is the table being referenced another view or a user defined function?

    table being referenced is a standard table, that has had...



    If you haven't made it to PASS Summit, do so.
    The knowledge and networking available there is amazing.
    Bring a kilt.

  • RE: a view randomly lost/corrupted metadata

    correct, 2005(9.00.5266.00)

    example code is an exact copy of prod, with names changed to protect the innocent 🙂



    If you haven't made it to PASS Summit, do so.
    The knowledge and networking available there is amazing.
    Bring a kilt.

  • RE: a view randomly lost/corrupted metadata

    Lowell (4/30/2012)


    not sure what advice to offer yet, I've got a couple of questions first:

    what was the specific error that was returned? that would tell us a lot.

    dev didn't get...



    If you haven't made it to PASS Summit, do so.
    The knowledge and networking available there is amazing.
    Bring a kilt.

  • RE: bar graph with large number of columns

    that helps with the reusability of custom palettes, but doesn't do anything about the number of distinguishable colors. no one has a clue on getting the patterns to show...



    If you haven't made it to PASS Summit, do so.
    The knowledge and networking available there is amazing.
    Bring a kilt.

  • RE: bar graph with large number of columns

    have tried that, and it will work, sort of. it is rather difficult to find 32 colors that are visually distinguishable from the others. ...



    If you haven't made it to PASS Summit, do so.
    The knowledge and networking available there is amazing.
    Bring a kilt.

  • RE: T-SQL

    the problem I have with the question is that by context(being posed on a SQL server site) the answer is assumed to be in relationship to SQL server, and as...



    If you haven't made it to PASS Summit, do so.
    The knowledge and networking available there is amazing.
    Bring a kilt.

  • RE: T-SQL

    Lynn Pettis (11/17/2009)


    David Easley-401108 (11/17/2009)


    I agree that the question is now better worded, but still disagree with the answer. Since the output of the queries is devoid of any...



    If you haven't made it to PASS Summit, do so.
    The knowledge and networking available there is amazing.
    Bring a kilt.

  • RE: T-SQL

    I agree that the question is now better worded, but still disagree with the answer. Since the output of the queries is devoid of any timezone identification, the dates...



    If you haven't made it to PASS Summit, do so.
    The knowledge and networking available there is amazing.
    Bring a kilt.

  • RE: Convert positive number to a negative

    Ramesh (10/16/2007)


    DECLARE @InitialNumber INT

    DECLARE @OutputNumber INT

    SET @InitialNumber = 9

    SET @OutputNumber = ( CASE WHEN @InitialNumber > 0 THEN -@InitialNumber ELSE @InitialNumber END )

    SELECT @InitialNumber AS Initial, @OutputNumber AS Final

    Works like...



    If you haven't made it to PASS Summit, do so.
    The knowledge and networking available there is amazing.
    Bring a kilt.

Viewing 9 posts - 1 through 9 (of 9 total)