Becasue the client is using SQL Server 7.0.

The sort answer is yes. In our development environment we have installed 2000 and 2005 on the same box without any problems. We even have multiple instances of 2005 on...

Basically all I was wondering is what are differences between using or not using the transaction block code in the stored procedure. The only difference I could see was that my...

Here is a link to update your books online which it seems might be out of date.

http://www.microsoft.com/downloads/details.aspx?FamilyId=A6F79CB1-A420-445F-8A4B-BD77A7DA194B&displaylang=en

It was in the SQLServerCentral 7/15 issuse.

Enjoy.

Kris

The problem I have with using the calculated field is that the value will change if the formula that calculates the value is changed. So in my case if we change...

Hi Phil,

The calculated field idea won't work because I don't want the value to change once it has been calculated. Basically I am creating a confirmation number for a record when...

Mark,

Check out this example. I think this will give you an idea of how to do what you want.

http://www.sqldts.com/?246

Kris

Alamir,

Here is solution you could use.

Your table will need a field that can be used to determine the status of the record. Example: RecordStatus as TinyInt; 0-Unused, 1-Active, 2-Inactive..... default...

Alamir,

How are you currently getting the customer number that is being displayed?

My first thought is to use a transaction block so you could rollback on a cancel but that might...

Alamir,

How are you getting this customer number before the addition of the record?

Are the different departments entering customers at the same time, or close to the same time? If there...

Thanks Andy & Jamie that got me what I needed. I had been trying the ? for the parameter but I couldn't get it to work. Thanks a lot.

Kris