all fixed now. Thanks. :) Luc Pattyn [My Articles] Nil Volentibus Arduum

With this approach you could use any over(18) and duration(30) values. select time, value from ( select *, (select count(time) from @temp t2 where t2.time > t1.time and t2.time <= dateadd(mi, 30, t1.time)) as reccount, (select count(time) from @temp t2 where t2.value >= 18 and t2.time > t1.time and t2.time <= dateadd(mi, 30, t1.time)) as okcount from @temp t1 where value > 18 ) t where t.reccount = t.okcount

Thanks a lot! I *just* posted the articile :laugh: codeproject is really great:rose: Regards, unruledboy_at_gmail_dot_com http://www.xnlab.com

hi, if I only do j*width and j*height, won't it only be tiling from top left to bottom right(diagonally)? and, it seems that the blurry problem only goes with some bmp files, strange :doh: by the way, I actually want to title all the pictures(not only one) in one picture, something like mosaic, so, texture brush maybe not suitable. Regards, unruledboy_at_gmail_dot_com http://www.xnlab.com

You're welcome

This is currently on our TODO list. cheers, Chris Maunder CodeProject.com : C++ MVP

You might want to post this on the Suggestions[^] board. Deja View - the feeling that you've seen this post before. My blog | My articles

Unfortunately I haven't had a chance. cheers, Chris Maunder

I guess he must now change his name... RuledBoy! :laugh: [edit]Took me a while too.[/edit] Paul Lyons, CCPL Certified Code Project Lurker

IIS+ASP is more then capable of running a site like this and more. ASP.Net is even more capable. I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon