Help - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Help

Help# Database - 数据库

s*o2010-04-22 07:04

1 楼

一个移民律师想申请NIW, 已经交了大约$1600. 让我先准备推荐信。目前律师还没有参
与什麽工作。那知天有不测风云，昨天被老板告诉说不用来上班了，就是把我lay off
了。我立刻给律师打电话，希望在这种特殊情况下，能中止绿卡申请。但律师告诉我这
种情况还可以继续办。我有点困惑，不知是不是律师忽悠我，想赚这笔钱？想咨询一下
大家，我这种情况还能办NIW 吗？如果我六月份之后，身份都不能保证，也可以申请
NIW 吗？如果硬要办，是不是成功的可能非常小？我实在不想后面的钱再打水漂，如
果他不肯推我 $1600, 尤其在这个困难的时候，因为我们的经济不宽裕。
先谢谢大家了。

J*G2010-04-22 07:04

2 楼

费翔经典回顾：原唱篇（二）
一、专辑午夜星河，1982年，百代唱片
这张专辑沿袭了首张专辑的曲风，主打歌曲午夜星河曾经红遍大街小巷。
在选歌方面，本张专辑选了不少后来被别人翻唱而红的的经典曲目，这些曲目费
翔首唱并没有引起歌迷的特别关注，比如马兆骏写的爸爸不要说，几年后由伊能静翻唱
而红，也许是因为费翔潇洒倜傥的形象和叛逆小孩不沾边；还有海洋之歌，两年后由同
在百代唱片的陈淑桦翻唱，红极一时，成为陈淑桦百代时期的代表力作。
贴两首比较好听的：
1、午夜星河
听歌链接:
http://www.imusiccn.com/player/play.asp?id=122971|
曲:佚名词:吴惠美
嘿午夜天边哦
嘿午夜星河哦
遥望着星星星星闪动
放射着闪亮着闪亮着光芒
嘿午夜天边哦
嘿午夜星河哦
是多么动人的动人的夜里
我陶醉在午夜星河
北斗星对轻轻的诉说
我总有一天要登上星河
星伴月长相随
星伴月长依偎
2、爱我
这首我记得姜育恒后来翻唱过。
听歌链接：
http://www.imusiccn.com/player/play.asp?id=135829|
词曲：林洲豪
为什

i*i2010-04-22 07:04

3 楼

Sorry to type in English at office.
I need to import several thousand records into Salesforce, and create a new
list of unique accounts, which is the first step in import.
I was wondering how to eliminate the duplicates, and at the same time, to
preserve all valuable information. (For example, I need to keep as much
information, such as Email, Telephone for the account)
AccountName Email Telephone
Alcee Duplessis Household (985) 703-0

T*s2010-04-22 07:04

4 楼

NIW和工作没关系吧
你要是申请EB1B就不一样了

i*a2010-04-22 07:04

5 楼

SQL 2008?
use MERGE
example:
MERGE INTO dbo.Customers AS TGT
USING dbo.CustomersStage AS SRC
ON TGT.custid = SRC.custid
WHEN MATCHED AND TGT.companyname <> SRC.companyname THEN
UPDATE SET
TGT.companyname = SRC.companyname,
TGT.phone = SRC.phone,
TGT.address = SRC.address
WHEN NOT MATCHED THEN
INSERT (custid, companyname, phone, address)
VALUES (SRC.custid, SRC.companyname, SRC.phone, SRC.address)
WHEN NOT MATCHED BY SOURCE THEN
DELETE
OUTPUT
$action, deleted.custid AS de

【在 i****i 的大作中提到】

: Sorry to type in English at office.
: I need to import several thousand records into Salesforce, and create a new
: list of unique accounts, which is the first step in import.
: I was wondering how to eliminate the duplicates, and at the same time, to
: preserve all valuable information. (For example, I need to keep as much
: information, such as Email, Telephone for the account)
: AccountName Email Telephone
: Alcee Duplessis Household (985) 703-0

i*i2010-04-22 07:04

6 楼

Thank you so much.... We did not use the MS SQL... that is a problem.

i*a2010-04-22 07:04

7 楼

don't know salesforce. if you are doing this inside salesforce then have to
look at their documents.
or maybe a big cow here knows salesforce...