34,575
社区成员
发帖
与我相关
我的任务
分享
create table pTB
(id int,
PHuHao varchar(30),
Pdate datetime,
Pmoney Money,
Pzt varchar(10),
pzn money
)
if object_id('rpTBByPdate','P') is not null
DROP PROC [rpTBByPdate]
Go
CREATE PROCEDURE rpTBByPdate
AS
DECLARE @D INT,@FirstDay DATETIME,@Pdate DATETIME
SELECT @Pdate=Pdate FROM pTB
SELECT @FirstDay=CONVERT(datetime,CONVERT(char(8),@Dt,120)+'15') --本月的第十五天
IF DATEPART(dd,@Pdate)>15
SELECT @D=DATEDIFF(dd,@FirstDay,@Pdate)
ELSE
SELECT @D=1
SELECT id,PHuHao,Pdate,Pmoney AS Pvalue,pzn=Pmoney*1.0*@D FROM pTB
Go