Forum Replies Created

Viewing 15 posts - 20,026 through 20,040 (of 22,202 total)

  • RE: The Daily Commute

    I'm doing about 35 miles each way here in the US. The trick I've found that works is to come in early and leave early. Avoid the common commute times....

  • RE: Inserting horizontal row in result of query

    It really sounds like you're trying to generate reports.

    I'd suggest one of two options, first, use a reporting tool, like the Reporting Services tool that comes with SQL Server or...

  • RE: Re: Constrainted values versus foreign key table

    Personally, I'd go with option 2. That way, you don't have to worry about spelling and, when another state, "suspended" or something, comes along, you're ready and won't have to...

  • RE: Enough is Enough

    We get these debates where I work a lot. For some reason, many of my fellow DBA's believe that every known bug has to be addressed prior to release or...

  • RE: A discrepancy in the amounts being totaled

    May as well pile on to this one...

    It's not a problem. Half the time when I type up the question to post it up here when I'm stuck, the act...

  • RE: A discrepancy in the amounts being totaled

    Not to mention, is there more than one access path? Can people modify the values after they've been entered? If so, are there triggers in place to account for that...

  • RE: PASS

    HA!

    And I thought you meant Quality Face Time...

    Oh jeez. The internet has let me down... again...

    :alien:

  • RE: PASS

    I had to go and look QFT up. :ermm:

    See, even when you're not teaching, you're teaching. There's a darn good reason you're an MVP.

  • RE: PASS

    Yeah, all the training, access to Microsoft programmers, PSS, the vendors, the swag, Steve's magnificent night of gambling... All great stuff.

    The absolute most important part of the Summit is getting...

  • RE: A discrepancy in the amounts being totaled

    Then that doesn't sound like a structural problem. It must be one of logic.

    There's no way for innacurate numbers to be entered or values to be changed over time?

  • RE: A discrepancy in the amounts being totaled

    How far is it off? Hundreds & thousands or only a few dollars or cents? If it's the smaller number, it could be rounding errors. You didn't specify the data...

  • RE: PASS

    Frequently you'll see people refer to meeting at PASS or going to PASS. Then they're not talking about the Professional Association of SQL Server users, as linked above, but the...

  • RE: 2005 equivalent

    There isn't a replacement. From the BOL:

    ALL

    This option is deprecated and maintained only for backward compatibility. It does not grant all possible permissions. Granting ALL is equivalent to granting the...

  • RE: Error Handling

    It does parse, but try generating an estimated execution plan. It fails immediately. Parse and compile aren't the same.

  • RE: Re: Constrainted values versus foreign key table

    I've done this two different ways.

    First was to add an effective date column and then always sort by effective date to get the latest effective value.

    Better was to create...

Viewing 15 posts - 20,026 through 20,040 (of 22,202 total)