Make sure you have the semi-colon in front of the WITH.

Also, make sure you are running on at least a SQL2005 machine with a DB in 2005 compatibility mode.

1. You want to search for SQL String Concatenation. I have given you one technique.

As string concatenation in TSQL is a bit of a fiddle you may want to return...

Your schema is not very good but you can obtain your result like:

-- *** Test Data ***

DECLARE @bo-2 TABLE

(

&nbsp&nbsp&nbsp&nbspDDS char(2) NOT NULL

&nbsp&nbsp&nbsp&nbsp,BOCleared int NOT NULL

&nbsp&nbsp&nbsp&nbsp,BOClearedDate datetime NOT NULL PRIMARY KEY

)

INSERT...

This may be more random. It may be better to do this in the middle tier or with a cursor.

-- *** Test Data ***

DECLARE @t TABLE

(

&nbsp&nbsp&nbsp&nbspTId int IDENTITY NOT NULL...

This may not be particularly random.

-- *** Test Data ***

DECLARE @t TABLE

(

&nbsp&nbsp&nbsp&nbspTId int IDENTITY NOT NULL PRIMARY KEY

&nbsp&nbsp&nbsp&nbsp,bit1 bit NOT NULL

&nbsp&nbsp&nbsp&nbsp,bit2 bit NOT NULL

&nbsp&nbsp&nbsp&nbsp,bit3 bit NOT NULL

&nbsp&nbsp&nbsp&nbsp,bit4 bit NOT NULL

&nbsp&nbsp&nbsp&nbsp,bit5...

You only need to explicitly release the lock if you set it as a SESSION lock otherwise the it will last for the rest of duration of the connection.

Thanks for...

Robert - App Locks can be made to apply to the current session and not just the current transaction. It is then up to you to explicitly release the lock...

As serializing will block inserts for other sessionIds, I would be inclined to use an

application lock.

(If the majority of your upserts are updates, I suspect replying on a CATCH block...

After briefly scanning the post:

1. GO is not a SQL command but a batch terminator in the tools. Try getting rid of it.

2. @CRLF should be char(13) + char(10)

1. You failed to copy and paste correctly from the following

http://www.sqlservercentral.com/Forums/Topic644782-1291-1.aspx#bm644794

2. if ((select @z) <= 10) should be if (@z <= 10)

3. Why bother with cursors? Try something like:

DECLARE @SQLString...

-- *** Test Data ***

CREATE TABLE test

(

&nbsp&nbsp&nbsp&nbsp[Name] varchar(20) NOT NULL

)

INSERT INTO test

SELECT 'Name1' UNION ALL

SELECT 'Name2' UNION ALL

SELECT 'Name1' UNION ALL

SELECT 'Name2'

-- *** End Test Data ***

DECLARE @y varchar(20)

&nbsp&nbsp&nbsp&nbsp,@z int

&nbsp&nbsp&nbsp&nbsp,@SQLString...

Your question is not clear.

To get decent answers you will need to post:

1. test Data - missing.

2. your query - done.

3. your results - done.

4. expected results - missing.

You query...

DECLARE @LCFId int

SELECT @LCFId = MAX(ClientFileNumber)

FROM dbo.myTable

RETURN @LCFId

I hope you are not incrementing the result and writing it as the next FileNumber!

SELECT CONVERT(datetime, '01 ' + REPLACE(SourceDate, '-', ' '), 106)

This is not what Jeff's article says.

In this case the main join criterion is [Order]. In the triangular part of the join...