Gail,

What I am trying to do is the following:

* Website customer creates order in Shopping cart header / detail tables

* When customer says place order, website puts record in...

When I run it from DOS, it works fine. No hang. Debug messages get written. It hangs on the 'update web_processing_queue...' statement.

Mike

Jeff

Oops. I do have a system defined data type of ID. It is an INT.

Mike

Jeff,

Sorry about that. I thought maybe I put it in the wrong place. Is there a way to cancel this thread?

Mike

Yes, we have to store them as we offer "card on file" options. Do you have any good 3rd party software that can be used in SQL, .net operations...

What would you recommend for storing credit card information? Using 2008 encryption or a 3rd party?

I have tried different approaches. I posted a second thread with one of the approaches. ANY help would be appreciated. Thank you for your time on this.

Mike

Also, the line: @C IDs Readonly, has a red wavy line. The intellisense shows this message:

The parameter "@C" can not be declared READONLY since it...

Sorry about that. Here is the definition I used:

/* Create a user-defined table type

CREATE TYPE IDs AS TABLE

( id INT NOT NULL, primary key (id) )

*/

I still...

Kingston D.

But i can give you a better way of doing the update without using the #C and which will not give you problems if you have NULL values as...

Yes, I use it to do an insert into another table as well.

Thank you to all who contributed. I will try the truncate table idea.

Mike

Here is a code block that can duplicate the problem. I know it is a simple example, however, if I can understand how to make this example work, I...

Sorry, I should have stated that the error occurs on the 2nd SQL statement (after the 1st drop table).

Mike

Huntington Beach California USA

a.k.a. Surf City USA

😀