Forum Replies Created

Viewing 15 posts - 3,376 through 3,390 (of 4,081 total)

  • RE: Using SELECT with a variable in column region of a query.

    Great 😀

    I only learned about the speed of ITVFs in the last couple of months, from someone else in here. The performance gains are enough to justify the...

  • RE: Using SELECT with a variable in column region of a query.

    Great 🙂

    I only learned about the speed of ITVFs in the last month or so, from someone else in here. The performance gains are enough to make...

  • RE: Create View with Split Columns

    Thanks, Jeff.

  • RE: Using SELECT with a variable in column region of a query.

    A couple of suggestions:

    (1) To improve performance, rewrite your scalar functions as inline table valued functions. They run MUCH faster in queries that produce large result...

  • RE: T-Sql rant

    That's the best thing about rants, Sergiy 😀

    Now I personally have no intention of visiting the aforementioned blog. But, according to Wikipedia...

    Dataphor was originally created as a commercial...

  • RE: T-Sql rant

    I'm in the states, and the choice of beverage is secondary to the opportunity for a good conversation. Do you do caffeine?

  • RE: question, urgent please!!!

    I realized that one Mh is SSC Enthusiastic and the other is a Forum Newbie. Can we assume that the "Urgent Urgent" isn't really any more?

  • RE: T-Sql rant

    Guiness is better. Perhaps some day we'll have opportunity to knock back a pint or two, Lynn. First round is on me.

  • RE: Is this where to use a cursor?

    No cursor needed. I don't have your original data, so I'm using a table variable in my code below to mimic your output. The code below...

  • RE: Is this where to use a cursor?

    No, we aren't sure what you want your output to look like.

    One field on a particular table is used for 4 different fields on the report; what differentiates each one...

  • RE: T-Sql rant

    Science is a b****, expediency is a w*****.

    You call the language above a mark of maturity? Crass doesn't equal cool, and foul language isn't a...

  • RE: Are the posted questions getting worse?

    Hey Steve, you may need to implement some functionality to lock down Author's Names in the forums.

    Something peculiar is going on here.

    The thread was started by...

  • RE: question, urgent please!!!

    Took me a while to sort out the identities by join date.

    The obvious question to ask is:

    If the other Mh wasn't the person that started this thread, why did they...

  • RE: Are the posted questions getting worse?

    I'm all for wine tours, but only if we include New Zealand and Australia as well. Maybe Argentina too. Obviously, I drink a lot from the...

  • RE: Pivot a table

    There are a couple of ways.

    First, if you are running this from SQL Enterprise Manager, there is an option to include row headers when you send...

Viewing 15 posts - 3,376 through 3,390 (of 4,081 total)