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...

  • 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 🙂

  • 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...

  • 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...

  • 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. ...

  • 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...

  • 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...

  • 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...

  • 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...

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