Hmm... What I would do is create another column and make it an identity insert starting at 10000 or something... You could even make this your primary key and get...

I think we really need more information here... What exactly are you trying to do; i.e. if a new row is inserted, what changes with an old row? Also, if...

I'm not sure that deadlocks are really your concern here. Of course, this all depends on the data. Are each of these users going to be altering the same...

I'm not sure that partitioning is the best way to do this since you still have to go through all of the data no matter which partition it is.

Jared

Can you have 1 column be an identity column, another be a flag or something, and a final one be a calculated column based on the identity and the value...

I find it interesting that you know what the MERGE statement is, yet you do not know how to update using an inner join. Is this a homework question?

Jared

This would be done using an inner join.

Thanks,

Jared

Gabriel P (9/21/2011)

---

If anyone cares, I found out the problem.

SSMS Menu -> Tools -> Options

In the left window click on the SQL Server Object Explorer branch > Scripting

In the list...

Well... A nested transaction is where the transaction inside another needs to occur first. It must be that the one inside cannot be accessing a linked server. Hmm... Sorry, I...

NJ-DBA (9/20/2011)

---

jared-709193 (9/20/2011)

---

I still believe that we are missing a bigger issue here. We are developers/admins who work within an interface that executes script very easily. We can...

I still believe that we are missing a bigger issue here. We are developers/admins who work within an interface that executes script very easily. We can all come...

1. Are both servers running the exact same version of SQL Server? i.e. 10.50.2500

2. We had issues running stored procedures that had heterogeneous queries and found that you must create...

The other thing that will not require you to change any settings or add nonsense code is to simply disconnect the session after the query is generated. Or, if you...

danschl (9/16/2011)

---

there are lots of reasons to setup partioning

And if there is a reasonable chance the database is going to grow as they tend to do. Better to do...

Try this:

ALTER PROCEDURE [dbo].[abc_specialty1_sp_]

@sysID bigint,

@qnxtStatus char(15),

@ReturnCode AS INT OUTPUT,

@ErrMsg nvarchar(4000)OUTPUT

AS

BEGIN

SET NOCOUNT ON;

BEGIN TRAN T1

BEGIN TRY

UPDATE abc_specialty_tbl

SET code =

CASE

WHEN NPVS.code IS NOT NULL THEN NPVS.specialt

ELSE NPS.specialty

END,

type =

CASE

WHEN NPVS.type IS NOT NULL...