Why would anyone do that?!  I think it's going to be messy.  You can use the sys.sql_modules catalog view to find all objects that have the word "customer" in their...

SELECT
    PartNo
,    MAX(Status) AS MaxStatus
,    MIN(Status) AS MinStatus
FROM Parts
GROUP BY PartNo
HAVING MaxStatus = 'Open'
AND MinStatus = 'Open'';

John

Yes, you can do that, but you have to use "LIKE" instead of "=".  What are your expected results?

John

Here's a rewrite of your query.  You should be able to see how to easily extend it to include the other values.

SELECT DISTINCT
     caseid

It could be the Greek character thing.  Try this:

EXEC master.sys.xp_dirtree N'\\MNG01\Scans\05083-???????S?\ALL\',1,1; 

John

Yes.  Usually applying a CU or service pack causes at least one restart of the SQL Server services.

John

This should work, provided you make the new int columns not nullable.  I recommend you do this at a time when there's no activity on the tables in question.

Sounds like your backup file isn't a valid backup file.  Are there any backups you can restore from?  Do you verify your backups when you make them, or use the CHECKSUM...

Cat

What statement are you using to attempt your restore?  What do you get if you run this:

RESTORE HEADERONLY FROM DISK = 'Z:\Backups\VSSQL2\Backupfile.bak'

John

Presumably Name1 and Name2 aren't unique in their respective tables?  What happens if you pass in a value of Name1 or Name2 that returns more than one value of ID? ...

What do you get if you run this?

SELECT
    entity_name
,   subentity_name
,   permission_name
FROM fn_my_permissions ( TableName , 'OBJECT' )

John

You only need one CASE expression:
CASE
    WHEN FEB_CREDITS <> 0 THEN FEB_CREDITS
    WHEN JAN_CREDITS <> 0 THEN JAN_CREDITS
    WHEN DEC_CREDITS <> 0 THEN DEC_CREDITS
    WHEN NOV_CREDITS <>...

We need the actual execution plan, please - you've posted the estimated plan.  How many rows are in your temp tables?

John