Forum Replies Created

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

  • RE: A general way to maintain History tables

    Thanks for the article,
    I think I spotted a typo in the last paragraph of the Introduction:
      "... we will look closed at a cleanup type ...",

  • RE: Rounding Tips and Tricks

    Thanks for this excellent article - very clearly explained with good, step-by-step examples.

    I kind of already knew this, but it's nice to have a reference so clearly written up.

  • RE: Date-based table purge

    Thanks for sharing your procedure - very interesting.

    One comment I have is that I noticed the parameters for the TableOwner (schema), and TableName are defined as varchar(64). Have you considered...

  • RE: All SQL Version info in one function

    THankyou for posting - handy function and a good tecnique to group all the required info in one result

  • RE: Generate HTML output for given SQL Query

    I would tend to agree with Mike Dougherty-384281. This approach seems like a bad idea for a number of reasons.

    Why not use a "FOR XML" query and transform the...

  • RE: Change String to Title Case(Initcap)

    Thanks for the useful script!

    However, I noticed that you used:

    Select @vString = Replace(@vString, @vWord, '')

    This replaces _all_ occurrences of @vWord in @vString, eliminating repeated words in the title.

    I fixed this...

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