How about reversing the string and getting everything up to the first "-" and then reverse the result ?

Maybe something like :

declare @s-2 varchar (100) = '000006-00005-254-008'

SELECT REVERSE (SUBSTRING...

I use Enterprise Architect (by Sparx Systems) to do this - it will connect to your database and allow you to load (into Enterprise Architect) the definitions of tables, views,...

Both transactional and merge replication support updates that are sent to all other databases involved with the publication.

For you, I think that transactional replication (with immediate updating subscribers)...

The last right bracket is in the wrong place (and it and one other left bracket appear to be redundant)

I think either of the following will work:

=IIf(CountDistinct(Fields!PatientID.Value, "EncounterPatient")<(CountDistinct(Fields!PatientID.Value, "PAST")), "Red","Black")

or

=IIf(CountDistinct(Fields!PatientID.Value,...

Have you looked at the Fuzzy Lookup transformation in SSIS - it does the sort of thing you are after without needing to pre-determine all of the possible combinations of...

The lag clause looks like a nice way to achieve this - I didn't know that it existed until just now.

Dwain - Thanks for teaching me something new 🙂

No probs, glad to help out (and to have you avoid a pretty serious problem)

The answer to both of your question is NO. Replication is quite happy operating in an environment where the servers are rebooted without stopping replication. Replication will simply...

I first thought on this is that you are about to create a serious bottleneck in your system - at best you will experience a little bit of blocking. ...

I have been using Enterprise Architect for a while - it can import the definition for tables, views, functions etc from database that you can connect to using ODBC. ...

I think you have done the correct first 2 steps...restore SSRS databases and the encryption key.

I think that you will need to check the datasource for the report - does...

You can copy and paste within Visual Studio.

Why do you need to do this ? Is it just in case you make a mistake ? Do you a...

Firstly - "Drill through reports" is a concept. SSRS allows you to implement this, if you need.

As for your requirement - sub report is my thinking. A sub...

Something like the following should do the trick

UPDATE t

SET t.Status = 1

FROM MyTable t

INNER JOIN MyTable t1

ON T1 .ID = (SELECT (MIN(t3.ID) FROM MyTable T3

WHERE T3.ID > t.ID)

WHERE t.Extime <...

In your example, process 54 is the connection that you are using to execute the sp_who2 command. It is not doing anything unless you are actually running a command....