Is the 'where' clause generally going to be an equality join on a particular column? If so you could have a table into which you write the search value for...

If you want a trouble-free way of dropping tables....

This sp drops all column constraints and defaults on a field, then drops the field.

The code is a bit messy (exec during...

can we see the code?

jpipes - I understand the issue - I just disagreed about what was being asked for.

If you restrict the SQL username to 'dbo' that will exclude any other users - where the username is actually populated. But if SQl user is null it gets included...

harrumph...mutter mutter

I don't think so mate - you jumped to a conclusion based on Drewid's FAILED attempt to join the queries together. I think D's utterly pellucid clarification in response should...

You need to use a CASE statment instead of WHERE clause to restrict the values going into the aggregate. The code below assumes that you can't have negative values in...

You need to use a CASE statment instead of WHERE clause to restrict the values going into the aggregate. The code below assumes that you can't have negative values in...

You need to use a CASE statment instead of WHERE clause to restrict the values going into the aggregate. The code below assumes that you can't have negative values in...

The covering index (all fields required are in the index) will be helping performance compared to a table scan, especially if the table is wide. This is because the query...