You could just query on WHERE score > '80%'

"greater than" will be calculated alphabetically here. Presuming your data is as one would expect, ie values between 0% and 100%

Not sure...

Assuming valuehome is a numeric type, then wrapping 0.00 in quotes would be trying to put...

(bold font added by me)

Is this in SQL Server? Or Excel?

Thanks again Paul.

There's a lot more reading that I need to do...

Another question, if I may - the logs of those databases have been successfully backing up since the failed one.

If they are still corrupt, how come all the rest of...

Thanks Paul

I'll run the FULL>SIMPLE>FULL switch and hopefully set the ball rolling on the rest of it

Thanks Gail, much appreciated

These are native backups. DPM is also used, although for some reason that is not part of the DBA team's responsibilities so I don't know much about them

SQL Server 2008 and SQL Server 2008 R2 are different versions of SQL Server in the "proper" sense, despite the similar names. Therefore SP1 for SQL Server 2008 (non-R2)...

Do you find that preoccupation with things techy stops the creative streak at all? When I'm having...

Ah, they're the best kind of issues 🙂

Do you get an error if you set it up as a CmdExec jobstep that executes

powershell c:\myfilepath\script.ps1

Well, obviouslyyou won't get an error while creating the job step in...

... and we have lift-off!

Many thanks again

Thank you both.

I will set up UNC paths and see how that goes.

Having used both, C# wins hands down for me. Much cleaner syntax!