please take on sample of data.

Entry can be done in from lenght and to lenght like following.

900000.0000 to 1000000.0001,1000000.0005 to 1000100.0000 so there is gap of .0004.

starting from...

Thank u,

thing is i am keeping decimal (14,4) for from length and to length,

and it is not bridge it is road where paiting is going on.

will the query be...

if some one changes date format of windows OS/system formte will it affect the code of sqlserver/ c#.