Try replacing "dbo.STOCKWH.QTY" with "SUM(dbo.STOCKWH.QTY) as SumQty" in the Select clause. See if that gives you what you need. Oh, and remove that column from the Group By...

I just Googled "worse questions". Five pages in, still no sign of this thread. I think we're safe... for now.

I have to admit, my code is usually about as portable as the Rocky Mountains. In other words, you could move it to another database engine in geologic time...

It sounds like you could do that in an inline query.

Basically, write the query for the sum, put that in parentheses, and put it in the Select list just as...

Ninja's_RGR'us (1/28/2009)

---

I don't think is he yanking our chains, he obviously needs help. Worst comes to worst, the posted solutions will help someone who googles an answer later on.

Is...

I watched about 15...

What the OP is writing in Spanish is being translated through yahoo.babelfish.com, and is being mangled horribly. I just tested some of his Spanish on there, and got exactly...

One problem here is language. The posts are being translated into English by Bable Fish (babelfish.yahoo.com). I just tested some of the Spanish, and the English being posted...

clperez271172 (1/28/2009)

---

estas completamente seguro de que dicha informacion es inexistente , por que en verdad me han dicho que esta si es posible sacarla, por favor ayudame a resolever esta...

I said the same thing in Spanish that I said in English in the line above. The data doesn't exist.

I just noticed what forum this appears to be in, and I'm curious about why it's posted here?

Execute doesn't work that way.

What you'd need to do would be more like this:

declare @sql varchar(1000)

If object_id(@lv_tablename, 'U') IS NOT NULL

Begin

select @sql = 'Drop table ' +...

Yeah, I gave up on that thread days ago.

I think it's a language-barrier thing. Not sure I got it this time through, but it might help.

Sure. Easy enough. But this sounds like homework or an interview question. Please let us know what you've done to find this out so far.

For example, what...

I think I know the one you're talking about, Lynn. I gave up on it long ago, and pretty much just posted the bluntest answer I know.