Yep, got it wrong but on my defense i have to say that it was VERY tricky

When you elaborate a question in the...

All that may seems very nice until you get the First problem! from that point on you learn to hate the that sort of thing (sorry, No offence I had...

As I posted before you can get exactly what you asked for. Just change the order on the order by clause as you please

Excellent Catch I didn't know that one!!!!

Is that  your actual code?

How did you get the Max(Person_ID) to run?

shoulden't you do something like:

strQuery = "INSERT INTO resident (Person_ID, Name)

SELECT (SELECT MAX(Person_ID) + 1  FROM resident),'YourName' "

connection.Execute(strQuery&nbsp

I am not saying is bad, is that is tough to find in such a HUGE thread

In Production NO A SINGLE DEVELOPER should be Allowed 

In that Case I would create a job to retrieve the status from the Production Box and Populates a table On DEvelopment...

Long way up in this thread I  mention it

This is the simplest I have found and Yes you do require a cetificate on the client and you have to force encription with cliconfg.exe

HTH

That was intended to

order By

  numeric of m

, apha of m

, numeric of b

, alpha of b

, numeric of l

, alpha of l

Should you need order...

DBCC CHECKIDENT (TableName , RESEED, 0)

select name, crdate from sysobjects where xtype = 'U'

Can you tell me if this is what you want:

Select m, b,l

From Table

 Order By

    CAST((CASE WHEN PATINDEX('%[A-Z]%',M) = 0 THEN M

  ELSE LEFT(M,PATINDEX('%[A-Z]%',M)-1)END ) AS INT )

  , (CASE WHEN PATINDEX('%[A-Z]%',M)...

How About:

DELETE dbo.vw_part

FROM

(

SELECT * 

FROM  dbo.vw_part

WHERE dbo.vw_part.partition_number = 1

AND EXISTS  (

    SELECT      NULL

    FROM       dbo.vw_part b WITH (NOLOCK)

    WHERE b.recipient_id = dbo.vw_part.recipient_id

    AND  b.message_id = dbo.vw_part.message_id

    GROUP BY    b.recipient_id, b.message_id

   ...

You're WELCOME