Exsanguination

"Come on in, the blood's lovely" attributed to a British MP entering a cabinet meeting of the last government.

Paul White NZ (7/14/2010)

---

Eugene Elutin (7/14/2010)

---

Paul, have you seen my post #951618 (using UDF), bottom of page 3?

Do you think this approach is viable for most of scenarious?...

Comment out this section, it isn't referenced in the SELECT:

LEFT OUTER JOIN

( SELECT p.EntityCode,

SUM(t.[On-Sale Rate]) AS OnSale,

SUM(t.[Off-Sale Rate]) AS OffSale

FROM aztec.dbo.ProductTaxRules p, aztec.dbo.TaxRules t

WHERE (p.TaxRule1 = t.[Index No]...

/*

i need result like

------------------------------

sriram Thiru

Thiru Hari

Hari KSS

----------------

*/

DROP table #emp

create table #emp

(

eno int,

ename varchar(20),

designation varchar(20),

report_to int

)

insert into #emp values (1000,'Sriram','STE',100)

insert into #emp values (100,'Thiru','PL',10)

insert into #emp values (10,'Hari','PM',5)

insert into #emp values...

jon pill (7/14/2010)

---

SELECT min(upvolume),min(downvolume),Max(upvolume),Max(downvolume)

FROM

(SELECT upvolume,downvolume,TotalTrades from DBVaskVbid WITH (NOLOCK) where BarStamp >= '7/13/2010') as XDtable

WHERE TotalTrades

BETWEEN

(SELECT MAX(TotalTrades)FROM DBVaskVbid WITH (NOLOCK)) -1000

AND

(SELECT MAX(TotalTrades)FROM DBVaskVbid WITH...

/*

I need to return distinct OrderIDs where the following conditions are met:

• The order is just for Bananas (ie just the one row exists for an OrderID)

• The order is...

To have and to hold your cake and eat it.

DBCC GetGapsInSpec

Depends on the fillfactor of the spec - if it's less than 50%, you have...

The Mamas and the Papas

TWICE! 😀

Paul White NZ (7/13/2010)

---

It does indeed look very pretty 😎

I'm going with the upgrade...

Gosh :blush: you're welcome, thanks for the feedback!

Thanks Paul, that was interesting - if challenging - reading. I've not yet used rCTEs to resolve hierarchies in anger. This would be a good place to start, given a...

Have you tried a left join?

FROM BatchStock b

LEFT JOIN #Tmp t ON t.slno = b.slno AND t.itemid = b.itemid

WHERE b.PurId = @PurID AND b.DocRef = @DocRef

AND t.slno IS...

Paul White NZ (7/13/2010)

---

He did.

I took Chris' post as...