I've been trying all morning to get a set of REPLACES to work but there are too many rules to apply.

I may have to go down the CLR route for...

Lol Chris you scare me.... And embarrass me at the same time.

Simple solution....

This is another addition to the various phonetic algorithm implementations I have. Always hoping for better match keys...

Hi Chris hope you're well!

Thanks for the thread. I shall go and have a thorough read in a mo.

I'm really grateful you brought my attention to iTVF Last year.

I've been...

Haha Sean..... I stopped at O as I didn't want to give away how other keys are created. This is not as bizarre as you think. A lot of work...

Thanks guys. Much appreciated!

Although I find Greg's solution easier to understand which makes me wonder, should I re-format my XML?!

BTW, I've no idea how Mark's solution works lol, I'm going...

Use the ISNULL function (see above)

with cteSSC (leaner, A, B, C)

as (select 'MAM', 50, NULL, 100 union all

select 'ANG', 20, 65, 105 union all

select 'DSD', 20, NULL, 20)

select *

from cteSSC

where ISNULL(A, 0)+ISNULL(B, 0)+ISNULL(C, 0) >...

Okay, can I suggest you run process monitor to see what the clean up task is actually doing?

Remove the dot. So instead of .bak just put bak

Have you specified a file extension in your Maintenance Cleanup Task?

No the most elegant solution but it works

create function dbo.fn_DateAndTime (@Date varchar(8), @Time varchar(6))

returns table as

return

select theDateAndTime = convert(datetime, @Date) +

cast(substring(RIGHT('000000' + CAST(@Time AS VARCHAR), 6), 1, 2)+...

...from BOL

CHECKSUM

Specifies that the backup operation will verify each page for checksum and torn page, if enabled and available, and generate a checksum for the entire backup. This is the...

I wonder if a snow flake schema might be better for you to model the ticket dimension but without actually seeing the schema of your source data I can only...

Haha.... I made the effort to read some of Mr Celko's previous posts sometime ago... Lol he really lets loose sometimes but you know he does make some valid points....

As if the other 167 lines returned by sp_blitz wasn't enough!

I also found this.. tut tut tut tut tut

LOL......