What have you tried so far?

Edit: Oops, I missed the "Pl help." at the end.

I cou'dn't resist in this one as the OP did not ask a question. 😎

http://www.sqlservercentral.com/Forums/Topic853917-392-1.aspx?Update=1

Your logic make sense. I think you should continue along that line.

I haven't been paying much attention to the forums lately, but I have been checking regularly today. :w00t:

I'm ready to return to the desert!!!!

cathy.baker (1/26/2010)

---

You could be correct. But why not use the ABS() function. It would be clear and sort of self-documenting. We are going to ask the vendor...

It looks like -isnull(sum(u.linecost),0) means -1 * isnull(sum(u.linecost),0)

Can you post the rest of the statement?

Unzipping can be done in several ways in SSIS. The easiest one is to run the "command line" command for whatever unzipping program you have on that server. ...

I agree with Steve.

....... huh ......... I don't know, huh ............ :unsure:

What did you expect the query to return?

First of all, you to do not have a WHERE clause to restrict the number rows that the query will be...

You mean confuse...

Can you hear me now?

Where am I? I'm here, of course!!!

I'm formerly from Nova Scotia, Canada; been in Memphis, TN, for 10 years now.