-
Notifications
You must be signed in to change notification settings - Fork 0
/
SP_CursorLoaiGD.sql
32 lines (28 loc) · 923 Bytes
/
SP_CursorLoaiGD.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
USE [CHUNGKHOAN]
GO
/****** Object: StoredProcedure [dbo].[CursorLoaiGD] Script Date: 5/13/2021 10:06:34 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[CursorLoaiGD]
@OutCrsr CURSOR VARYING OUTPUT,
@macp NVARCHAR( 10), @Ngay NVARCHAR( 10), @LoaiGD CHAR
AS
SET DATEFORMAT DMY
IF (@LoaiGD='M')
SET @OutCrsr=CURSOR KEYSET FOR
SELECT ID, NGAYDAT, SOLUONG, GIADAT FROM LENHDAT
WHERE MACP=@macp
AND DAY(NGAYDAT)=DAY(@Ngay)AND MONTH(NGAYDAT)= MONTH(@Ngay) AND YEAR(NGAYDAT)=YEAR(@Ngay)
AND LOAIGD=@LoaiGD AND SOLUONG >0
ORDER BY GIADAT DESC, NGAYDAT
ELSE
SET @OutCrsr=CURSOR KEYSET FOR
SELECT ID, NGAYDAT, SOLUONG, GIADAT FROM LENHDAT
WHERE MACP=@macp
AND DAY(NGAYDAT)=DAY(@Ngay)AND MONTH(NGAYDAT)= MONTH(@Ngay) AND YEAR(NGAYDAT)=YEAR(@Ngay)
AND LOAIGD=@LoaiGD AND SOLUONG >0
ORDER BY GIADAT, NGAYDAT
OPEN @OutCrsr
GO