Forum Replies Created

Viewing 15 posts - 751 through 765 (of 1,086 total)

  • RE: data comparison

    This is one possible solution; I'm sure there is probably a better select statement. 

    I have assumed you have already pumped your Excel spreadsheet into SQL Server and called the...

    I wasn't born stupid - I had to study.

  • RE: Dynamic Error Handling in Procedure

    EricP37 says: 

    Now this one works great and generates the following correct messages....because the denominator = zero.

    Server: Msg 8134, Level 16, State 1, Line 1

    Divide by zero error...

    I wasn't born stupid - I had to study.

  • RE: How to plug in today''''s date for dump filename?

    How many choices are there? 

    I wasn't born stupid - I had to study.

  • RE: Function to return position of occurance in a string

                       

    I wasn't born stupid - I had to study.

  • RE: UDB to SQL conversion

    Have you tried running it?  What error do you get? 

    It does not look very efficient, but it should run.   

    I wasn't born stupid - I had to study.

  • RE: Matching Values

    So many of us seemed to have been fascinated by this, I thought it might be good to repost the entire code.  I have yet to play with this, but...

    I wasn't born stupid - I had to study.

  • RE: Delaying Trigger

    BOL - WAITFOR { DELAY 'time' | TIME 'time'

    Not sure if that will work with a Trigger... (Remi has a very good point, you may want to look...

    I wasn't born stupid - I had to study.

  • RE: Versioning Rows for Point-in-time

    Agreed!  (And Remi you are nothing like that...).  It is too bad, especially for new members who encounter that...

    I wasn't born stupid - I had to study.

  • RE: Versioning Rows for Point-in-time

    You're not at all that rude - I was just needling you...

    I wasn't born stupid - I had to study.

  • RE: Versioning Rows for Point-in-time

    I agree with Celco... er, I mean Remi. 

    You may want to consider making this history table in a seperate database depending upon...

    I wasn't born stupid - I had to study.

  • RE: Privileges (stored procs)

    Thanks.  That makes sense. 

    I wasn't born stupid - I had to study.

  • RE: Privileges (stored procs)

    If I am reading BOL correctly, then I would want to use the following: 

    SELECT o.name

    FROM sysobjects o

    WHERE o.type = 'P'

      AND permissions(o.id) & 32 <>...

    I wasn't born stupid - I had to study.

  • RE: Privileges (stored procs)

    Thank you, Remi!  Must admit, it took me a bit of time to recognize how to use with and without 'Domain Users'.  It is very good for specifying my own Roles...

    I wasn't born stupid - I had to study.

  • RE: Privileges (stored procs)

     

    I stated that very poorly.  I meant, does anyone know how to find the privileges for Stored Procedures....  sorry. 

    I wasn't born stupid - I had to study.

  • RE: Aggregation conundrum

    Beautiful!  I was messing with this and going a wholely different route. 

    I wasn't born stupid - I had to study.

Viewing 15 posts - 751 through 765 (of 1,086 total)