|
|
w*******y
发帖数: 60932 | 3 Coupon code takes $2 off an order of $2.01 or more, and shipping is free to
a Payless store. If you want more than one of something, you would need to
place separate orders to get the most use out of the code. Not sure if it is
a one time per customer use, but often another browser or clearing cache
helps in those situations.
Code 27662
Girls' (1 pk) Floral Tights $1:
http://www.payless.com/store/product/detail.jsp?productId=70161
Girls' (1 pk) Heart Tights $1:
http://www.payless.com/store/produ... 阅读全帖 |
|
w*******y
发帖数: 60932 | 4 My wife has been looking for these shoes for a while and most sites have
them for around $90. The cheapest she has ever found them at outlets shops
was over $65, so this looks to be an amazing deal. I have never bought from
this company before so I can't speak of their reputation, but they appear
to be legit.
There are also a couple other styles on the site for good prices (Some
Merrell's, some other brands)
Encore Eclipse Bug Brown
- $39.85
Merrell Piccolo Leapfrog Sandal:
http://www.comfo... 阅读全帖 |
|
|
|
|
|
|
w*******y
发帖数: 60932 | 10 For Men: apply promo code W411CASH
For Women: apply promo code 4DM8SAVE
Shipping is FREE on shoes for most states, Ship to Store is FREE every where
Avail the Buy More! option along with the $25 off $10 discount. A few
combinations are as below. Might have to use a Filler Item with these
options
Link:
http://www4.jcpenney.com/jcp/XGN.aspx?DeptID=70735&CatID=75127& 4 5 1031 3&shopperType=G&N=4294943187&SO=1&Nao=0&PSO=0&x5view=1&refdPrd=1&CmCatId=70735|75127
Women:
Bras: Buy 3: $5+/Bra
AmbriellePa... 阅读全帖 |
|
w*******y
发帖数: 60932 | 11 JcPenney Clearance:
http://www3.jcpenney.com/jcp/XGN.aspx?DeptID=81205&CatID=81206& 961 4 5 29 3 15 12 14 11 877 1014 586 1008 6 8 23 18 904 579 964&CatTyp=SRL&Dep=DOORBUSTERS&N=4294934527&Pcat=DOORBUSTERS&Cat=view all&PSO=0&CmCatId=external|81206&pagesize=1
Definition $29, View II $29, Women's New balance 600's $29, 470's $29, 407's
$29 and more. Free shipping.
Use Promo Code to Deduct $10 Off $25 purchase ITSGRANDMen's New Balance (
Prices after Code)New Balance 600 Men's Training Shoe:
http:... 阅读全帖 |
|
i****a
发帖数: 36252 | 12 SQL 2008
TableA
ID, CatID, TranID
1, 1, 100
2, 1, 101
3, 2, 102
4, 2, 103
TableB
CatID, Description
1, blah
2, blahblah
3, blahblahblah
TableC
TranID, Cost
100, 10
101, 15
102, 5
103, 3
select B.CatID, SUM(C.Cost)
from TableA A
inner join TableB B
on A.CatID = B.CatID
inner join TableC C
on A.TranID = C.TranID
group by B.CatID
this does not show CatID 3 because there are no transactions with it.
What if user wants to see CatID 3 in the result displayed as $0? |
|
|
|
|
|
i****w
发帖数: 329 | 17 isnull function 我这里用不了, 所以做了点改动.
proc sql;
SELECT B.CatID
, case when SUM(c.cost) ne . then sum(c.cost) else 0 end as cost
FROM TableB B
LEFT OUTER JOIN TableA(where=(id<100)) A
ON A.CatID = B.CatID
LEFT OUTER JOIN TableC C
ON A.TranID = C.TranID
GROUP BY B.CatID;
quit;
CatID cost
1 25
... 阅读全帖 |
|
|
|
w*******y
发帖数: 60932 | 20 For Men: apply promo code W411CASH total must be over $25 before the coupon
can be applied
Shipping is FREE on shoes for most states, Ship to Store is FREE every where
Pants from $17+
Link:
http://www5.jcpenney.com/jcp/XGN.aspx?DeptID=70673&CatID=73653& 4294957900~ 4294957900~ 4294957900~ 4294957900~ 8~&CatSel=4294940222|casual pants&Ne=4294957900 5 8 587 29 3 15 12 506 10 17 1031 18&pagesize=1&x5view=1&shopperType=G&N=21 4294940222 140 240&Nao=0&PSO=1&CmCatId=70673|73653
Shorts from $14+ with F... 阅读全帖 |
|
|
|
|
s**********0
发帖数: 266 | 24 select B.CatID, SUM(isnull(C.Cost,0))
from TableB B
left outer join TableA A
on A.CatID = B.CatID
left outer join TableC C
on A.TranID = C.TranID
group by B.CatID |
|
i****a
发帖数: 36252 | 25 hum... doesn't work after adding where clause
SELECT B.CatID
, SUM(ISNULL(C.Cost, 0))
FROM TableB B
LEFT OUTER JOIN TableA A
ON A.CatID = B.CatID
LEFT OUTER JOIN TableC C
ON A.TranID = C.TranID
WHERE A.ID < 100
GROUP BY B.CatID |
|
i****a
发帖数: 36252 | 26 works if I put the condition into the join
SELECT B.CatID
, SUM(ISNULL(C.Cost, 0))
FROM TableB B
LEFT OUTER JOIN TableA A
ON A.CatID = B.CatID
AND A.ID < 100
LEFT OUTER JOIN TableC C
ON A.TranID = C.TranID
GROUP BY B.CatID
haa, interesting... |
|
a9
发帖数: 21638 | 27 这样试试看？
SELECT B.CatID
, SUM(ISNULL(C.Cost, 0))
FROM TableB B
LEFT OUTER JOIN (select * from tablea where a.id<100) A
ON A.CatID = B.CatID
LEFT OUTER JOIN TableC C
ON A.TranID = C.TranID
GROUP BY B.CatID |
|
i*****w
发帖数: 75 | 28 Try this:
SELECT B.CatID
, SUM(ISNULL(C.Cost, 0))
FROM @TableB B
LEFT OUTER JOIN @TableA A
ON A.CatID = B.CatID
LEFT OUTER JOIN @TableC C
ON A.TranID = C.TranID
WHERE ISNULL(A.ID,0) < 100
--WHERE A.ID < 100
GROUP BY B.CatID |
|
i****a
发帖数: 36252 | 29 thanks for the suggestions. those all worked with the example I provided.
But on my real code with multiple group by columns and where conditions, I
just can't make it to work.
I think I find the issue is, if the query does not return, say CatID 3 at
all, then the left outer join and group by would return CatID 3 as 0
But if one of the tranID has CatID 3, then none of the other tranID will
output CatID 3 as 0
I guess I'll have to handle the missing rows when i do pivot. |
|
O**K
发帖数: 11 | 30 SELECT B.CatID
, SUM(ISNULL(C.Cost, 0))
FROM TableB B
LEFT OUTER JOIN TableA A
ON A.CatID = B.CatID
AND A.ID < 100
LEFT OUTER JOIN TableC C
ON ISNULL(A.TranID, 0) = C.TranID /* assume TranID > 0*/
GROUP BY B.CatID |
|
N*******m
发帖数: 517 | 31 Sorry, 我瞎说了。
既然A和C的TransID是一对一的话，先把A跟C搞成一个大表S，然后B再left join这个大
表S不行吗？
SELECT DISTINCT B.CatID, SUM(ISNULL(S.Cost, 0))
FROM TableB as B
LEFT JOIN
(select A.ID, A.CatID, A.TranID, C.Cost
from TableA as A
inner join TableC as C
om A.TranID = C.TranID
) as S
ON B.CatID = S.CatID |
|
|
|
|
|
|
|
h****9
发帖数: 381 | 38 ＊＊＊ SALE或COUPON专贴，请JMs将有关信息贴这个专贴里，以方便大家查找 ＊＊＊
＊＊＊ 请JMs存下这个贴子的链接，我会尽量每周都来更新，如果大家看不到这个贴子，我更新就没有意义了。 ＊＊＊
只是想跟JMs说明一下，为了方便大家查找，我答应版版MM帮助收集和整理我所
知道的以及JMs提供的COUPON/DEAL信息，我会尽量及时更新coupon专贴的主贴，
也欢迎更多JM将coupon贴在这个贴子里，在此一并感谢所有提供COUPON/DEAL
信息与大家分享的JMs，并感谢在COUPON专贴出问题时给予我很大支持与帮助的steedzhu、BelugaWhale及brightsmoo几位版版MM。
除了某些 BRU/TRU COUPON可能是扫描件以外，其它基本上都是printable coupons，请需要的JM用链接打印啊。JMs可以在文摘区找到更多coupon信息
包括交换等信息(请从首页找起)。
★ 有JM问起，觉得这个贴子太长了，慢的原因可能是图片太多，我将图片显示出来是想方便JMs很快找到自己想要的DEALS(我可以将图片略去，如果更好的话)。简介一下主贴的内容啊... 阅读全帖 |
|
y********o
发帖数: 3178 | 39 参加活动
发信人: yidigoumao (一地狗毛), 信区: NextGeneration
标 题: jcpenney 玩具在打折
发信站: BBS 未名空间站 (Thu Dec 2 11:59:39 2010, 美东)
additional 20% savings with code 4RELVES，选着 in-store pick up 可以省运费
remote control helicopter: $15.99
http://www.jcpenney.com/jcp/X6.aspx?
DeptID=71233&CatID=71233&Grptyp=PRD&ItemId=19ef8f4&cm_mmc=ShoppingFeed-_-
PriceGrabber-_-
Men-_-
Men+s+JCPenney+Execuheli+Remote+Control+Helicopter++Black+Blue+Green+Purple+
Red&srccode=cii_57
84816&cpncode=20-67789485-2
tote&go laptop plus: $9.59... 阅读全帖 |
|
|
y********o
发帖数: 3178 | 41 additional 20% savings with code 4RELVES，选着 in-store pick up 可以省运费
remote control helicopter: $15.99
http://www.jcpenney.com/jcp/X6.aspx?
DeptID=71233&CatID=71233&Grptyp=PRD&ItemId=19ef8f4&cm_mmc=ShoppingFeed-_-
PriceGrabber-_-
Men-_-
Men+s+JCPenney+Execuheli+Remote+Control+Helicopter++Black+Blue+Green+Purple+
Red&srccode=cii_57
84816&cpncode=20-67789485-2
tote&go laptop plus: $9.59
http://www.jcpenney.com/jcp/X6.aspx?
DeptID=77801&CatID=77801&Grptyp=PRD&ItemId=16e8ae1&cm_mmc=ShoppingFeed-_-
Sho... 阅读全帖 |
|
|
|
|
|
|
|
|
|
|
