Don't think so. Might nest the IF's to make it slightly cleaner, or space it out better, but I think this is as good as it gets.

Good suggestion, I'll see if there's an easy way to build it.

Steve

To me they are putting a bigger burden on me. The feedback form is a mess.

First of all, I select a product and search. That alone makes it hard. For...

Interesting comments. I don't think there's anything wrong with MS writing a new OS, charging for it, etc. But I'd like to see them and other software vendors continue to...

Dan,

Thanks for the clarification and I'll try to be more understanding, but I think in the interest of trying to make it better you've taken a step back. Might be...

Not the first time

Do you have multiple instances? Or are you running smething else that could possibly use the SQL ports? Looks like a problem getting the port assigned to SQL Server from...

Not really looking, they just like the idea. Saw a 125 for sale around the corner, drooled slightly, but drove on. My kids are 13, 7, and 4. We had...

It's both good and bad. Centralized access means an easy change to disable an account, reset a pwd, etc.

It's bad because stolen credentials mean access to anything. Not unlike...

This could be done in T-SQL, but it will be a little cumbersome. YOur use of LEFT or SUBSTRING will get the first part. As to the remaining amounts, there...

Without digging too deeply into your code, this works for one month, doesn't it? I've written similar things and we basically needed to call the proc multiple times because the...

This is a disk issue. You need to upgrade the disk system.

Might try tracing and see if EM does something else.

I do agree that the more structured feedback is helpful to MS, and it's easier for them. It's also harder for me.

They've shifted the burden of work from their staff...

The parameter in a view is in the where clause.

select * from myView where SomeCol = 'SomeVal'