I've used this method for a couple of years now and have found it very effective.

Another advantage of this method is that it is possible to move the transactional boundary of...

How about...

delete S

from

    stagingin S

    left join plans P on P.id=s.id

where

    P.id is null

These dt_ procedures are created for me when a new database diagram is selected from EM. 

Don't touch the database diagrams, and those procedures won't be created.

Hey good idea Antares686

update tblName set @var = col = col + 1

I'll definitely use this method from now on.  No explicit transaction, no explicit locking... Thanks!

I can't offer you an alternative, as I don't know your business requirements.

I don't know how flexible your system needs to be, but when I saw that you were getting...

By putting the update straight after the read is enough.  You need to do more.  Check this script out to illustrate my point...

use tempdb

create table Numbers (LastNumber int not null,...

What?  Sorry, but I'm not sure of your requirement.

Are you saying that if two users are using the same type, it is OK for them to have duplicate numbers?

You need to have the "selecting, incrementing & updating" process happen for one person at a time.  You can use a transaction and locking to do this,...

I looked at your proc, and have a few concerns.

1) You state that it handles the multi-user environment by generating and updating the next number in...

User defined function.  Now why didn't I think of that!  That's a much more elegant solution, go with that.

Good work.

OK, you will need to put this sql into a stored proc...

Also if you are using SQL2000, I'd use table variables instead of temporary tables.

create table #Output (TaskId int, StaffNames...

Look at the following link to give you some ideas...

http://www.sqlservercentral.com/scripts/contributions/506.asp

You need to use seperate dimension tables for time and your UPC field.

Run the following script for the purpose of this example...

CREATE TABLE [UPC] (

 [UPC] [char] (5) NOT NULL

) ON...

How about something like...

select case when A=B then 1 else 0 end

from

(

SELECT

    CHECKSUM_AGG(BINARY_CHECKSUM(*)) as A

FROM  

    Table1

) RC1

,

(

SELECT

    CHECKSUM_AGG(BINARY_CHECKSUM(*)) as B

FROM  

    Table2

) RC2

You've posted to the wrong forum.  Actually you've posted to the wrong site!

For ASP/ASP.NET help (you asked about creating a web form) try the following links...

http://www.aspfaqs.com/aspfaqs/

http://asp.net/Forums

http://www.4guysfromrolla.com/