Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 7,636 total)

  • RE: Query Elapsed Time

    Goldie Graber (5/22/2009)


    For some reason when I use GetDate() I always get zero.

    When I use the view I get some value, usually under 100 ms.

    I'm thinking that's because SQL Server...

  • RE: Need CLR replacements for OLE Automation procedures

    Marios Philippopoulos (5/20/2009)


    Hi,

    Anyone have CLR code for replacing the functionality offered by the following procedures?

    sp_OACreate

    sp_OADestroy

    sp_OAGetErrorInfo

    sp_OAGetProperty

    sp_OAMethod

    sp_OASetProperty

    sp_OAStop

    Also, currently on our SQL-2000 instance, these procedures are being used for making web-service calls. Does...

  • RE: How many bottles will fit in a box?

    jcrawf02 (5/22/2009)


    RBarryYoung (5/21/2009)


    ... usually the treatments of it that you will see (like Hugo's, IIFC) are one-dimensional in nature. Even the multi-dimensional treatments are based on rectangular shapes...

  • RE: Calculate Distance in Miles from Latitude and Longitude

    jcrawf02 (5/22/2009)


    RBarryYoung (5/21/2009)


    stevewagner (5/21/2009)


    The sample code is wrong.. the function is named LatLonDistance - so replace calculateDistance with LatLonDistance

    Yes, the sample test code has a typo in it. jcrwf02...

  • RE: Are the posted questions getting worse?

    john.arnott (5/21/2009)


    My name is John and I'm a threadaholic.....

    I have to share this with folks who will understand. I believe I will be dreaming tonight of warrior women hurling...

  • RE: Calculate Distance in Miles from Latitude and Longitude

    stevewagner (5/21/2009)


    The sample code is wrong.. the function is named LatLonDistance - so replace calculateDistance with LatLonDistance

    Yes, the sample test code has a typo in it. jcrwf02 caught this...

  • RE: Are the posted questions getting worse?

    Greg Edwards (5/21/2009)


    Florian Reischl (5/21/2009)


    I don't who's the target person (and I don't have to). Maybe a language problem? Sometimes words have different meanings in different languages.

    Ill never forget Chevrolet...

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (5/21/2009)


    Sinanju, haven't read that in a long, long time.

    Yeah, wow! I haven't read a Remo & Chuin story in over 20 years (I stopped around...

  • RE: Are the posted questions getting worse?

    GilaMonster (5/21/2009)


    Lynn Pettis (5/21/2009)


    Are we talking about our window washer friend here?

    No. It's someone who answers questions, not asks. (no one here, obviously)

    Steve: Apologies in advance if this...

  • RE: Package runs slower on server than in BIDS

    tvanharp (5/21/2009)


    I just re-read your post and you say "Access mode to Fast Load" I assumed you were referring to an OLE Destination, is that correct or is Access mode...

  • RE: How many bottles will fit in a box?

    Here's a recent article about a significant improvement in geometric packing algorithims, that includes a nice introduction as well.

  • RE: How many bottles will fit in a box?

    Jeffrey Williams (5/20/2009)


    nimmi.smith (5/20/2009)


    Thanks for the advise. I will find a math forum and post there. Any know of math forums?

    I will say it again - the problem...

  • RE: Strange T-SQL Behavior

    This has all the earmarks of an ancient SQL parsing rule. I bet this one goes waaay back. Can someone try it on SQL 2000?

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/20/2009)


    Bob Hovious (5/20/2009)


    Gail: There's hope!

    Many people have cats but go on to live perfectly normal lives. 😛

    As long as you remember this one...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/20/2009)


    Wow. I didn't realize that reference would be completely missed. Not that I know squat about the actual Woodstock. I just saw the documentary. There was a long,...

Viewing 15 posts - 2,296 through 2,310 (of 7,636 total)