hmm, it did not quite explain the problem.

At least to me.;-)

Can you please provide some data samples where the script fails and explain what outcome you'd expect from it.

Then I...

Now, what is wrong with the approach I posted?

Where does it fail to provide the result you need?

First, you need to have some kind of ID on the records in the table, otherwise each record will be always matched to itself.

Assuming, you have such ID here is...

There must be a typo after @MAX_NUMBER:

SET @QUERY='SELECT @MAX_NUMBER = MAX('+@DB_NAME+'.'+@SCHEMA_NAME+'.'+@TABLE_NAME+'.'+@COLUMN_NAME+') FROM '+@DB_NAME+'.'+@SCHEMA_NAME+'.'+@TABLE_NAME

And, it's a good habit to prevent a possibility of an...

See...

That's the way!

You runt it once and you use the outcome (data in the table) indefinitely.

And if the angry boss comes...

John, I copied your syntax to my reply and only after posting I realised - it's wrong.

Parameters in stored procedures do not require brackets:

CREATE...

It's pretty common to find strings like that in syscomments:

/*

The procedure updates values stored in table SessionValues

*/

CREATE Procedure abc_SessionValuesUpdate (a int) AS

SET NOCOUNT ON

BEGIN

UPDATE SessionValues SET Value = @Value...

Check Distributed Transaction Coordinator status.

This would do the same:

SELECT

TOP 100

comp_id, sup_code, sup_name, sup_ac_code, '0a1705011715553107773972'

FROM

comp_ac

ORDER BY

comp_id

It does not seem to make...

select top 5 PATINDEX ('%waitresource=OBJECT%', TextData)

, substring(TextData, PATINDEX ('%waitresource="OBJECT%', TextData) + LEN('waitresource="OBJECT')+1, 20)

convert(varchar, TextData)) does not have the length of varchar soecified.

By default it's equal to convert(varchar(30), TextData)).

And actually you do not need to convert Textdata at all.

Use PATINDEX instead of...

Peter E. Kierstead (2/20/2008)

---

The previous poster is correct about using RAISERROR as opposed to PRINT to eliminate output queing, however, RAISERROR has a feature that my cause you problems if...

sqlpadawan_1 (4/8/2013)

---

Imagine a SELECT in a proc that returns active widgets, the WHERE is always going to be the same. So do you code your where clause...

On my desktop (2k8) both queries perform equally:

(1 row(s) affected)

SQL Server Execution Times:

CPU time = 141 ms, elapsed time = 148 ms.

(1 row(s) affected)

SQL...