|
|
|
f*****8 发帖数: 2977 | 4
****************************************************************************
这是我用传统方法做的, 但没法测试:
select a1.deptid, a1.emplid, a1.salary,a2.deptid, a2.emplid, a2.salary,a3.
deptid, a3.emplid, a3.salary
from ps_salary a1, ps_salary a2, ps_salary a3
where a1.salary =(select max(b1.salary) from ps_salary b1 where b1.deptid=a1
.deptid)
and a1.deptid=a2.deptid
and a2.salary =(select max(b2.salary) from ps_salary b2 where b2.deptid=
a2.deptid and b2.salary
and a3.deptid=a1.deptid
... 阅读全帖 |
|
|
w*******y 发帖数: 60932 | 6 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 | 7 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:... 阅读全帖 |
|
|
|
w*******y 发帖数: 60932 | 10 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... 阅读全帖 |
|
|
|
|
|
|
y********o 发帖数: 3178 | 16 参加活动
发信人: 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 | 17 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... 阅读全帖 |
|
|
|
|
w*******y 发帖数: 60932 | 21 JC Penney have athletic shoes as a doorbuster sale item thru 1pm tomorrow
All the items in the link are $38.99
Use Code ITSOVER for $10 off $25 ( mickey7)
Final price $28.99 with free shipping to home on all shoes
Link:
http://www2.jcpenney.com/jcp/XGN.aspx?SO=1&x5view=1&Cat=After Christmas DoorBusters&Pcat=SHOES&Ne=4294957900 4 5 8 1031 3 18 904 833&DeptID=77583&SelDim=4294957900~&CatSel=4294935189|$39.99 adult athletic&Dep=SHOES&PCatID=77583&Nao=0&N=4294935189&CatTyp=FEA&CatID=80919&PSO=1&CmCa... 阅读全帖 |
|
w*******y 发帖数: 60932 | 22 Sweaters are on sales @JCP. Try to use the $10 of $25 coupons code.
Choose Free Shipment to Store to save on Shipping Cost.
CombinationPrice of $9.99: Buy Three pair ($6+/Pair)
Price of $11.99: Buy 2 for 11.99 plus a Filler Item ($7+/Pair with a Filler
Item)
Buy 1 for $11.99 & one for $14.99
Price of $12.99: Buy 2 for $12.99 (7+/Pair )
Choice is yours!!
Filler Items to Choose
Link:
http://www2.jcpenney.com/jcp/XGN.aspx?DeptID=70735&CatID=75127&Ne=6 4 5 ... 阅读全帖 |
|
|
|
|
|
|
|
|
|
|
|
|
w*******n 发帖数: 11041 | 34 不算太早,再过几个月就不能长时间上网了。
GrpTyp=PRD&ItemID=1883d8f&deptid=70676&dep=BABY&catid=77448&pcat=BABY&cat=
Baby+FurniturE&SO=0&pcatid=70676&Ne=5+18+904+949+833&N=4294940794+42949664
77&cattyp=RLE&Nao=0&PSO=0&cmAMS_T=XGN5&cmAMS_C=MERCH&cmAMS_Z=XGN5TOPOFRESU
LTS&CmCatId=homepage|77448
GrpTyp=PRD&ItemID=19cbea5&deptid=70676&dep=BABY&catid=77448&pcat=BABY&cat=
Baby+FurniturE&SO=0&pcatid=70676&Ne=5+18+904+949+833&N=4294940794+42949664
77&cattyp=RLE&Nao=0&PSO=0&cmAMS_T=XGN5&cmAMS_C=MERCH&cmAMS_Z=XGN5TOPOFRESU
L... 阅读全帖 |
|
b*e 发帖数: 3845 | 35 Need help designing a table.
I need to design an employee-department history tracking table
1. Keep track of when an employee got hired
2. Keep track of when an employee switched departments
within the compnay
3. keep track of when an employee got terminated.
My initial design of the table schema is like this:
tblEmployeeDeptHistory
(
EmployeeId int,
DeptId int,
DateStart DateTime,
DateEnd DateTime
)
Assuming the employeeId is a foreign key of another 'employee'
table, and DeptId is |
|
s**********o 发帖数: 14359 | 36 如果是3RD NORMAL FORM,TABLE应该是这样的,数据应该是这样存放的,
JOIN一下不就完了,有什么难的
PERSON
PERSONID PNAME GENDER OTHERSTUFF
1 JOHN M PIG
2 MARY F BITCH
DEPT
DEPTID DEPTNAME HEADCOUNT OTHERSTUFF
1 HR 3 GOTOHELL
2 IT 20 USELESS
ROLE
ROLEID ROLENAME OTHRESTUFF
1 MANAGER SHOULDDIE
2 ENGINERR SITTINGDUCK
PERSON_DEPT_ROLE
PERSONID DEPTID ROLEID
1 1 1
1 2 2
1 2 1 |
|
|
w*******y 发帖数: 60932 | 38 JcPenney has lots of coats on sale @ 75% off. All of them have excellent
reviews.
Use Code R20PERKS the below code for Extra 20% off. Shipping starts from $5.
95
St. John's BayClassic Pea Coat:
http://www3.jcpenney.com/jcp/X6.aspx?GrpTyp=SIZ&ItemID=1a63a80&Ntt=pea coat&hdnOnGo=true&Ne=840 4 877 878 5 961 6 29 3 598 11 15 12 506 10 23 585 596 1031 8 18 904 903 969 949 833&submit search.y=0&SearchString=pea coat&submit search.x=0&N=4294959029&Nao=0&SO=0&PSO=0&CmCatId=searchresults
--
Outlet $39... 阅读全帖 |
|
|
|
|
|
|
w*******y 发帖数: 60932 | 44 Cold weather Boots for women are available from a low $15+. Shoes ship FREE
in contiguous states, otherwise ship to Store is FREE everywhere.
Select a shoes from the following
Check out with promo code
Apply promo code: ITSOVER
Note: You need to add a filler item for shoes $24.99.
Shipping is FREE or Ship to Store
Link:
http://www2.jcpenney.com/jcp/XGN.aspx?DeptID=77583&CatID=78823&SO=1&SelDim=18~ 18~ 6~ 4~&x5view=1&Ne=6 3 4 5 14 8 1031 1008 949 18 904 833 23&pagesize=1&shopperType=G&N=429493834... 阅读全帖 |
|
|
|
|
|
|
c**********i 发帖数: 678 | 50 有经验的大厨们给瞅瞅,这个锅子可以干啥?做汤?蒸馒头?是个好丢么?
http://www.smartbargains.com/go.sb?
pagename=prod&sp=All%2BProducts%252f%252f%252f%252f%252f%252f%252f%252f&dk
=3010560201&deptid=54&catid=141&prodid=3010560201&t=Search...prod.1 |
|