Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @TEMP_INC TABLE (
- INC_ID INT,
- OBJ_ID INT,
- INC_DESCRIPCION VARCHAR(255),
- INC_TIPOOBJ INT,
- INC_FC DATE,
- INC_FM DATE,
- INA_ID INT
- )
- INSERT INTO @TEMP_INC (INC_ID, OBJ_ID, INC_DESCRIPCION, INC_TIPOOBJ, INC_FC, INC_FM, INA_ID)
- VALUES
- (1439166, 620310, '* descripcion tipo 123', 7, '2015-07-04 17:07:36.000', '2015-07-04 17:07:36.000', 8),
- (1439167, 620310, '* descripcion tipo 124', 7, '2015-07-04 17:07:36.000', '2015-07-04 17:07:36.000', 8),
- (1439168, 620311, '* descripcion tipo 125', 7, '2015-07-04 17:07:37.000', '2015-07-04 17:07:37.000', 12),
- (1439169, 620311, '* descripcion tipo 126', 7, '2015-07-04 17:07:37.000', '2015-07-04 17:07:37.000', 15),
- (1439170, 620312, '* descripcion tipo 127', 7, '2015-07-04 17:07:37.000', '2015-07-04 17:07:37.000', 20),
- (1439171, 620312, '* descripcion tipo 128', 7, '2015-07-04 17:07:37.000', '2015-07-04 17:07:37.000', 22),
- (1439172, 620313, '* descripcion tipo 129', 7, '2015-07-04 17:07:38.000', '2015-07-04 17:07:38.000', 27),
- (1439173, 620313, '* descripcion tipo 132', 7, '2015-07-04 17:07:38.000', '2015-07-04 17:07:38.000', 26),
- (1439174, 620314, '* descripcion tipo 133', 7, '2015-07-04 17:07:39.000', '2015-07-04 17:07:39.000', 26),
- (1439175, 620314, '* descripcion tipo 134', 7, '2015-07-04 17:07:39.000', '2015-07-04 17:07:39.000', 24)
- SELECT
- INC_ID,
- OBJ_ID,
- INC_DESCRIPCION,
- INC_TIPOOBJ,
- INC_FC,
- INC_FM,
- INA_ID
- FROM @TEMP_INC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement