g******a
发帖数: 4774 | 1 【 以下文字转载自 Living 讨论区 】
发信人: gogotora (寅), 信区: Living
标 题: Comcast existing cust.FREE Showtime for 12months, $10/mo HBO for 6 months
发信站: BBS 未名空间站 (Wed Jan 20 13:27:09 2010, 美东)
Just do an online chat and will get the 12 months of Showtime for free. |
|
a********l
发帖数: 193 | 2 预计今天到达的
在家等一天没收到
晚上状态写成：
02/16/2010 20:21:00 DELIVERED[D] US MET CUST MAN
这是啥意思
没遇到他啊，汗！！！ |
|
w*******y
发帖数: 60932 | 3 They are marked down to $280 again. Not sure why but can only get there
through this link->
Link:
http://www.cowboom.com/product/706034
I put 1 in my cart and can checkout. New cust save an extra $10 with
Cowboom10
|
|
t*****w
发帖数: 254 | 4 create table #cust(cust int, date datetime, prod char(1))
insert into #cust(cust , date , prod )
values( '1' , '1/1/2015' , 'A'), ('1' , '1/2/2015' , 'B'),
('1' , '1/3/2015' , 'B'),('2' , '1/3/2015' , 'C'),('2' , '1/4/
2015' , 'D')
drop table #cust2
select distinct cust, prod ,
A=case when prod ='A' then 1 else 0 end ,
B=case when prod ='B' then 1 else 0 end ,
C=case when prod ='C' then 1 else 0 end ,
D=case when prod ='D' then 1 else 0 end
into #cust2 fro... 阅读全帖 |
|
t*****w
发帖数: 254 | 5 create table #cust(cust int, date datetime, prod char(1))
insert into #cust(cust , date , prod )
values( '1' , '1/1/2015' , 'A'), ('1' , '1/2/2015' , 'B'),
('1' , '1/3/2015' , 'B'),('2' , '1/3/2015' , 'C'),('2' , '1/4/
2015' , 'D')
drop table #cust2
select distinct cust, prod ,
A=case when prod ='A' then 1 else 0 end ,
B=case when prod ='B' then 1 else 0 end ,
C=case when prod ='C' then 1 else 0 end ,
D=case when prod ='D' then 1 else 0 end
into #cust2 fro... 阅读全帖 |
|
g**********y
发帖数: 423 | 6 如果有一万个的话，可以这么写：
SELECT CONCAT(
'CREATE TABLE CUST3 AS',
'(SELECT CUST,',
GROUP_CONCAT(REPLACE(' IF(PROD="PROD_NAME",1,0) AS PROD_NAME', 'PROD_NAME',
T.PROD) SEPARATOR ','),
' FROM CUST);'
)
INTO @CREATE_SQL FROM (SELECT DISTINCT PROD FROM CUST) AS T;
PREPARE STMT FROM @CREATE_SQL;
EXECUTE STMT;
SELECT CONCAT(
'SELECT CUST,',
GROUP_CONCAT(REPLACE(' MAX(PROD_NAME) AS PROD_NAME', 'PROD_NAME', T.PROD)
SEPARATOR ','),
' FROM CUST3',
' GROUP BY CUST;'
)
INTO @SELECT_SQL FROM (SELECT DISTINCT PROD FROM... 阅读全帖 |
|
A*******n
发帖数: 625 | 7 你也觉的怪吧，这是其他人在N年前做的，是sql server 2000的，
Dimensions include:
1.Customer Name
1.1 Cust Key
1.2 Cust Name
1.3 Cust No
2. Customer Type Status
2.1 Cust Type
2.2 Cust Status
还有几个dimensions,先用这2个，
SELECT { [Customer Type Status].[All Customer Type Status].[C],
[Customer Type Status].[All Customer Type Status].[O],
[Customer Type Status].[All Customer Type Status].[R] } ON COLUMNS ,
{ [Customer Name].[All Customer Name].[#],
[Customer Name].[All Customer Name].[... 阅读全帖 |
|
b***n
发帖数: 13455 | 8 Greetings from Amazon.com.
We have received an A-to-z Guarantee claim against order 103-4240276-
00000000 because the buyer did not receive the item or items. The purchase
date was December 21, 2010. The buyer's comments were "cust have not receive
the order he placed and, according to the cust, he have contacted the
seller though no record is shown. cust further indicated that in had been
days since he contacted the seller and he still have not receive the package
and a reply. process guarante... 阅读全帖 |
|
e***l
发帖数: 6493 | 9 谢谢各位朋友关注！
下面是此CASE的detail：
Amazon investigator resolved this claim on Sunday, January 1, 2012
Your Re-presentation:
Sunday, December 25, 2011 The buyer ordered HP TouchPad Wi-Fi 32 GB 9.7-
Inch Tablet Computer from me on November 30. This product is not an android
tablet. My description did NOT state it is an android tablet, either. The
buyer must have known this before he placed the order. I sent him the right
product, which was the same as what he ordered and as what I described.
Before the b... 阅读全帖 |
|
A*******n
发帖数: 625 | 10 请教一个问题：
declare @cust table
(
Id int IDENTITY(1,1) NOT NULL,
Rateid int,
custId int
)
这个table有18000多个记录。
create table #rate
(
CustId int,
RateID int,
RateTypeId int,
EffectiveDate datetime,
ExpirationDate Datetime,
OrderIndex int
)
这个table有92000个记录，可是下面这个loop就很慢（要3-4分钟）：
select @count=COUNT(1)
from @cust
--------这个loop是找到每一个Cust Id的Rate Type IDs
while(@index<=@count)
begin
set @result=''
set @custid=0
select @custid= custId from @cust ... 阅读全帖 |
|
s*****d
发帖数: 2667 | 11 MySql:
create table cust2 as
(select cust,
IF(prod='A',1,0) as A,
IF(prod='B',1,0) as B,
IF(prod ='C',1,0) as C,
IF(prod='D',1,0) as D
from cust);
select cust,max(A) as A,max(B) as B,max(C) as C,max(D) as D
from cust2
group by cust; |
|
s*****d
发帖数: 2667 | 12 MySql:
create table cust2 as
(select cust,
IF(prod='A',1,0) as A,
IF(prod='B',1,0) as B,
IF(prod ='C',1,0) as C,
IF(prod='D',1,0) as D
from cust);
select cust,max(A) as A,max(B) as B,max(C) as C,max(D) as D
from cust2
group by cust; |
|
c*********r
发帖数: 19468 | 13 AC
ACC COBRA BN7667 SA9AK3026SA0175113
ACC ACE BN2323 SA9AC3029RAO62033
ACC ACE BN7888 DES1031
ACC ACE BN2228 DES1032
ACC COBRA BN513 SA9AK3024SA017512
ACC ACE BN6363 SA9AC3023RA06230
ACC COBRA COB1V SA9AK3022SA017511
ACC ACE BK12 SA9AC3027SA062036
ALFA ROMEO
ALF 164 BL5002 ZAR16400006209070
ALF 164 BL9271 ZAR16400006262569
ALF 164 BL7585 ZAR16400006208842
MERCEDES BENZ SPECIALS BY AMG
AMG 600 BP9922 WDB10001222000143
AMG 600SEL BN9933 WDB1400572A192240
AMG 600SL BN8668 WDB1290762F102243
AMG 600... 阅读全帖 |
|
y****2
发帖数: 826 | 14 一个病人在2/13买了我的电脑；
4/22用个人邮箱写了一份信给我说电脑是坏的，要我退钱；
4/22我马上回信，告诉她，Amazon policy是一个月后不能退钱了，但是我愿意帮忙找
厂家要warranty;
4/26我写信给她，告诉她如何联系厂家，如何得到warranty;
4/27她又以个人邮箱写信告诉我谢谢我的帮助。
我以为一切都搞定了。
但是今天5/20，我收到amazon claim，病人是这么说的：The item is defective. the
seller told the cust to go to manufacturer, she has been going back and
forth with manufacturer, and seller for 2 months trying to get this issue
resolved. the cust just wants to return the item, and the seller has stopped
contacting her back when she emails them. |
|
c*******l
发帖数: 769 | 15 怎么觉得跟你买的人也是个reseller，不是收货人，好像是三方的关系。
The item is defective. the
seller told the cust to go to manufacturer, she has been going back and
forth with manufacturer, and seller for 2 months trying to get this issue
resolved. the cust just wants to return the item, and the seller has stopped
contacting her back when she emails them. |
|
b***n
发帖数: 13455 | 16 查了一下, 是11/17号买的个游戏, 今天来claim说 Materially Different, 要求
refund...怎样represent 给amazon呢?
Greetings from Amazon.com.
We have received a claim under the A-to-z Guarantee program for the order
102-5000507-53550001 because the details and/or condition of the item(s)
were not as described. The buyer's comments were "the item did not meet the
cust expectations. returned the item unopened. cust tried to contact the
seller but of no respond. ".
Please note that you have seven (7) days to respond to this e-... 阅读全帖 |
|
e***l
发帖数: 6493 | 17 先爆：
DANIEL ENRRIQUE CASTELLANOS
2240 NW 114th AVE. UNIT ZM, PO BOX CBL 0464, ZOOM
MIAMI FLORIDA 33172-3652
MIAMI, FLORIDA
US 33172
（不是我啰嗦，是it啰嗦，搞那么怪的还重复的地址）
我用的Fedex label地址：
DANIEL ENRRIQUE CASTELLANOS
2240 NW 114th AVE. UNIT ZM
PO BOX CBL 0464, ZOOM
MIAMI FL 33172
带Direct Signature。
物品：
$400 laptop一台
it 在11/25 在AMZ买的，俺11/27在Fedex发货，Fedex 显示12/1 delivered，Signed
for by: JGARCIA
12/2曾去信，说货已运到，希望能留feedback，未获回应。
今天，it直接做了a-to-Z claim,
Buyer Comments: cust didnt receive the shipment and now cust ... 阅读全帖 |
|
a*q
发帖数: 2109 | 18
No no
If USTB first want be called BUST, why USTC still called instead of
CUST.
CUST dose not has any bad meanings.
I also know this tale before, but I think it is unbelievable.
Laluna, do you think so? |
|
H*******r
发帖数: 3143 | 19 应该是老外 把 CUST 和 安大 当成了同一个学校。
这样，安大的一部分，可能人很少，也统计到CUST里了。。 |
|
c*****d
发帖数: 6045 | 20 这不就是cust表join rate表吗?
select *
from cust c, rate r
where c.custid = r.custid |
|
s***c
发帖数: 1664 | 21 比如一个表
cust date prod
1 1/1/2015 A
1 1/2/2015 B
1 1/3/2015 B
2 1/3/2015 C
2 1/4/2015 D
怎么变成下面这个表，不管customer什么时候买过某个产品，买过几次，只要买过，就
记成1，否则0
cust A B C D
1 1 1 0 0
2 0 0 1 1
谢谢~ |
|
tj
发帖数: 957 | 22 select * from (select distinct cust, cust as c, prod) pivot (count(c) for
prod in ('A','B','C','D')); |
|
s***c
发帖数: 1664 | 23 比如一个表
cust date prod
1 1/1/2015 A
1 1/2/2015 B
1 1/3/2015 B
2 1/3/2015 C
2 1/4/2015 D
怎么变成下面这个表，不管customer什么时候买过某个产品，买过几次，只要买过，就
记成1，否则0
cust A B C D
1 1 1 0 0
2 0 0 1 1
谢谢~ |
|
s***c
发帖数: 1664 | 24 比如一个表
cust date prod
1 1/1/2015 A
1 1/2/2015 B
1 1/3/2015 B
2 1/3/2015 C
2 1/4/2015 D
怎么变成下面这个表，不管customer什么时候买过某个产品，买过几次，只要买过，就
记成1，否则0
cust A B C D
1 1 1 0 0
2 0 0 1 1
谢谢~ |
|
w*******y
发帖数: 60932 | 25 Some very good systems to be had...
Save 25% on all Dell Outlet Business Latitude Laptops! Enter DQD5NMS?1H?6WF
at checkout: Link:
http://del.ly/6010RpIi
Link:
http://del.ly/6010RpIi
(limit4/cust ,exp10/05)
Save 25% on all Del lOutlet Precision Mobile Workstations! Enter
HKW14TN1PW2J0M at checkout: Link:
http://del.ly/6013RpLP
(limit4/cust,exp10/05)
Other coupons can be found at Twitter:
http://twitter.com/#!/DellOutlet
#!/DellOutlet" rel="nofollow" target="_blank" onclick="_gaq.push(['_
trackEv... 阅读全帖 |
|
|
o*****D
发帖数: 1563 | 27 My research about the missing jetliner MH370 was reported on CNN and other
mainstream media. You got to grant me a green card.
--CUST guys |
|
|
|
|
发帖数: 1 | 31 因为trump快把阿三这个种族蛋都要捏碎了：
1. all talk no action (A3 office politics)
2. Hire graduate from foreign country (ICC, H1b abuse)
3. Out source (India cust. service centers)
4. IT company tax loop hole. |
|
s*******t
发帖数: 838 | 32 Here is the out the door price structure for the 2013 Toyota Sienna....
Deal Number: 337454
1) Contract Date: 11/20/12
2) Fin Inst: ANY
3) Cust Name: INTERNET
4) Stock Number: 60278
5) Cash Price: $ 28,288.00
6) Rebate: $ 1,000.00
7) Cash Down:
8) Total Trade Allow:
9) PU/Amt#1:
10) PU/Amt#2: ... 阅读全帖 |
|
w****l
发帖数: 239 | 33 你以后services咋办?在那里买以后就是那里免费洗车
Tom McCarthy
Sales Consultant
Mercedes-Benz of Naperville
1569 W. Ogden Ave.
Naperville, IL 60540
Hours: Mon: 1-8, Wed: 9-8, Thu: 9-5, Fri: 9-6, Sat: 9-6
Tuesday: By Appointment Only
M: 708.227.5675 W: 630.305.4560 x114
F: 630.357.0466
m*******[email protected]
cust# 44909265 |
|
f********N
发帖数: 996 | 34 raptor fully loaded is about 55k to 60k MSRP. Is 20K not enough for the cust
omization? |
|
|
e***7
发帖数: 862 | 36 他list上很多 具体的如下，我也看不太懂
A48 7.69
KITLOF5 0 20 LOF 1
15208AA15AELEM CP-OIL FL 1 9.96
803916010 GASKET 1 1.32
0W-20 DURA SYNTHETIC 6QT 50.76
下面还有
PARTS 11.28
REC-RT/SS/HZ 2.25
SALE TAX 4.25
Labor-Other 7.69
Parts-Other 50.76
TOTAL-CUST-CASH 76.23 |
|
q**j
发帖数: 10612 | 37 A48 7.69
KITLOF5 0 20 LOF 1
15208AA15AELEM CP-OIL FL 1 9.96
803916010 GASKET 1 1.32
0W-20 DURA SYNTHETIC 6QT 50.76
下面还有
PARTS 11.28 = 9.96 oil filter +1.32 gasket
REC-RT/SS/HZ 2.25 = recycle fee normal
SALE TAX 4.25
Labor-Other 7.69
Parts-Other 50.76 机油
TOTAL-CUST-CASH 76.23
挺简单的。dealer哪里就这样子。要想省钱，唯有diy。 |
|
S***I
发帖数: 2737 | 38 我朋友在波士顿附近，买的是裸的，不带天窗，33669， 减掉discount2034，
rebate2500，Local CUST 1250， 27885， 加上document fee， TAX， NONTAXFees，
最后OTD总价30270 |
|
F**D
发帖数: 6472 | 39 http://consumerist.com/2010/01/secret-credit-card-backdoor-numb
AmEx Oasis Program: 888-232-3261
American Express Credit Bureau Unit: 800-874-2717. Must have a current credi
t report before calling. They will ask for the account number from the credi
t report, which is different than your card number.
Barclays/Juniper: 866-750-6031 (Corp. Offices)
Best Buy: 888-237-8289 (customer care)
Best Buy: 800-365-0292 (CSR)
Best Buy App Status: 800-811-7276
Best Buy Store Card: 800-305-0533
BofA Acquisiti... 阅读全帖 |
|
|
|
c******a
发帖数: 11393 | 42 cust said they sent it back but the seller refused to refund saying its past
30 dasy customer said they were both hospitalized -no assurance file a to z
that can take up to 2 weeks |
|
s********9
发帖数: 4395 | 43 突然收到。
因为最近sent tons of resumes.但是我脚得是骗子。
谁懂的看看，是怎么实行骗局的呢？谢谢。
Detailed Job Description – Administrative Assistant
The Company name is ×××（我老还是删去比较好）,We are a swiss based trade
association that deal in the sales and distribution of wrist watches.
The primary goal of the Administrative Assistant is to provide local
customer assistant to our clients
within North America. You will be assisting our clients within North America
, the assistance to be
provided will include: payment collections and cust |
|
Y**********n
发帖数: 555 | 44 这个东西跟popover一个意思，数目少则算成功。有2个你不能用挤花嘴捅开往里灌cust
ard嘛。。。。。。。。
个人觉得纯灌鲜奶油的cream puff太腻了, costco就有冷冻的，只能买东西看见展示的
时候吃一个，表皮不脆，里面太腻。
还是自己烤，灌卡式达酱，趁新鲜，外脆里嫩的，yummy yummy~~~~~~~这样才值得吃这
样不健康的东西。 |
|
s*******1
发帖数: 2366 | 45
cust
哦...
卡式达酱是成品还是自己做的呢？ |
|
d******0
发帖数: 22800 | 46 hahaha.. 已经寄出了。
Quantity: 5
Product Description:
Creative Earbud EP630, CUST
Est. Delivery Date:
04/13/2010 |
|
r****m
发帖数: 1204 | 47 It's easy for a family's HSA account balance to be >$5K. As I said, you
have to call cust svc to ask for a waiver.
But Wells Fargo has sold its HSA biz recently, I haven't looked into the new
bank's fee structure and investment options, though. |
|
c******t
发帖数: 27 | 48 I think he is an Indian, a very nice guy.
1. Describe a project you worked lately.
He asked if I know memory flushing when I was giving the answer.
2. 2 sets of numbers, the quickest way to find the intersection.
3. for 2 strings, check if one is a sub-string of the other one (just like
strstr). Write the code and read it aloud to him.
4. for a web game, if you need to find the 10 highest score, how will you
design the interface?
5. You have a directory, it includes some files who have cust |
|
P*******b
发帖数: 1001 | 49 Given a table:
TABLE
Cust ID, Order ID, Date
Retrieve the customer who has ordered on two days ie., say 1st and 10th.
Also, is your query the most optimal one. |
|
