Forum Replies Created

Viewing 15 posts - 17,716 through 17,730 (of 26,489 total)

  • RE: SSIS Licensing Question

    Gkhadka (12/22/2009)


    CriquedeSQL... I think you missunderstood the question above. I think he is saying that he installed SQL 2008 and SSIS on one server (let it be a DEV box)....

  • RE: Help in making Query

    First, I'm glad this is a SQL Server 2005 forum. Here is a possible solution, but how you implement it is all up to you since you haven't provided...

  • RE: Convert GETDATE() to YYYYMMDD

    Not a problem posting your code. It actually is different than was suggested before. It is always good to post your final solution. Others may benefit, so...

  • RE: Dateadd, Datediff function Question

    Also, are you running this code in the Cache database or via a linked server?

  • RE: Dateadd, Datediff function Question

    Can you please post the code you are running? I know nothing < * using my best Sgt Shultz imitation * > about Cache or how you are accessing...

  • RE: Dateadd, Datediff function Question

    bigclick (12/23/2009)


    Yes, it would make sense to have the actual call begin time. Thanks again for your help.

    Call Begin Date: 12/03/2009

    Call Begin Time: ...

  • RE: Dateadd, Datediff function Question

    bigclick (12/23/2009)


    Our vendor was able to give us an example.

    Call Begin Date: 12/03/2009

    Call Begin Time: -100

    Call End Date: 12/04/2009

    Call End Time: ...

  • RE: StoreProcedure not reteurning any rows which containg local variables

    abcim (12/23/2009)


    >>Can you answer this: for any one reportID passed into the sproc to retrieve your data, what is the reportID returned by this bit:

    ... SELECT Top 1 ReportId FROM...

  • RE: Any SQL gurus / n00bs that are closet musicians?

    david.tyler (12/22/2009)


    Before joining the ranks of the IT industry I was 110% involved in music. I played drums for over 20 years starting in the school bands and venturing to...

  • RE: Dateadd, Datediff function Question

    bigclick (12/22/2009)


    Good & expected data in TIME_CALL_BEGAN field:

    2009-12-15 09:30:19.000

    Bad data: -09384593 (note: this is a made up number similar to what we encounter. It...

  • RE: Are the posted questions getting worse?

    Jeff Moden (12/22/2009)


    GSquared (12/22/2009)


    Lynn Pettis (12/22/2009)


    I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing...

  • RE: Are the posted questions getting worse?

    GilaMonster (12/22/2009)


    Bru Medishetty (12/22/2009)


    Well you see Steve, Jeff, Barry, Grant, Jack , Gail, Alvin, Bob (active posters in this thread) are all on vacation / holiday mood and no...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (12/22/2009)


    Lynn Pettis (12/22/2009)


    CirquedeSQLeil (12/22/2009)


    Bru Medishetty (12/22/2009)


    Lynn Pettis (12/22/2009)


    Hey, this is the BEST place to waste time. I enjoy my time out in the desert!

    Which place are you from...

  • RE: Are the posted questions getting worse?

    Bru Medishetty (12/22/2009)


    Lynn Pettis (12/22/2009)


    Bru Medishetty (12/22/2009)


    Lynn Pettis (12/22/2009)


    Hey, this is the BEST place to waste time. I enjoy my time out in the desert!

    Which place are you from...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (12/22/2009)


    Bru Medishetty (12/22/2009)


    Lynn Pettis (12/22/2009)


    Hey, this is the BEST place to waste time. I enjoy my time out in the desert!

    Which place are you from Lynn and Jason?

    Hail...

Viewing 15 posts - 17,716 through 17,730 (of 26,489 total)