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...

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...

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"....

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...

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...

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...

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...

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...

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

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...

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...

iqtedar

Thank you for your feed back...

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

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

(DBCC USEROPTIONS) to determine if arithabort is set?

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...