My bad!

The pre tag won't avoid the smileys. (but your code looks prettier!)

Sorry

-Robert

Sure:

Both blocks of code are formatted the same when pasted into the forum. The bottom block is wrapped in <PRE> </PRE>

Code taken from another thread:

SELECT a.*,

...

I really enjoyed the article, thank you!

It's probaly a little late to mention this but, another thing that would be very useful as public knowledge is the <Pre> tag.

Using the...

What is the data type of the number column? (please don't say float!)

Your best bet is to make that column an identity column (rather than go through the hassle...

Very good article!

I thought I would share another good resource on this topic. Microsoft has a system table map available on their website.

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

-Robert

Looking at your sql code, you would like @InPar to be a byte array?

If this is the case, you could try storing @InPar as a VARBINARY (it probably won't work...

SP_getapplock needs to be run inside a transaction.

I'm not convinced that this would be the best idea but...

In order for you to make this work for your situation, you...

I would be interested to know a little more about your SessionLockID column. I would guess that you are using this column to tell a client application weather a record...

Thank you both very much for your feedback!

Noel:

I agree, the

IF not exists()

Insert...

Technique is definitely flawed; I have seen this approach fail many times. Very good point about combining the...

It's probably worth mentioning that you can select from and join to a table-value function. If I understand what you're asking would something like this work?

SELECT @AcctCodeValue = Replace(@AcctCodeValue,' ',...

For what it's worth, here is a set-based approach. It requires a numbers table though.

IF EXISTS ( SELECT  1
          ...

Joining a local table to a remote table isn't always a bad idea but

DML queries on remote servers are always painful. It is much faster to run updates on...