Forum Replies Created

Viewing 15 posts - 31,156 through 31,170 (of 39,754 total)

  • RE: Limit Resources to UGLY query

    I'm with Jeff, what's undocumented? The (#index)? That should be ok.

  • RE: The Value of Information

    Actually the point of RSS is to get you a bit of the content so you can determine if you're interested. If so, you should click through the links. Authors...

  • RE: Sub Newbie question

    Ah,memories. I used to have that box in my cube. Right next to the OS/2 manuals (insert shudder here).

    Anyone remember the "probe" user?

  • RE: converting hex data to char

    There probably is. I know some companies licensed code from MS to decode that stuff. Not sure if it's out in the wild yet. I'll ping a few people.

  • RE: Seamless Upgrade

    Actually it's April 8 for 2000. And that's the end for mainstream support. You'll still get security patches and you can pay (through the an orifice) for extended support after...

  • RE: The Differences Between SQL Server 2000 and 2005

    On the questions from MudLuck.

    It's kind of an unofficial policy from Microsoft that they'll support at least 2 versions of a product. However with their product cycles, and being $$...

  • RE: converting hex data to char

    You'll need to use some type of third party tool, a trigger, or a separate insert if you control access to tables with procs.

    Those are the three options. I'd like...

  • RE: The Differences Between SQL Server 2000 and 2005

    Can you explain what you mean by user difference? Or what you're looking for?

  • RE: Half a Million

    Wow great comments, and a few emails as well.

    Thanks for the notes and I'm very, very proud that we have been able to help so many of you. And for...

  • RE: Generating unigue 5 digit number and three digit day of year

    I think that's a pretty good solution and it was about what I'd suggest. Use a unique number of reach one, and include the datetime.

    We used to do something similar,...

  • RE: Altering a column to allow nulls

    You want to alter the column to allow nulls, not a default of null. Run these one at a time. The first insert of null should error out.

    create table MyTest

    (...

  • RE: Date / Time transactions

    So which fields or rows do you want to differnce of time between?

    Are you looking for the difference between two columns or the difference between every row? Every pair of...

  • RE: how do you know who is logged in from a windows group?

    Not sure. Are you sure it should be displayed? There could be system processes or SQL logins.

  • RE: Database var

    You cannot have a database name for a variable as you've asked without dynamic sql.

    In SQL Server 2005, use sys.databases, not dbo.sysdatabases.

  • RE: Another grouping query

    This almost sounds like homework. Can you post what you've tried?

Viewing 15 posts - 31,156 through 31,170 (of 39,754 total)