From BOL:

...You must have been granted CREATE FUNCTION permissions to create, alter, or drop user-defined functions. Users other than the owner must be granted EXECUTE permission on a function...

Yes, that design will work but at the cost of always joining to the results table.  I would agree if it were common to not have results.  But in this...

How about a medical database where a row is entered for each test that is ordered for a patient.  The existance of the row gives information about when and who...

I make use of nulls where it is important to know when data is missing as oposed to blank.  In such cases using blanks can cause a query to return undesired/incorrect...

If you are using sql sever 2005 then you should consider eliminating the read with (nolock) and start using Read committed snapshot. 

Read committed snapshot will give you...

Here's an interesting article on error handling.

http://www.sommarskog.se/error-handling-II.html#presumptions

If I did this correctly, after removing all the casts and sums your statement comes out to be

1 + 0 / 40

and of couse the 0 / 40...

As long as you're explaining things maybe you also need to explain what COBOL is?

Even this old COBOL programmer agrees with you

Here's two very helpful articles on working with dates in sql server:

http://www.karaszi.com/SQLServer/info_datetime.asp

http://www.sql-server-performance.com/fk_datetime.asp

As dcpeterson stated earlier you will see the correct results if you move your "waitfor " to just after the INSERT but this has little to do with Repeatable Read.

With...

You can (should) place a constraint on the column to ensure that the time portion is always 00:00:00.000.  Then it will never be an issue.

The isolation level that will work for you in this situation is Serializable.  This can be done with the SET statement or by using With (holdlock)

select col_padre from padre

How can you determine that IF his blood type IS NULL THEN NOT DELETING him is CORRECT?

Because if you treat NULL as unknown then the correct answer is...

Delete from Suspect_List

Where blood_type <> 'O'

If Mr. Smith's blood type has not yet been determined and is set to NULL then he will correctly NOT be deleted.

If Mr. Smith's unknown...