Thanks all

I still have the implementation on a trigger, but I'm looking for other way...

If I found anything, I keep you updated.

Yes, If Col2 = 0 is allow to changing Col3.

If Col2 = 1 then Col3 can't be changed, is not allowed update there value.

About DDL I mean Data Definition Language,...

The url you give was excellent for understand and give the choice of way for my solutions.

:w00t:

😎

Koen Verbeeck (3/29/2013)

---

If I'm not mistaken you want a row for every date/time combination and put the values in different columns?

This would be done with a PIVOT statement.

Using PIVOT and...

Koen

When we go in one direction, forgot completly other.

Pivot/Unpivot was so obsvious I forgot of this statment.

Thanks for call me for wake up.

For others who need to read examples in...