Re: T-Sql Division Help...

2006-06-30 Thread Jim Wright
> SELECT ((query1) + (query2) / 2) > > > > Which is working well however if the result of either query1 or query2 is > NULL the entire select statement returns as NULL. Is there anyway around > this? I would like to have SQL do the work rather than have two independent > queries and h

T-Sql Division Help...

2006-06-30 Thread Brian Polackoff
I have a query that has the format of: SELECT ((query1) + (query2) / 2) Which is working well however if the result of either query1 or query2 is NULL the entire select statement returns as NULL. Is there anyway around this? I would like to have SQL do the work rather than hav