Adam, I'm trying to make it a little less complicated, is there a way to take the first update from tbl2 and then join tbl2 to itself to update the...

Thanks Adam, I appreciate your time. I know what I'm asking for is convoluted. It's the format my boss wants the report, but I'm having trouble doing what...

Hi Adam, thanks for the reply. Yes I can join them but then I'll get a line record for every update, so if there are four updates on a...

Matt,

your solution worked best thanks everyone for responding.

Hi Adam and Steve, I've gone another rout and posted a new question under the title: display contents of while loop.

Ok fair enough Steve, let's say I have a table with a date column and I want perform a calculation like a count for each record that appears for each...

no worries Grant, I got what I wanted and learned something new so I'm happy.

Markc that worked perfectly, I just started using cte's recently and they are great! I'll have to look at your script in more detail to get a real understanding...

MVJ - In you example you supply 3 values DT = getdate(), DT = '20071001 14:23:45:667' , DT = '20071130 23:59:59:997'

and the average time resulting in the same three values...

Thanks everyone for your replies,

Matt your reply was the one I went with that ended up working great.

ALZBA I wasn't sure how to apply your solution, because I'm comparing one...

No I was able to figure out that the problem was stemming from my misused or's but thank you for your help.

It's used when there isn't enough wiring to assign a phone number and is being held (h) while underground wiring is is being installed.

Thank you Steve Jones, Prasad, and Matt. I finally get what you were trying to tell me but I didn't really get it until Prasad spelled the code...

lol...tell me what you really think. the 'or's' apply to the conditions within the bracketed statement, not to the whole where clause. except for the npa <> '705...

Ok got it,

=countrows("No_Assignment")

thank you.