Raj - again not sure I understand why you want to keep the winnings separate - at any rate, you can get the total winnings per user by grouping...like so...

SELECT...

Jeff - you need to "SET" just once...like so:

CREATE PROCEDURE UPDATESHOW

@ShowID varchar (50),

@HeadlinerID varchar (50),

@support varchar (50),

@VenueID ...

I gather that you must've had a really rough day Brian but..."just" a DBA - I wonder how many hackles you raised with that remark - really glad I'm neither...

Noel - for my part I'm content with knowing that I know almost nothing about anything - but what I DO know is a single source that can provide ALL...

noel - since I'm buying and I don't want to be considered cheap, make it more than just " a cold one on us"....as for the check - maybe...

thx. threw it into the vault and turned the key! will try out when I'm looking for a fun-time break!

hmmm - tucher - never heard of that...! will watch out for it next time I go to "stock up"!

So many beers, so little time. - you have no choice...

Igor - if you get it working could you pl. post the script for at least one of the procedures (triggers, tables...anything...) - I'll store it in my unorthodox folder...

If Heineken's your brew get yourself a case - it's on me! Happy SA Day!

ps: oh, forgot to tell you ..."the check is...

...Or do I?....

No, you don't!

But if you must be unorthodox my 2 cents would be "the proof of the pudding is in the...

'kay...I sent the great man this link...so hopefully you'll get your answer soon...

Hey noel - here's someone who's in need of your vast expansive knowledge...

transaction isolation levels

Sara..quoting from BOL again - "remains in effect until the session terminates, or until the isolation level is set to another level..." - haven't implemented this or tested anytime so...

Igor - what exactly are you trying to do ?!

Your trigger is set on the table "Anamoly Descriptions_boolean" - and will be fired whenever there is an insert/update on this...

Sara - here's something from BOL...you change the isolation level and confirm with dbcc useroption....

USE pubs

GO

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

GO

DBCC USEROPTIONS

GO