I am fortunate in that I develop intranet applications and can use Windows Authentication.

This means that a Windows group is granted login priviledges to SQL Server and that group login...

If the values are arranged in a numerical order then TRIMMEAN ignores a specific number of values at either end of the list and then returns the AVERAGE of the...

It depends on what language I am working with and whether I can use ADO/ADO.NET.

If I am passing a web input or textarea box then providing I am assigning the...

My first reaction to MySQL was that traditional databases cost money for a reason.

The more that I have used MySQL the more I find I like it although FK support,...

Short of spending a lot of time documenting use cases for your stats or training up you network admin I can't see any easy solution here.

I think it is a...

There used to be an independent SQL Server exam prep books that were quite detailed.

Having worked with an ORACLE developer he gained a grudging respect of SQL Server, mainly due...

If you want to store time accurate to the minute then use SMALLDATETIME otherwise use DATETIME.

If the various locations are in the same country as the server  then use the...

SELECT DC.CollectionName ,

 MAX(CASE CA.AttributeType WHEN 1 THEN AttributeValue ELSE '' END) AS Attribute1Name ,

 MAX(CASE CA.AttributeType WHEN 2 THEN AttributeValue ELSE '' END) AS Attribute2Name

FROM dbo.CataCollections as DC INNER JOIN dbo.CollectionAttributes AS...

A SmallDateTime field is accurate to the minute so setting it to GETDATE() will automatically truncate it for you.

Well its Christmas so surely its as good a time as any to contemplate the "Meaning of life"?

I've got the "Monty Python Sings" CD in my lap-top for when the...

Anything that comes through the post that isn't a bill or junk mail is something to get excited about.

Wasn't there a Monty Python sketch on this very subject refering to John Cleese as the comic mesiah?

For the younger programmers, Monty Python was a comedy team before the invention...

I have never seen a performance difference but from my point of view the separation of join conditions and selection conditions aids clarity to the code.

Basically all your tables relate on the accountId field.

So tblBorrowerAddress.AccountID = tblAccount.AccountID and tblAccount.AccountID = tblBorrower.AccountID

A human being will infer that tblBorrowerAddress can be linked to tblBorrower but a computer...

Put SET DATEFORMAT YMD at the beginning of your procedure