Check out this link

http://msdn.microsoft.com/en-us/library/aa933230(SQL.80).aspx

Does this work? I am not sure about your expected results.

SELECT * FROM #REF

WHERE (Code1 = 'SS18' OR Code2 = 'SS18' OR Code3 = 'SS18')

I think you need to change the syntax of the raiserror line.

Here it is from BOL:

RAISERROR ( { msg_id | msg_str | @local_variable }

{ ,severity ,state...

This is doing 2 table scans so I know it isn't the most efficient code. You could probably put this into a CTE and get better performance but I...

I actually just started trying to organize all my stuff. I have a local database engine running and just created a table on a new database there. SSMS...

Thats nice. I never even thought to do a mod on the rank() function.

The ntile(2) function will get you close but you still have to worry about the fire center that is in both columns. This tests for that and updates the...

I did run into one problem with the trigger scripts. Since the quotename function is used the argument is of type sysname which is nvarchar(128). If you have...

Yeah, that replacement should do it.

I am not sure this is what you are looking for but here it is: Let me know if you need this in a different format.

//EDIT Also, are you...

//EDIT -- Nevermind, apparently if you actually pay attention to the steps everything works just find. Sorry about that.

I can't figure out what I have done wrong...

Am I missing something?

Won't this work?

update tableName set columnName = newid()

I am sure this is not optimal and I have no clue what performance this would have with a large data set but here is what I did:

declare @trading table...

I can't test this yet but I should be able to soon. It appears that @myLocationRef is required to be passed. If it isn't you can use the...

You could do something like this to make it look "cleaner":

CREATE TABLE #tblResults (participant_id INT, endTime TIME)

INSERT INTO #tblResults VALUES (1,'11:25')

INSERT INTO #tblResults VALUES (3,'11:26')

INSERT INTO #tblResults VALUES (2,'11:27')

INSERT INTO...