quote:

---

Originally posted by immad

this is my procedure




ALTER procedure [dbo].[hh]
@EmpID VARCHAR(50),
@FromDate DATETIME,
@ToDate DATETIME,
@Dept VARCHAR(50),
@Remarks VARCHAR(50),
@CID VARCHAR(50),
@BID VARCHAR(50),
@Grade VARCHAR(50),
@UserID VARCHAR(50)
AS
BEGIN

CREATE TABLE #P2
(
CID INT,
BID INT,
EBID INT,
EmployeeCode INT,
DID INT,
Date DATETIME,
[Time IN] DATETIME,
IAttendID INT,
[Time Out] DATETIME,
OAttendID INT,
DiffHrs INT,
DiffMin INT,
Spend NVARCHAR(50),
SID INT,
Shift NVARCHAR(50),
LTime DATETIME,
HDTime DATETIME,
EarlyArival DATETIME,
ShiftTimeDiff NVARCHAR(50),
ExcShort NVARCHAR(50),
SpendTimeDiffInSec NVARCHAR(50),
EShortTimeinSEC NVARCHAR(50),
DutyHours INT,
Remarks NVARCHAR(50),
Comments NVARCHAR(50),
InBetween INT,
EShortTime NVARCHAR(50),
userid VARCHAR(50)

)
INSERT INTO #P2
EXEC [26Procedure12] @EmpID,@FromDate,@ToDate,@Dept,@Remarks,@CID,@BID,@Grade,@userid


UPDATE #P2
SET CheckTime = DATEADD(DAY, -1, CheckTime)
WHERE Status = 'O' and checktime>'2013-09-23 00:00:00.000' and datepart(hh,CheckTime) BETWEEN 0 AND 11


i want to update that after insert in #P2
is that query correct

please help me out

immad uddin ahmed

---