Forum Replies Created

Viewing 15 posts - 301 through 315 (of 1,048 total)

  • RE: Problem with CASE Statement

    Welsh Corgi (2/16/2012)


    Eugene Elutin (2/16/2012)


    What query have you tried?

    Have you copied CASE statement together with AS [ColumnName]?

    If so remove "AS [ColumnName]" from GROUP BY

    I tried it and it did not...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Problem with CASE Statement

    Welsh Corgi (2/16/2012)


    sturner (2/16/2012)


    as calvo stated, you'll need to include the complete case statement in your group by.

    I tried it and I get a syntax error.:-D

    bet you left the "AS...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Problem with CASE Statement

    Eugene Elutin (2/16/2012)


    sturner (2/16/2012)


    ...

    The probability of survival is inversely proportional to the angle of arrival

    I like it and have another one:

    Exit from unexitable situation is usually located at the same...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Problem with CASE Statement

    as calvo stated, you'll need to include the complete case statement in your group by.

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: How to update the database table by removing trailing spaces from one of the columns?

    One of the reasons to use a char data type over a varchar is to avoid performance problems if the column gets updated some time after the row has been...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: On Database Migrations and Agility

    GSquared (1/9/2012)


    But what most developers mean by "Agile" is actually "Cowboy". Database development can be quite Agile. It creates a horrible mess when it's done Cowboy-Coder style.

    Eloquently stated...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: can't save ssis packages

    Hmmmm... I always thought you needed enterprise edition to save them.

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Old Dog, New Tricks

    paul.knibbs (2/2/2012)


    As a set in my ways C programmer, I find it irritating enough that SQL overloads the = operator to mean both assignment and a test of equality (I...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: rythmic cpu usage caused by connecting to server PLEASE HELP!

    I'd run a profiler trace. Look for any batch requests coming from your computer. You probably have some tool running that is causing this.

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Capture Database & Server Name in a Derived Column to identify source of data before a Merge Join Task

    set up a view that includes the global @@servername as one of the columns in the select. Reference this view from your SSIS task.

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Morale Data

    Should not be necessary in company with competent leadership.

    In my experience, companies where the managers and officers are clueless about morale (or anything else for that matter) wouldn't believe anything...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Are the posted questions getting worse?

    GSquared (1/27/2012)


    Stop trying to help them.

    Personally, I am growing more and more fond of Celko's approach with each passing day.

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Are the posted questions getting worse?

    jcrawf02 (1/26/2012)


    Lynn Pettis (1/26/2012)


    I had a 1990 Ford Festiva. It was a trooper, went 30,000 miles without an oil change once. First mechanical work (right front toe arm) at...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Healthy Work Habits

    Eric M Russell (1/26/2012)


    Coincidentally, while shaving and getting suited up this morning, I started thinking about the idea that we should not consider the time we put in at work...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Just celebrating a little victory!

    welcome to the party. 🙂

    The probability of survival is inversely proportional to the angle of arrival.

Viewing 15 posts - 301 through 315 (of 1,048 total)