That helps, but better to have the partitions on different physical disks for real performance gains...

No need for a trigger... You can revoke permissions from individual users by column in a table or view.  Lookup REVOKE in Books Online for the full syntax.... but here's a...

It wasn't negative!!! It was friendly advise that you're probably commiting some form of SQL suicide by needing to do this!!!

There's only one...

Is it a bug or did the boys in Redmond just decide to change a default like they did with the CONCATENATE NULL YIELDS NULL setting?

The "system" creates them... As you found out, it only creates them when the first instance is needed whether created by the backup code or use of an IDE.  Best...

Won't have poor performance if it's for multi-row batches... on busy systems, most batch procs will probably need to recompile due to data changes in as little as 5 minutes.  GUI code is another...

I'm thinking that your table is a bit denormalized... it should be like this...

EventID Fighter
1       5
1       10
2 ...

That's a whole lot different than what you asked... but somethin similar to what I posted will still work.  Just set some variables in the process.  Have you read about...

Understood... but you have no criteria for the table... that makes a cross-join.

C'mon Zach... folks helped you out... the least you could do is post your solution

Thanks Remi!

Lookup "IF" in Books Online ("Transact-SQL HELP" in Query Analyzer) to find more about the following example (also from Books Online)...

IF (@ErrorSaveVariable <> 0)
BEGIN
   PRINT 'Errors encountered, rolling...

No, I understood that... but typically there is some unique key (column or combination of columns) other than the GUID that would identify the unique row.  Need that info to do...

Heh... if that's what he meant by decimal... Me?  Guess it's obvious that I don't normally do those kinds of conversions, huh? 

But, doing it that way, it can't be turned back into an IP address, can it?  And, theoretically, couldn't there be dupes that way?  After all, the OP did say...