SQL查询问题,操纵数据
问题描述:
我存储了proc,它会告诉我们是否有任何新的检查要打印。现在我必须操纵数据库表中的数据,以便至少打印一张支票。我没有写这个查询。我试过了,但我至少没有打印一张支票。谁能帮我。这里是存储过程SQL查询问题,操纵数据
CREATE PROCEDURE [proc_1250_SELCashiersChecksForPrint] AS
SELECT t_DATA_CashiersChecksIssued.ControlNbr,
t_DATA_CashiersChecksIssued.Audit_DateAdded,
t_DATA_CashiersChecksIssued.BatchNbr,
t_DATA_CashiersChecksIssued.SerialNbr,
t_DATA_CashiersChecksIssued.CheckRTN,
t_DATA_CashiersChecksIssued.CheckAccountNbr,
t_DATA_CashiersChecksIssued.Amount,
t_DATA_CashiersChecksIssued.DateIssued,
t_DATA_CashiersChecksIssued.Payee,
t_DATA_CashiersChecksIssued.Address,
t_DATA_CashiersChecksIssued.City,
t_DATA_CashiersChecksIssued.State,
t_DATA_CashiersChecksIssued.Zip,
t_DATA_Reclamation.ClaimId, t_DATA_Reclamation.NoticeDate,
t_DATA_Reclamation.FirstName,
t_DATA_Reclamation.MiddleName,
t_DATA_Reclamation.LastName,
t_DATA_Reclamation.ClaimTotal,
t_PCD_Claimant.Name AS Agency,
t_DATA_CashiersChecksIssued.IDENTITYCOL
FROM t_DATA_CashiersChecksIssued INNER JOIN
t_DATA_Reclamation ON
t_DATA_CashiersChecksIssued.ControlNbr = t_DATA_Reclamation.ControlNbr
INNER JOIN
t_PCD_Claimant ON
t_DATA_Reclamation.ClaimantCode = t_PCD_Claimant.ClaimantCode
WHERE (t_DATA_CashiersChecksIssued.SerialNbr IS NULL) AND
(t_DATA_CashiersChecksIssued.DateIssued IS NULL)
ORDER BY t_DATA_CashiersChecksIssued.Audit_DateAdded ASC,
t_DATA_CashiersChecksIssued.ControlNbr ASC
GO
`
答
假设表中有数据,这将更新的第一行。
UPDATE TOP(1) t_DATA_CashiersChecksIssued
SET SerialMbr = NULL,
DataIssued = NULL
FROM t_DATA_CashiersChecksIssued
INNER JOIN t_DATA_Reclamation
ON t_DATA_CashiersChecksIssued.ControlNbr = t_DATA_Reclamation.ControlNbr
INNER JOIN t_PCD_Claimant
ON t_DATA_Reclamation.ClaimantCode = t_PCD_Claimant.ClaimantCode
我不想改变PROC。我想要操纵表格数据(比如添加额外的数据),以便得到最好的检查结果。那么你可以告诉我哪些表格或栏目数据需要更改以便获得最基本的检查结果。 – pbrp 2009-12-02 03:13:29
上述SQL将操纵数据,所以存储的proc将打印一张支票。 – 2009-12-02 03:26:51
我在哪里需要执行此查询?我的意思是在哪个表中?我在sql企业管理器中打开了t_DATA_CashiersChecksIssued表并试图执行那个表。但事实并非如此。 – pbrp 2009-12-02 03:34:26