• Awesome Qtod,thank you for posting.

    (I am bursting with my doubts... but no idea where to begin...)

    so to say... there will be no row/s in the datetime column where it ends with other than these .000, .003 or .007. Like .004 turns to .003 or .129 turns in to .127.... ? .002 changes to .003?

    My main doubt is... in the BOL it says under property as "accuracy" and then the corresponding value starts with " rounded to increment..." ? what type of accuracy is this? :crazy:

    edit; fixed the "property" spell

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.