Well, not knowing SQL and not have english as my first language hinders me sometimes, so...

The MAX(rowCreatedDT) is only scanning the table once!

What is an Audit Trail?

The stored procedure that...

So the Max(rowCreatedDT) will execute 3 times!

So I thought.

And Yes, there is more problems in this and other stored procedures.

Need to learn about indexes, stored procedures and ... really fast!

Thank...

Thank you very much!

// Anders

Thanks for the answers (or maybe the confirmations). I guessed that it would be a good thing!

// Anders

OK, I will do that.

What are the advantages for using INT as PK (which I assume stands for Primary Key) vs CHAR?

// Anders

The ids have characters in them...

Maybe I should create a new column that holds the value and change patent_id and classification_id to INT and make them an Identity (I'm using...

OK, then a smallint should be enough.

How do you identify a song uniquely? (and I don't mean by the...

Hello GilaMonster,

Thanks for your reply!

I will get the book by Louis Davidson, it will take some weeks to get it ...

I changed nvarchar to varchar. Don't really need unicode. I'm...