http://msdn.microsoft.com/en-us/library/ms189794.aspx

"bala nemate" <bala.nemate@gmail.com> wrote in message news:1xby0r5t0bunh$.5rnjp3esynpa$.dlg@40tude.net...
> hoj,
> 
> turiu lenta, kurioje fiksuojama, kada pasikeite yra irengimo busena
> (1-dirba, 0-stovi) ir laiko stampas. reikia susumuoti atidirbta laika (jei
> 1 atsistojo 12:12, o 0 - 12:20, skiasi pradirbta 8 minutes ir t.t.). galit
> gal ant kelio uzvesti, nuo ko pradeti aiskintis?
> 
> misliju, uzklausoje reikia koki cikla prasukti ir persidelioti busenas is
> eiluciu i stulpus ir tada issirankioti datos skirtuma...(be ciklo turbut
> niekaip?)
> 
> is
> 1 | 2010.03.12 12:12:12
> 0 | 2010.03.12 12:12:22
> 1 | 2010.03.12 12:34:12
> 0 | 2010.03.12 13:11:12
> i
> 
> 1 | 2010.03.12 12:12:12 | 0 | 2010.03.12 12:12:22
> 1 | 2010.03.12 12:34:12 | 0 | 2010.03.12 13:11:12
> 
> tiesa, mssql 2005
> 
> iki
> -- 
> bn/mj
> icq : 171288416
> skype : bala.nemate
> "The blues ain't about making yourself feel better.
> it's about making other people feel worse."
> -- Bleeding Gums Murphy