As a note there are a couple problems in your sample query:

* The aliases don't match "fr" vs. "uf"

* You have the logic backwards from what you title says "LEFT...

No you can't break a single statement up with IFs.

You can do something like this, but I'm not sure it is optimal:

DECLARE @Flagged bit

SELECT

a.[ColumnA]

, a.[ColumnB]

FROM...

Depending on your needs you might be better off going with a VARBINARY(MAX) field stored via FILESTREAM on a drive with 4 KB clusters so that you can turn the...

First Unicode compression was added in SQL Server 2008 R2, so if you don't have R2 then you can't compress any NCHAR or NVARCHAR columns. Second, NVARCHAR(MAX) is never compressed...

Jeff Moden (3/24/2011)

---

I think that whoever wrote the BOL article simply forgot about 0 and that it actually is the first "position" to the left of the string. I...

Can the third party backup tool be configured to make the backup in "copy only" mode? (That should prevent the LSN from being changed and breaking the backup chain.)

That is an interesting use of the start position, but it looks to me like either the documentation in BOL is wrong, or the behavior is a bug. BOL says:...

If you do have to do this in SQL Server you won't be able to do it in a view, as you can't dynamically change the columns a view returns....

I'm surprised nobody has mentioned the most important thing. You need to identify the cause of the corruption. It not only corrupted your database, but your backup as well, and...

Thanks for the question!

Slipstreaming can not only prevent setup/upgrade problems...

Can you post your guide as an attachment so that we can all look at/use it?

For starters it helps if you provide DDL. For better, quicker answers on T-SQL questions, click on the following: http://www.sqlservercentral.com/articles/Best+Practices/61537/

But I think this should work for you: (There are multiple...

I assume because the staging tables can change over time, and they don't want to have to update and maintain the reset procedure. (Or they want to use the same...

Your welcome and thanks for letting us know it work for you.