Sorry jumpped in without reading all posts. Missed the multiple pages

Did you rebuild the query statistics when you changed servers?

Note this is a guess on my part as I am not an expert in performance tuning.:ermm:

Select Distinct EPSReferralKPIs.dbStaffLastName

From EPSReferralKPIs

UNION ALL

SELECT 'No Ref - Staff'

Here is what I did. I do not know if it is what you were looking for but I used a global temporary table.

create table ##t (Email varchar(1000))

Insert...

If I understand you....

UPDATE tbl_source

SET Col1 = CASE WHEN LEN(col3) > 10 AND col3 LIKE '111%'

THEN SUBSTRING(col3, 4, LEN(col3) ELSE dbo.fn_ConvertToNumeric(col3) END

WHERE col2 = 'abc';

using a WHERE clause...

Thank you all.

I knew that ColumnB would need its own if it required an index, I just wanted clarification on the first column in an index list. ...

Thank you. I had thought that was the case, thus the question.

You have one too many equals in your code. Also look up the use of IF UPDATE() within a trigger.

CREATE TRIGGER [dbo].[tr_a] on [dbo].[A]

AFTER UPDATE

AS

BEGIN TRY

...

We use Idera DM. It does have the historic snapshots. I like it, but then it does what we need.

I have not had experiance with the...

Are you using the SELECT * or is that just for the example? If not you might want to list the desired columns.

Not that it will help with your current problem, but we alway use four days as this will take into account one holiday plus the weekend.

Lowell, thanks for the reply. I am actually looking to delete the "bad" numbers so yes it is an IN.

Grant, now that you point it out I remember about the scan.

I am not that worried about the scan for the desired use, I was just hoping to learn a...

Thank you.

So it would be like?

WHERE PhoneNum not like '%1111111'

AND PhoneNum not like '%2222222'

AND PhoneNum not like '%3333333'

AND PhoneNum not like '%4444444'

AND PhoneNum not like '%5555555'

AND PhoneNum not like '%6666666'

AND...

I was interested in this post as I currently have a cursor that does this and have been looking for a way to replace it.

I have asked in other forums...