- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
ALTER TRIGGER [dbo].[ObjectTrade]
ON [dbo].[packets]
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
DECLARE
@id_key int,
@id_th int,
@date_end datetime,
@date_beg datetime
SET @id_key = (SELECT id_key FROM inserted)
SET @id_th = (SELECT id_th FROM inserted WHERE id_key = @id_key)
SET @date_end = (SELECT date_end FROM inserted WHERE id_key = @id_key)
SET @date_beg = (SELECT date_beg FROM inserted WHERE id_key = @id_key)
IF @id_th = 183
UPDATE packets
SET packets.date_end = CAST('12-05-2014' AS DATE)
WHERE id_key =@id_key
IF (CAST(@date_end AS DATE) BETWEEN '08-03-2014' and '10-03-2014') SET @date_end = '07-03-2014'
IF (CAST(@date_end AS DATE) BETWEEN '01-05-2014' and '04-05-2014') SET @date_end = '30-04-2014'
IF (CAST(@date_end AS DATE) BETWEEN '09-05-2014' and '11-05-2014') SET @date_end = '08-05-2014'
IF (CAST(@date_end AS DATE) BETWEEN '12-06-2014' and '15-06-2014') SET @date_end = '11-06-2014'
IF (CAST(@date_end AS DATE) BETWEEN '02-11-2014' and '04-11-2014') SET @date_end = '01-11-2014'
IF (CAST(@date_end AS DATE) BETWEEN '01-01-2015' and '08-01-2015') SET @date_end = '31-12-2014'
IF DATEPART(WEEKDAY, @date_end) = 7 SET @date_end = DATEADD(DAY, -1, @date_end)
UPDATE packets SET packets.date_end = @date_end WHERE id_key =@id_key
END