Yes, and don't use NOLOCK in production code unless you don't mind getting approximate, as opposed to accurate, data.

John

Pete

Something like this?

SELECT COUNT(*)

FROM MyTable t1

JOIN Mytable t2

ON t1.ProcessId = t2.ProcessId

AND t2.Month = t1.Month + 1

AND t1.Compliant <> t2.Compliant

John

Mike

I don't think there's an easy way of doing this. One option is to restore last night's backup to a different server (or a different database on the same...

1. No, you should have identical hardware for each node. I can't remember whether this is compulsory or just highly recommended. You should also check that the hardware...

Philippe

Have you tried a DDL trigger? You should be able to automatically grant permissions on an object as soon as it's created. I've never tried using a trigger...

I suppose you could create a job on the second server that removes that login's access to your database at a specified time.

John

Something like this?

WITH PatientNos AS (

SELECT ROW_NUMBER () OVER (ORDER BY NEWID()) AS PNo

, *

FROM Patients

)

UPDATE PatientNos

SET PatientName = 'Patient' + CAST (PNo as varchar(7))

John

Your CASE statement looks OK, although you haven't said exactly what you're trying to achieve with it. As I said, please provide DDL, data and expected results.

John

I think we're going to need some table DDL and sample data in order to help you with this, please.

Do you get an error message when you run that query,...

I don't think your query as it stands at the moment will work anyway. The line that begins "set @qry=" seems to end very abruptly.

Having said that, since it's...

Tim

No, they won't. As long as there are no precedence constraints between the level 3 packages, they'll all run to completion (whether that be success or failure).

John

I ran into this issue myself recently. I can't remember how I solved it, but I found some good examples by searching the web and modified those. The...

I prefer the one where you have a go at writing it yourself, and post back with what you've tried if you run into any particular problems.

John

Lakshman

Why do you want to use row locks? Is there a reason why you don't want to let SQL Server decide what locks to use, and escalate to page...

No, I think you'd need to rewrite SP1 so that it only returns one result set, then write another stored procedure to return the second result set.

John

[Edit - rewrote reply...