Storing a integer in a varchar is not a smart approach for sure.

But im most concerned with the nolock and the (in)correct order.

I know the diference between lexiografy and numeric...

I found #temp tables a nice tool for split very complex queryes and avoid cursors. The unique incovenient is to be sure to drop de #temp (even at a transaction error).

SQL...

A disagree only ate the trigger cannot be nested afirmation, from BOL:

Nested Triggers

Triggers can be nested to a maximum of 32 levels. If a trigger changes a table on which...

For most users 'A' = 'a'. Using case sensitive data can be a source of bugs from the users viewpoint.

For large systens the maintenace of case sensitive source code is a...

4 tips:

1) Note datetime is a float and a hour is a diference by 4.1666666671517305E-2 u can use these values to make the quick calculations from -4.5 hour or +1...

Hello guys thanks for the reply!

Pete,

this chunk of code works fine

...

INSERT INTO Father (Father_id, Father_name) values(-255,'No father')

...

on isnull(s.father_id, -255)=f.father_id

...

but

...

INSERT INTO Father (Father_id, Father_name) values(null,'No father')

...

on s.father_id = f.father_id

...

don´t work...