OOps...I can't cut and paste very well it seems! Here is the full query.

I only have 2 options...james1 & james2...I'd still have to use case?

To be honest, I don't even know...

Hi guys...

no cursors....

how do you run a query with trace flags on, especially from an ASP script?  Or do I have to use sql server query analyzer?

Thank you

Thanks guys...

does it need to be a LEFT OUTER JOIN?  Or can I use INNER, LEFT, RIGHT, etc...

thank you!

wow, I'm a rookie now.

Paul,  each item has a force(OOForcedAmount) and each force is in a group.  I wanted to display the individual force amounts, as well as the sum of...

OOPS, I meant to type Sushila!  Sorry!

Sushia,

AND IURaysAmount > '00:00:00' 

the time it takes for a certain amount of  infrared and ultraviolent rays to reach a lense...

don't ask me what that means, I'm just...

Paul,

I understand your join example would work, but I meant something like this:

FROM A

INNER JOIN B on A.id=B.id

INNER JOIN C on D.id=C.id

INNER JOIN E on F.id=E.id

etc...

thank you

sushila,

Thank you for your reply.  My problem with the joins, is that I think I have too many tables to be able to use a join.

September 23, 2005 at 9:16 am