Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 3,221 total)

  • RE: Parameters that are empty

    Richard Holloway (9/16/2010)


    Normal environment. The @PM is a nvarchar(I set to 4000) just in case a person selected quite a few from the listbox. I can post the...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Parameters that are empty

    Richard Holloway

    It does help if you post your forum question including table definition(s),

    some sample data, and your complete procedure. Follow the first link in my signature block to learn...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    All this talk of stoned, cold stone .. is making me hungry. One of my favorite restaurants on Grand Bahama Island, is believe it or not, the

    "Stoned Crab"....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Invalid character value for cast specification

    The only input data supplied:

    SET IDENTITY_INSERT GPM_Safety_Inspection_Descriptions ON

    INSERT INTO GPM_Safety_Inspection_Descriptions

    (ID, sDescription, iSort_Order1, iSort_Order2)

    SELECT '1','Are Material Safety Data Sheets (MSDS) on file and available for all employees?','1','1' UNION ALL

    SELECT '2','Work Comp...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Invalid character value for cast specification

    When running your SP using the debugger and imputing the @Date value as

    '2010-09-15 20:03:05.043'

    I get your error message. Attempt to debug without enclosing the @date as if it were...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    Alvin Ramard

    Key reasons for putting things underground is so that they will be less likely to be in the way of anything, and less likely that anything will make contact...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/15/2010)

    --------------------------------------------------------------------------------

    Alvin Ramard (9/15/2010)

    --------------------------------------------------------------------------------

    CirquedeSQLeil (9/15/2010)

    --------------------------------------------------------------------------------

    jcrawf02 (9/15/2010)

    --------------------------------------------------------------------------------

    bitbucket-25253 (9/15/2010)

    By the way for some reason going down is always slower and harder than going up.

    Couldn't have anything to do with the fact...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    Craig Farrell (9/15/2010)

    --------------------------------------------------------------------------------

    CirquedeSQLeil (9/15/2010)

    --------------------------------------------------------------------------------

    Steve Jones - Editor (9/15/2010)

    --------------------------------------------------------------------------------

    Once that guy got outside the caged area, my stomach was flip flopping. Struggled to watch, and then was stunned again when he...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/15/2010)

    --------------------------------------------------------------------------------

    And on an unrelated note. Who wants this job?

    http://www.youtube.com/watch?v=txdv_oNq81I&feature=youtu.be

    Been there, done part of that as a member of a team which installed TV broadcasting stations,...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    Brandie Tarvin Posted Today @ 7:15 AM

    All this talk about the "rankings" makes me want to know what they are and how many points or posts it requires for...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Query that considers "exclusion criteria" and "optional criteria" to give a "score"

    didier.boelens

    You increase the chance of receiving a tested answer to your question if you post the table definition and sample data and what you have attempted in accordance with the...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Query exiting if failed in Cursor. Please advice/ Not Able to capture error

    iqtedar

    Thank you for your feed back...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Arithmetic overflow error

    sunny.tjk

    To learn more about these options and their effects read this:

    http://technet.microsoft.com/en-us/library/ms190356(SQL.90).aspx

    How to set the option(s) read this:

    http://technet.microsoft.com/en-us/library/ms190306(SQL.90).aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Arithmetic overflow error

    An off the wall guess ... have you checked your DB option settings

    (DBCC USEROPTIONS) to determine if arithabort is set?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Query exiting if failed in Cursor. Please advice/ Not Able to capture error

    Slight modifications and it works for me

    Add the BEGIN TRY, END TRY, BEGIN CATCH and END CATCH to your code. I added to Wayne S code and tested OK...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 15 posts - 1,756 through 1,770 (of 3,221 total)