Forum Replies Created

Viewing 15 posts - 16 through 30 (of 541 total)

  • RE: The ARRAY In SQL Server 2000

    This article is over 2 1/2 years old, and it generated some controversy the first time around. So why is it a "featured article" in today's newsletter?

    Steve, do you...

  • RE: Accidently Agile

    Steve Schmechel,

    Thanks for logging in just to crap all over the article, that time as not wasted. I'm sure everyone appreciates your snide comments and asinine POV. You...

  • RE: Accidently Agile

    A top notch article as usual, Mr. Poole. Where I work it's all waterfalls....

  • RE: Hidden RBAR: Triangular Joins

    Wow, if this is an indication of the new quality of articles at SQLServerCentral, color me impressed! Over impressed, I'm kinda wowed.

    "if you have to touch more internal rows...

  • RE: Passing a Table to a Stored Procedure

    " That would mean you have a magical,

    super function that works on Squids, Automobiles, Britney Spears"

    That's a great quote, but I don't think it's necessarily pejorative, as the link states....

  • RE: Writing Faster T-SQL

    Nice method by Ben-Gan! He "wins", 'cause I just bought his book.

    You could do this as a recursive CTE; that would be cool.

    http://msdn2.microsoft.com/en-us/library/ms186243.aspx

  • RE: Nesting Stored Procedures

    I like the way you code, Robert, looking forward to seeing more articles.

  • RE: Common Table Expressions in SQL Server 2005

    I like the way the article was written, but the examples were trivial ones that could easily be done with a simple select. The recursive article linked to in...

  • RE: A Special Announcement from Andy, Brian, and Steve

    Couldn't have said it better myself, Brian! An independent community would be better for everyone, and I would say the same thing if apexsql bought the site.

    That said, we're...

  • RE: When To Use Cursors

    "I decided in the end that nobody was going to come up with an answer to my previous question about the performance difference between a cursor-based procedure, and one based...

  • RE: SQLServerCentral Rules of Conduct

    OK, I went and read through the comments in question, and I didn't see any flame war. Maybe people weren't as nice as they could be, but they seemed...

  • RE: SQLServerCentral Rules of Conduct

    "The exception being you can insult me if you really want to."

    lol..that's funny.

    It's a good joke, but in all seriousness you should censor anybody who insults you, too. Don't think...

  • RE: Upsert Dimension Table

    Oh, upsert...thought this was the upskirt discussion.

    But seriously, what's wrong with the following?

    Update e

    set ColumnName = i.ColumnName

    from ImportTable i

    JOIN TableName e on i.uniqueID = e.uniqueID

    Insert TableName (ColumnName)

    select i.ColumnName

    from ImportTable...

  • RE: Upsert Dimension Table

    Is it just me, or is the article missing?

  • RE: A Special Announcement from Andy, Brian, and Steve

    Wow, awesome news for you guys, congratulations! If I was going to be at PASS this year I'd shake your hands, but I'm cheap and couldn't get anybody to...

Viewing 15 posts - 16 through 30 (of 541 total)