Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 7,187 total)

January 17, 2017 at 2:07 am

#1923127

  • RE: why is this trigger not working ?

    Please will you explain the purpose of the trigger?  How many rows are in the table?  All it's going to do is return the number of days between start_date and...

    January 16, 2017 at 8:13 am

    #1922993

  • RE: User Permission to view Only View not base tables

    Rechana Rajan - Monday, January 16, 2017 5:37 AM

    John Mitchell-245523 - Monday, January 16, 2017 2:31 AM

    January 16, 2017 at 5:59 am

    #1922955

  • RE: Select next appropriate record.

    Thanks, but you didn't test the INSERT statement, did you?

    Arithmetic overflow error converting expression to data type datetime.

    John

    January 16, 2017 at 5:55 am

    #1922953

  • RE: Select next appropriate record.

    Are those dates in European or US format?  I can't tell.  Please supply them in an unambiguous format (such as '20170116') and test your INSERT statement before posting.

    Thanks

    January 16, 2017 at 5:05 am

    #1922944

  • RE: Select next appropriate record.

    OK, and what result do you expect given that sample data?

    Incidentally, if you provide your sample data in the form of CREATE TABLE and INSERT statements, it makes...

    January 16, 2017 at 4:09 am

    #1922930

  • RE: Alter index at same time as updte statistics caused deadlock - recommendations

    Damian

    It's not necessarily purely a priority thing - if both processes have equal priority, then the process that's easier to roll back is chosen as the victim.

    January 16, 2017 at 4:00 am

    #1922929

    • Viewing 15 posts - 1,996 through 2,010 (of 7,187 total)