SQL linh tinh

16.
/****** Object:  UserDefinedFunction [dbo].[ConvertNumberToText]    Script Date: 30/12/2014 09:34:25 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*
 Tanldt
 Ngày: 05/07/2006
 Trả về số kiểu chữ:
 select dbo.ConvertNumberToText('10736918')
*/
ALTER    FUNCTION [dbo].[ConvertNumberToText](
 @Number VARCHAR(32)
)
RETURNS NVARCHAR(500)
AS
BEGIN
DECLARE @Text NVARCHAR(500)
DECLARE @Len INT
DECLARE @i INT
DECLARE @j INT
DECLARE @Flag VARCHAR(10)

SELECT @Len = LEN(LTRIM(RTRIM(@Number)))
SELECT @i = 1
SELECT @Text = ''

IF @Len > 32
BEGIN
 SELECT @Text = N'Số quá lớn. Không thể convert được!'
 RETURN @Text
END

WHILE @i <= @Len
BEGIN
 IF ((@Len - @i + 1)%3 = 0
  AND SUBSTRING(@Number, @i, 1) = '0'
  AND (SUBSTRING(@Number, @i + 1, 1) <> '0' OR SUBSTRING(@Number, @i + 2, 1) <> '0'))
  SELECT @Text = @Text + N' không'

 IF SUBSTRING(@Number, @i, 1) = '2'
  IF @i = 1
   SELECT @Text = @Text + N' Hai'
  else
   SELECT @Text = @Text + N' hai'
 IF SUBSTRING(@Number, @i, 1) = '3'
  IF @i = 1
   SELECT @Text = @Text + N' Ba'
  ELSE
   SELECT @Text = @Text + N' ba'
 IF SUBSTRING(@Number, @i, 1) = '4'
  IF @i = 1
   SELECT @Text = @Text + N' Bốn'
  ELSE
   SELECT @Text = @Text + N' bốn'
 IF SUBSTRING(@Number, @i, 1) = '6'
  IF @i = 1
   SELECT @Text = @Text + N' Sáu'
  ELSE
   SELECT @Text = @Text + N' sáu'
 IF SUBSTRING(@Number, @i, 1) = '7'
  IF @i = 1
   SELECT @Text = @Text + N' Bảy'
  ELSE
   SELECT @Text = @Text + N' bảy'
 
 IF SUBSTRING(@Number, @i, 1) = '8'
  IF @i = 1
   SELECT @Text = @Text + N' Tám'
  ELSE
   SELECT @Text = @Text + N' tám'
 
 IF SUBSTRING(@Number, @i, 1) = '9'
  IF @i = 1
   SELECT @Text = @Text + N' Chín'
  ELSE
   SELECT @Text = @Text + N' chín'

 IF SUBSTRING(@Number, @i, 1) = '5'
  IF @i = 1
   SELECT @Text = @Text + N' Năm'
  ELSE
  
   BEGIN
 
    IF (@i > 0 AND (@Len - @i + 1)%3 = 1 AND SUBSTRING(@Number, @i - 1, 1) <> '0')
     SELECT @Text = @Text + N' lăm'
    ELSE SELECT @Text = @Text + N' năm'  
   END

 IF (@i > 1 AND SUBSTRING(@Number, @i, 1) = '1' AND (@Len - @i + 1)%3 = 1 AND SUBSTRING(@Number, @i - 1, 1) > '1')
  SELECT @Text = @Text + N' mốt'
 ELSE
   IF ((@Len - @i + 1)%3 <> 2 AND SUBSTRING(@Number, @i, 1) = '1')
   SELECT @Text = @Text + N' Một'

 IF ((@Len - @i + 1)%3 = 2 AND SUBSTRING(@Number, @i, 1) <> '0' AND SUBSTRING(@Number, @i, 1) <> '1')
  SELECT @Text = @Text + N' mươi'
 ELSE
  IF ((@Len - @i + 1)%3 = 2 AND SUBSTRING(@Number, @i, 1) <> '0')
  SELECT @Text = @Text + N' Mười'

 IF ((@Len - @i + 1)%3 = 2 AND SUBSTRING(@Number, @i, 1) = '0' AND SUBSTRING(@Number, @i + 1, 1) <> '0') SELECT @Text = @Text + N' lẻ'

 IF ((@Len - @i + 1)%3 = 0 AND (SUBSTRING(@Number, @i + 1, 1) <> '0' OR SUBSTRING(@Number, @i + 2, 1) <> '0'))
  SELECT @Text = @Text + N' trăm'
 ELSE IF ((@Len - @i + 1)%3 = 0 AND SUBSTRING(@Number, @i, 1) <> '0')
  SELECT @Text = @Text + N' trăm'

 IF ((@Len - @i + 1) = 4)
  SELECT @Text = @Text + N' nghìn'
 IF ((@Len - @i + 1) = 7)
  SELECT @Text = @Text + N' triệu'
 IF ((@Len - @i + 1) = 10)
  SELECT @Text = @Text + N' tỷ'
 IF ((@Len - @i + 1) = 13)
  SELECT @Text = @Text + N' nghìn tỷ'
 IF ((@Len - @i + 1) = 16)
  SELECT @Text = @Text + N' triệu tỷ'
 IF ((@Len - @i + 1) = 19)
  SELECT @Text = @Text + N' tỷ tỷ'
 IF ((@Len - @i + 1) = 22)
  SELECT @Text = @Text + N' triệu tỷ tỷ'
 IF ((@Len - @i + 1) = 25)
  SELECT @Text = @Text + N' tỷ tỷ tỷ'
 IF ((@Len - @i + 1) = 28)
  SELECT @Text = @Text + N' triệu tỷ tỷ tỷ'

 IF ((@Len - @i + 1)%3 = 0 AND SUBSTRING(@Number, @i, 1) = '0' AND SUBSTRING(@Number, @i + 1, 1) = '0' AND SUBSTRING(@Number, @i + 2, 1) = '0')
  SELECT @i = @i + 2

 IF (@Len - @i + 1)%3 = 1
 BEGIN
  SELECT @Flag = 'True'

  SELECT @j = @i

  WHILE @j <= @Len
  BEGIN
   IF SUBSTRING(@Number, @j, 1) <> '0'
    SELECT @Flag = 'False'
   SELECT @j = @j + 1
  END
 END

 IF @Flag = 'True'
  BREAK

 SELECT @i = @i + 1
END

 --QuangPNV
 if(LEN(@Text) > 0)
 begin
  set @Text = LOWER(@Text)
  set @Text = UPPER(LEFT(RTRIM(LTRIM(@Text)),1)) + RIGHT(RTRIM(LTRIM(@Text)),LEN(LTRIM(RTRIM(@Text))) - 1)
 end
RETURN @Text
END

15 tuyệt chiêu khó nhất của SQL transaction phiên
BEGIN TRANSACTION Tran_Test;
 UPDATE _Test SET [content] = 'bang téttt'

 IF @@ERROR != 0  -- neu co loi xay ra, rollback
 BEGIN
      PRINT 'rollback ne';
      ROLLBACK TRAN Tran_Test;
 END

 -----------------

BEGIN TRANSACTION Tran_Test2;
 UPDATE _ABC SET noidung = 'noidung'
 IF @@ERROR != 0  -- neu co loi xay ra, rollback
 BEGIN
      PRINT 'rollback ne';
      ROLLBACK TRAN Tran_Test2;
 END


 ROLLBACK TRAN Tran_Test;


--
declare @Tran_Test as varchar(20)
set @Tran_Test='Tran_Test'

declare @Tran_Test2 as varchar(20)
set @Tran_Test2='Tran_Test2'


Commit TRANSACTION @Tran_Test

Commit TRANSACTION @Tran_Test2



14.

UPDATE
    Table
SET
    Table.col1 = other_table.col1,
    Table.col2 = other_table.col2
FROM
    Table
INNER JOIN
    other_table
ON
    Table.id = other_table.id

13.

ALTER PROCEDURE [dbo].[発番_チェック] --Numbering_Check

@kid char(2),

@dno varchar(9) OUTPUT

AS

       INSERT INTO 発番管理(kanriID,odrDay,intSeq) VALUES(@kid,@oday,1) --Quản lý đánh STT đơn hàng

       SET @seq = 1

SET  @dno =RIGHT(@oday+RIGHT(1000 + @seq,3),9)

12. Delete same xóa trùng http://www.codeproject.com/Articles/157977/Remove-Duplicate-Rows-from-a-Table-in-SQL-Server

Remove Duplicate Rows from a Table in SQL Server

Sadeque Sharif, 16 Feb 2011 CPOL

4.78 (34 votes)

Rate: vote 1vote 2vote 3vote 4vote 5

Easiest way to delete more than one duplicate row from a table in SQL Server

Introduction

Most of the times, we use primary key or unique key for preventing insertion of duplicate rows in SQL Server. But if we don't use these keys, then it's obvious that duplicate rows could be entered by the user. After inserting duplicate rows into table, it becomes a major issue to delete those duplicate rows. In that time, we need to delete those duplicate rows to resolve the issue. So this topic will help us to delete those duplicate rows from the specific table.

Background

I used some basic T-SQL code to accomplish the target. So you don't need to worry to understand this code.

Problem

Firstly, we will create a table, where we will insert some duplicate rows to understand the topic properly. Create a table called ATTENDANCE by using the following code:

Collapse | Copy Code

CREATE TABLE [dbo].[ATTENDANCE](
 [EMPLOYEE_ID] [varchar](50) NOT NULL,
 [ATTENDANCE_DATE] [date] NOT NULL
) ON [PRIMARY]   

Now insert some data into this table.

Collapse | Copy Code

INSERT INTO dbo.ATTENDANCE (EMPLOYEE_ID,ATTENDANCE_DATE)VALUES
   ('A001',CONVERT(DATETIME,'01-01-11',5)) 
INSERT INTO dbo.ATTENDANCE (EMPLOYEE_ID,ATTENDANCE_DATE)VALUES
   ('A001',CONVERT(DATETIME,'01-01-11',5)) 
INSERT INTO dbo.ATTENDANCE (EMPLOYEE_ID,ATTENDANCE_DATE)VALUES
   ('A002',CONVERT(DATETIME,'01-01-11',5)) 
INSERT INTO dbo.ATTENDANCE (EMPLOYEE_ID,ATTENDANCE_DATE)VALUES
   ('A002',CONVERT(DATETIME,'01-01-11',5)) 
INSERT INTO dbo.ATTENDANCE (EMPLOYEE_ID,ATTENDANCE_DATE)VALUES
   ('A002',CONVERT(DATETIME,'01-01-11',5)) 
INSERT INTO dbo.ATTENDANCE (EMPLOYEE_ID,ATTENDANCE_DATE)VALUES
   ('A003',CONVERT(DATETIME,'01-01-11',5)) 

After inserting the data, check the data of the below table. If we grouped the employee_id and attendance_date, then A001 and A002 become duplicates.

EMPLOYEE_ID	ATTENDANCE_DATE
A001	2011-01-01
A001	2011-01-01
A002	2011-01-01
A002	2011-01-01
A002	2011-01-01
A003	2011-01-01

So how can we delete those duplicate data?

Solution

First, insert an identity column in that table by using the following code:

Collapse | Copy Code

ALTER TABLE dbo.ATTENDANCE ADD AUTOID INT IDENTITY(1,1)  

Now the table data will be like the following table:

EMPLOYEE_ID	ATTENDANCE_DATE	AUTOID
A001	2011-01-01	1
A001	2011-01-01	2
A002	2011-01-01	3
A002	2011-01-01	4
A002	2011-01-01	5
A003	2011-01-01	6

Check the AUTOID column. Now we will start playing the game with this column.
Now use the following code to find out the duplicate rows that exist in the table.

Collapse | Copy Code

SELECT * FROM dbo.ATTENDANCE WHERE AUTOID NOT IN (SELECT MIN(AUTOID) _
 FROM dbo.ATTENDANCE GROUP BY EMPLOYEE_ID,ATTENDANCE_DATE)  

The above code will give us the following result:

EMPLOYEE_ID	ATTENDANCE_DATE	AUTOID
A001	2011-01-01	2
A002	2011-01-01	4
A002	2011-01-01	5

Ultimately, these are the duplicate rows which we want to delete to resolve the issue. Use the following code to resolve it.

Collapse | Copy Code

DELETE FROM dbo.ATTENDANCE WHERE AUTOID NOT IN (SELECT MIN(AUTOID) _
 FROM dbo.ATTENDANCE GROUP BY EMPLOYEE_ID,ATTENDANCE_DATE) 

Now check the data. No duplicate rows exist in the table.
Is it too complicated?

11. A chương chuong SQL

DECLARE @barchID AS  INT
SET @barchID =78

  SELECT  dp.[Order], dp.DegreeName, SL =  COUNT(he.DegreeCode) 
  FROM Hrm_Employee he 
  LEFT JOIN Dic_Degree  dp ON he.DegreeCode = dp.Dic_DegreeID 
   WHERE he.Active = 1 
  AND (ISNULL(@barchID,0)  =  ''  OR  (ISNULL(@barchID,0)  <>  0  AND  he.Hrm_BranchID =   RTRIM(@barchID)))
  AND he.Hrm_BranchID=@barchID
  
  GROUP BY dp.[Order],  dp.DegreeName 
  HAVING COUNT(he.DegreeCode) > 0
  ORDER BY dp.[Order]

  SELECT  *  FROM  Hrm_TimeKeeper_TableList htktl

SELECT  *  FROM  Hrm_TimeKeeper_Shift htks WHERE  htks.Hrm_TimeKeeperTableListID=63

DELETE  FROM  Hrm_TimeKeeper_Shift WHERE  Hrm_TimeKeeperTableListID =  63


     select Hrm_EmployeeID, EmployeeCode, LastName +' '+FirstName, LaborFrom from Hrm_Employee
    
    select * from Hrm_Employee  where LastName like N'%Lê Thị Kim%'             -- and Hrm_BranchID=78
  
    update Hrm_Employee set Dic_Work_StatusID=7  where LastName +' '+FirstName like N'%Đặng xuân trường%' and Hrm_BranchID=78
    update Hrm_Employee set Dic_Work_StatusID=6  where Hrm_EmployeeID in(2861) and Hrm_BranchID=78
  
     select * from Hrm_Employee where  Hrm_BranchID=78
     where EmployeeCode like '%03304000%'
     LastName like N'%Lê minh%' and
    
   delete  Hrm_Employee      where LastName like N'%Giáng sinh%' and Hrm_BranchID=78

10. If you want to disable all constraints in the database just run this code:

-- disable all constraints
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

To switch them back on, run: (the print is optional of course and it is just listing the tables)

-- enable all constraints
exec sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"

9. ALTER TABLE SchoolFee DISABLE TRIGGER trigger_Update_SchoolFee
ALTER TABLE SchoolFee ENABLE TRIGGER trigger_Update_SchoolFee
8.

CREATE TRIGGER trigger_name ON tablename
FOR UPDATE
AS
SET NOCOUNT ON
IF ( UPDATE(Column1) OR UPDATE(Column2))
BEGIN
  your sql here
END

Số thứ tự so thu tu    STT
    SELECT * FROM (
      SELECT
        ROW_NUMBER() OVER (ORDER BY DateCode ASC) AS rownumber,
        DateCode, ClassID
      FROM Schedule
    ) AS foo
    WHERE rownumber <= 3

7.

DECLARE @IntVariable int;
DECLARE @SQLString nvarchar(500);
DECLARE @ParmDefinition nvarchar(500);

/* Build the SQL string one time.*/
SET @SQLString =
     N'SELECT BusinessEntityID, NationalIDNumber, JobTitle, LoginID
       FROM AdventureWorks2012.HumanResources.Employee 
       WHERE BusinessEntityID = @BusinessEntityID';
SET @ParmDefinition = N'@BusinessEntityID tinyint';
/* Execute the string with the first parameter value. */
SET @IntVariable = 197;
EXECUTE sp_executesql @SQLString, @ParmDefinition,
                      @BusinessEntityID = @IntVariable;
/* Execute the same string with the second parameter value. */
SET @IntVariable = 109;
EXECUTE sp_executesql @SQLString, @ParmDefinition,
                      @BusinessEntityID = @IntVariable;

Output parameters can also be used with sp_executesql. The following example retrieves a job title from the AdventureWorks2012.HumanResources.Employee table and returns it in the output parameter @max_title.

DECLARE @IntVariable int;
DECLARE @SQLString nvarchar(500);
DECLARE @ParmDefinition nvarchar(500);
DECLARE @max_title varchar(30);

SET @IntVariable = 197;
SET @SQLString = N'SELECT @max_titleOUT = max(JobTitle) 
   FROM AdventureWorks2012.HumanResources.Employee
   WHERE BusinessEntityID = @level';
SET @ParmDefinition = N'@level tinyint, @max_titleOUT varchar(30) OUTPUT';

EXECUTE sp_executesql @SQLString, @ParmDefinition, @level = @IntVariable, @max_titleOUT=@max_title OUTPUT;
SELECT @max_title;

6.                       CASE
                      WHEN dbo.SchoolFee.MonthSchoolFee IS NOT NULL THEN
                           SUBSTRING(CAST(dbo.SchoolFee.MonthSchoolFee AS CHAR(6)),5, 2) + '/' + SUBSTRING(CAST(dbo.SchoolFee.MonthSchoolFee AS CHAR(6)), 1, 4)
                           END AS 'MonthSchoolFee',


                      CASE dbo.SchoolFee.MonthSchoolFee
                      WHEN NULL THEN ''
                      ELSE
                           SUBSTRING(CAST(dbo.SchoolFee.MonthSchoolFee AS CHAR(6)),5, 2) + '/' + SUBSTRING(CAST(dbo.SchoolFee.MonthSchoolFee AS CHAR(6)), 1, 4)
                           END AS 'MonthSchoolFee',
5.
    Declare Tb_Cur Cursor
    For    Select Hrm_EmployeeID From [#tem_TKNS]
    Open Tb_Cur
    Fetch Next From Tb_Cur Into @Hrm_EmployeeID
    While @@FETCH_STATUS = 0
        Begin
             SELECT TOP (1) @ResolutionCoefficient=ResolutionCoefficient, @TitleCoefficient=TitleCoefficient
             FROM Hrm_Contract WHERE EmployeeID=@Hrm_EmployeeID AND IsCurrent=1
             --
             --select @ResolutionCoefficient AS 'here'
             UPDATE [#tem_TKNS] SET ResolutionCoefficient=@ResolutionCoefficient, TitleCoefficient=@TitleCoefficient
             WHERE     Hrm_EmployeeID=@Hrm_EmployeeID  
            Fetch Next From Tb_Cur Into @Hrm_EmployeeID
        End  
    Close Tb_Cur;
    Deallocate Tb_Cur;
4.

Date Format	Standard	SQL Statement	Sample Output
Mon DD YYYY 1 HH:MIAM (or PM)	Default	SELECT CONVERT(VARCHAR(20), GETDATE(), 100)	Jan 1 2005 1:29PM 1
MM/DD/YY	USA	SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]	11/23/98
MM/DD/YYYY	USA	SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]	11/23/1998
YY.MM.DD	ANSI	SELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD]	72.01.01
YYYY.MM.DD	ANSI	SELECT CONVERT(VARCHAR(10), GETDATE(), 102) AS [YYYY.MM.DD]	1972.01.01
DD/MM/YY	British/French	SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY]	19/02/72
DD/MM/YYYY	British/French	SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]	19/02/1972
DD.MM.YY	German	SELECT CONVERT(VARCHAR(8), GETDATE(), 4) AS [DD.MM.YY]	25.12.05
DD.MM.YYYY	German	SELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.MM.YYYY]	25.12.2005
DD-MM-YY	Italian	SELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY]	24-01-98
DD-MM-YYYY	Italian	SELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY]	24-01-1998
DD Mon YY 1	-	SELECT CONVERT(VARCHAR(9), GETDATE(), 6) AS [DD MON YY]	04 Jul 06 1
DD Mon YYYY 1	-	SELECT CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY]	04 Jul 2006 1
Mon DD, YY 1	-	SELECT CONVERT(VARCHAR(10), GETDATE(), 7) AS [Mon DD, YY]	Jan 24, 98 1
Mon DD, YYYY 1	-	SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY]	Jan 24, 1998 1
HH:MM:SS	-	SELECT CONVERT(VARCHAR(8), GETDATE(), 108)	03:24:53
Mon DD YYYY HH:MI:SS:MMMAM (or PM) 1	Default + milliseconds	SELECT CONVERT(VARCHAR(26), GETDATE(), 109)	Apr 28 2006 12:32:29:253PM 1
MM-DD-YY	USA	SELECT CONVERT(VARCHAR(8), GETDATE(), 10) AS [MM-DD-YY]	01-01-06
MM-DD-YYYY	USA	SELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY]	01-01-2006
YY/MM/DD	-	SELECT CONVERT(VARCHAR(8), GETDATE(), 11) AS [YY/MM/DD]	98/11/23
YYYY/MM/DD	-	SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [YYYY/MM/DD]	1998/11/23
YYMMDD	ISO	SELECT CONVERT(VARCHAR(6), GETDATE(), 12) AS [YYMMDD]	980124
YYYYMMDD	ISO	SELECT CONVERT(VARCHAR(8), GETDATE(), 112) AS [YYYYMMDD]	19980124
DD Mon YYYY HH:MM:SS:MMM(24h) 1	Europe default + milliseconds	SELECT CONVERT(VARCHAR(24), GETDATE(), 113)	28 Apr 2006 00:34:55:190 1
HH:MI:SS:MMM(24H)	-	SELECT CONVERT(VARCHAR(12), GETDATE(), 114) AS [HH:MI:SS:MMM(24H)]	11:34:23:013
YYYY-MM-DD HH:MI:SS(24h)	ODBC Canonical	SELECT CONVERT(VARCHAR(19), GETDATE(), 120)	1972-01-01 13:42:24
YYYY-MM-DD HH:MI:SS.MMM(24h)	ODBC Canonical (with milliseconds)	SELECT CONVERT(VARCHAR(23), GETDATE(), 121)	1972-02-19 06:35:24.489
YYYY-MM-DDTHH:MM:SS:MMM	ISO8601	SELECT CONVERT(VARCHAR(23), GETDATE(), 126)	1998-11-23T11:25:43:250
DD Mon YYYY HH:MI:SS:MMMAM 1	Kuwaiti	SELECT CONVERT(VARCHAR(26), GETDATE(), 130)	28 Apr 2006 12:39:32:429AM 1
DD/MM/YYYY HH:MI:SS:MMMAM	Kuwaiti	SELECT CONVERT(VARCHAR(25), GETDATE(), 131)	28/04/2006 12:39:32:429AM

3. convert datetime to date chuyển đổi sql server
 SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY]
 ------------------
2.  SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]

DECLARE @identity AS INT
SET @identity=0
Set nocount on
Insert into Process_Reward (RecipientID,PersonID,RewardCode,Foundation,Reason,Object,Form,Source,TotalValue,Status,Date,DecideNumber,DecideDate,Active)
values(@RecipientID,@PersonID,@RewardCode,@Foundation,@Reason,@Object,@Form,@Source,@TotalValue,@Status,@Date,@DecideNumber,@DecideDate,@Active)
SET @identity=@@IDENTITY

INSERT INTO Process_Reward_Employee
(
    EmployeeID,
    Process_RewardID, ACTIVE
)
VALUES
(
    @EmployeeID, @identity, 'TRUE'
)
return @@identity
............
Update Process_Reward set RecipientID=@RecipientID,PersonID=@PersonID,RewardCode=@RewardCode,Foundation=@Foundation,Reason=@Reason,Object=@Object,Form=@Form,Source=@Source,TotalValue=@TotalValue,Status=@Status,Date=@Date,DecideNumber=@DecideNumber,DecideDate=@DecideDate,Active=@Active
 where Process_RewardID=@Process_RewardID
exec USP_Process_Reward_Employee_Update  @EmployeeID, @Process_RewardID, 'TRUE'
...........