dwain.c (7/24/2013)

---

ColdCoffee (7/24/2013)

---

Glad that it worked. I hope you understand the power of providing ready-to-use sample data. It makes the life of forum members a lot easier to work on...

Glad that it worked. I hope you understand the power of providing ready-to-use sample data. It makes the life of forum members a lot easier to work on the solution...

Hi Nakul,

NIce solution. But one thing. That solution works only for the input data provided by the OP. Try your query on this sample set and u'll notice the result...

Hi ,

a little help in setting up the sample could have helped a lot. Like this:

IF OBJECT_ID('tempdb..#TableA') IS NOT NULL

DROP TABLE #TableA

IF OBJECT_ID('tempdb..#Tableb') IS NOT NULL

DROP TABLE #TableB

CREATE TABLE...

That is because you are SETting the value for your variable before the SELECT statment..

SET @MyNumberReturn = '000000'

You code should be

IF @MyNumberReturn = '000000' OR @MyNumberReturn IS NULL

THEN

...

Like this?

SELECT TD.ID

,Attrib1 = CASE WHEN MIN(TD.Attr1) <> MAX(TD.Attr1) THEN NULL

...

For ID = 3, the answer should be 2 not 3, right?

Try NUMERIC(8,4).

This?

DECLARE @tab TABLE

(

Value DECIMAL (14,7)

)

INSERT INTO @tab (Value)

SELECT 0008.22816 -->> 0000008.0022816

UNION ALL SELECT...

You said grouping, but the output shows replicating the existing information? Did you really mean that or am I missing something?

Whats the error?

dji (8/3/2012)

---

I want to sum the vol (volume) grouped by price and country. BUT I want to exclude the top nn% and bottom nn% from the sum (this is to...

This is the simplest way, but i sense may not be the most efficient way. Let me see if there is another way to tackle this.

Gotcha!

Here is what you are looking for:

SELECT *

FROM #tTable1 OtrTbl

OUTER APPLY

(

...

Good job posting almost 90% of the information required..

ONe question: WHats the logic behind the expected reuslt?