I hate the idea of using positional arguments for code.  How the hell are you supposed to know what ORDER BY 3 means without trawling through the code?

The argument put...

I would avoid using CHAR fields because they ALWAYS use the amount of space allocated where as the VARCHAR only uses the space it needs.

Secondly I presume you have a...

If you have two or more SQL Statements that are dependent on each other then I would wrap them up into a transaction.

If you are just running a single statement...

What did I learn? Well first, not to tell my wife my estimate, but instead double it and then add 2 hours.

Always at least double your estimates for management

From the data you supplied you would get an empty value for Employee 2 city error because there is no city entry.

You don't need to write one, you simply use sp_depends.

SELECT empid ,

  empname,

  Address,     

    MAX(CASE(errlog.FieldName='Address' THEN errormessage ELSE '' END) AS CityError ,

  city ,   

  MAX(CASE(errlog.FieldName='City' THEN errormessage ELSE '' END) AS CityError ,

  state, 

    MAX(CASE(errlog.FieldName='State' THEN errormessage...

SELECT TOP 10 WITH TIES should do the trick

Have you a specific example?

Can you post the code for the function?

Have you specified the arguments?

You can't nest these sorts of queries either.

If proc1 contains an INSERT...exec then you can't have a procedure that inserts the results of proc1.

If it is a cheque number does it have to be recorded as a physical number?  Can it be kept as a sting?

Computers do integer arithmetic accurately.  The golden rule...

Thanks for your help,

I've had to correct 537 filenames by hand.

You can't turn it off, but you can set the transaction log to truncate on checkpoint.  This is the same as "Simple" recovery mode.

Could you just confirm that when you say my sql database you mean your sql server database and not MySQL database?

If you do mean the latter then the following command...

I thought the contest was supposed to be SQL Server specific.

If I had known it was more general I could have told a few stories that would have made your...