Forum Replies Created

Viewing 15 posts - 3,316 through 3,330 (of 6,486 total)

  • RE: IT and Musicians?

    Phil Factor (5/15/2008)

    As you know, Steve, I'm a 60's blues (and folk) guitar player, though now I tend to specialise in playing the Uke. Perhaps I ought to record some...

    May 15, 2008 at 6:28 am

    #815813

  • RE: Need to SUM( ) two different COUNT(*) columns

    Knowing how your tables were set up would help with giving you a much more specific answer, but it sound to me that you need some kind of case statement.

    Something...

    May 14, 2008 at 2:11 pm

    #815530

  • RE: Check Constraint allow identity column to grow the value

    Grant Fritchey (5/14/2008)

    The attempt to insert a row incremented the value. It then rolled back because of the constraint violation, but the increment remained. Identity fields will increment, but they...

    May 14, 2008 at 1:39 pm

    #815511

  • RE: Advice needed

    Michael Earl (5/14/2008)

    I guess I assume your WAN is either using some kind of VPN tunnel or it is a frame relay or something that is already secure. That...

    May 14, 2008 at 1:12 pm

    #815504

  • RE: The Lighter Side - Life is like an analogy

    Charles Kincaid (5/14/2008)

    It's a round trip of 170 miles and quite expensive for a day trip but its just about possible.

    I guess the roads are much different than in...

    May 14, 2008 at 12:23 pm

    #815474

  • RE: Default parameter values in RS 2005

    Bill Whisnant (5/14/2008)

    The report that I created only includes the year and week. What I am wanting to do is to default that week parameter to the correct week...

    May 14, 2008 at 12:12 pm

    #815467

  • RE: Delete statement run on query analyzer getting errors

    That message usually appears when no primary key is present or isn't detected (used to happen with Access a lot when you didn't "introduce" it to the SQL server primary...

    May 14, 2008 at 11:42 am

    #815447

  • RE: error in dynamic sql syntax

    GilaMonster (5/14/2008)

    Replace the EXEC with a PRINT and have a look at what the constructed SQL statement is. You should be able to spot syntax errors fairly easily that way.

    And...

    May 14, 2008 at 11:34 am

    #815444

  • RE: Percent Change Calculation

    Division by 0 is an unknown value, so you can't "value" that. There is no "correct" mathematical representation of that percentage.

    You'll need to somehow prevent that form happening. ...

    May 14, 2008 at 11:15 am

    #815422

  • RE: Encrypting Data

    Just curious - I was under the impression that encryption by certificate was really not recommended for large amounts of data, since it can only encrypt 117 bytes at a...

    May 14, 2008 at 11:09 am

    #815413

  • RE: How to random dates

    John Beggs (5/14/2008)

    Todd --

    The short answer is that %3653 will produce 10 years of days. That's 365*10 + 2 for leap years.

    The thing to remember is that the...

    May 14, 2008 at 10:35 am

    #815388

  • RE: dynamic variable?

    By the way - Jason has a small typo (the source of your errors) in his 2000-compatible version:

    SELECT

    a.name

    ,reg_hrs

    ...

    May 14, 2008 at 10:13 am

    #815371

  • RE: dynamic variable?

    You call. I'd say no since that "resets" this conversation - but perhaps we can get Steve's attention to move it.

    If you do - at least point to...

    May 14, 2008 at 10:09 am

    #815368

  • RE: get consecutive rows

    rbateman (5/13/2008)

    Okay that opened my eyes but the next '+' is not necessarily the same account number as the first first '+'. So the table could look like this:

    seq...

    May 14, 2008 at 10:07 am

    #815362

  • RE: dynamic variable?

    is250sp (5/14/2008)

    Jason Selburg (5/14/2008)

    Are you using SQL 2005?

    Compatibility Level set to 90?

    The db is on 2000, but I am using Management Studio 2005 to query. Where do I find...

    May 14, 2008 at 10:03 am

    #815355

Viewing 15 posts - 3,316 through 3,330 (of 6,486 total)