Forum Replies Created

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

  • RE: Upgrade Advisor : prefixed column alias error

    Solution:

    What I didn't realise was the table alias name will take precedence over a column field name, so removing the table alias prefix from the ORDER BY is enough to...

  • RE: Need help with modifying a free text "condition" column.

    Ok, penny has now dropped.

    You are not suggesting to modify the entire condition, but extending the mapping table to include the "HomeSite = 'CIT'", "HomeSite <> 'CIT' with "GroupID =...

  • RE: Need help with modifying a free text "condition" column.

    Thanks Garadin for the reply.

    We are unable to use the hard coded strings as there are a few thousand records that need to be updated in each database and there...

  • RE: Need help with modifying a free text "condition" column.

    The script only needs to run as a once off - pre upgrade (if that make sense) - but needs to run over a number of databases globally.

    The task is...

  • RE: Date format MM/dd/yyyy hh:mm AM/PM

    Nayak,

    I understand where you are coming from and it does always depend on your audience.

    If there is a chance that the report can be viewed by...

  • RE: Date format MM/dd/yyyy hh:mm AM/PM

    I have seen a lot of posts on how to format dates, and it still astounds me that in an age of global software and multinational corporations, we are still...

  • RE: Hungarian notation convention

    Thankyou Jeff for the vote of confidence. It is good to know I also have a like minded person somewhere out there.

    It is always troubling when you are at...

  • RE: Hungarian notation convention

    You have found one of my little bug bears here. There is no excuse for producing badly formatted code. Just because code has to go in quickly does...

  • RE: Hungarian notation convention

    The naming convention I prefer is as follows.

    Table Names :

    Use the plural of the entity.

    Customers

    Parent Child tables :

    ...

  • RE: help with data type and default value

    fisher08 (6/27/2008)


    John Oliver (6/25/2008)


    Agree with Stephanie and Jeff, but only on the condition that length of the data is always going to be the same.

    If you know that the data...

  • RE: help with data type and default value

    Agree with Stephanie and Jeff, but only on the condition that length of the data is always going to be the same.

    If you know that the data is always going...

  • RE: Sort Order - Include Null al last

    Glad I'm not the only one that was confused by this question.

    The question stated

    "The question is to have list off all employees with the employees with DateOfLeaving coming last and...

  • RE: In The Zone

    Tim,

    very interesting article, and rather frightening what some feel is "the zone".

    To me, the zone is the state of mind where all of my focus is...

  • RE: select from sp

    Hoila,

    If the original SP contains a number of fields you are not interested in, then you are going to have to watch for duplicates in the set of...

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