标题: 紧急求助..谁能帮我把sql中的存储过程转换到sas程序中来,然后用sas程序去实现它们? 非常紧急,希望大家能帮忙,不 [打印本页] 作者: shiyiming 时间: 2011-8-18 11:03 标题: 紧急求助..谁能帮我把sql中的存储过程转换到sas程序中来,然后用sas程序去实现它们? 非常紧急,希望大家能帮忙,不 紧急求助..谁能帮我把sql中的存储过程转换到sas程序中来,然后用sas程序去实现它们? 非常紧急,希望大家能帮忙,不胜感激,谢谢!!!
1：UPDATE pt_BankFile_process(表1) set OpenBalance=CAST(b.Balance AS MONEY)
FROM pt_BankFile_process(表1) a
INNER JOIN #t2(临时表2) b
ON a.BankID=b.bankId
AND a.AccountNumber=b.AccountNumber
AND a.OpenDate=CONVERT(DATETIME,b.Date_Account_Opened)
WHERE a.OpenBalance!=b.Balance AND a.BankID=9
2：UPDATE pt_BankFile_process(表1)
SET DT = b.dt_times
FROM pt_BankFile_process a
INNER JOIN #t2(临时表2) b
ON a.BankID=9
AND a.AccountNumber=b.AccountNumber
AND a.OpenDate=b.[Date_Account_Opened]
3: delete from pt_BankFileDetail where BankID=9
4:INSERT INTO pt_BankFileDetail (
BankID ,
AccountNumber ,
MyAccountNumber ,
[Date] ,
Amount ,
[Type]
)
SELECT
a.BankID
,a.AccountNumber
,a.MyAccountNumber
,a.opendate
,b.TransactionAmount
,'T'
FROM pt_BankFile_process a
JOIN [pt_QualificationRequirements] b
ON a.BankID = 9
AND b.BankID = 9
AND a.ProductType = 'Checking'
AND b.ProductType = 'Checking'
JOIN dbo.Tmp_Index c
ON a.DT=c.ix
ORDER BY AccountNumber