9 lines
281 B
SQL
9 lines
281 B
SQL
--Migration
|
|
UPDATE T_INTEZMENYADATOK_OSSZES
|
|
SET
|
|
C_JUTTATASHATARNAP = DATEFROMPARTS(DATEPART(year, C_JUTTATASHATARNAP), DATEPART(month, C_JUTTATASHATARNAP), 15)
|
|
,SERIAL = SERIAL + 1
|
|
,MODIFIER = 0
|
|
,LASTCHANGED = GETDATE()
|
|
WHERE C_JUTTATASHATARNAP IS NOT NULL
|