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

I'm not sure that switching to 'Simple' mode would have the desired effect.

All activity is logged, all simple mode does is truncate the log by removing checkpointed transactions.  I would...

Think of it as a parent/child relationship if that isn't too Freudian.

An employer is a parent the child is the employee.

The customer is the child of contact 4.

Your tbl_relationship table...

A Haynes manual is a maintenance guide for a car based on a complete strip down of a vehicle.

In theory you could buy a Haynes manual and completely rebuild your...

I would put the SELECT and FROM part of the query in a view so that your SQL string is as small as possible.

sp_ExecuteSQL does at least grant the possibility...

You could convert the date to a number first

SELECT * from dbo.MyTable ORDER BY SIGN(@sortOrder)*CAST(MyDate AS REAL)

I'm not sure about strings.  I have a feeling that your options are to...

Cool, hip, stylish and VERY dangerous.

I have a friend who restored one of the original FIAT 500s and those have the fuel tank under the dash!  Free cremation with every...

Sorry Frank, is it also the former Trabant or are they still made?