Ajuda com o INSERT

[Robson_S]

insert into tb_GINC_Impact

([iD], DATE_TIME_LAST_ALTERED, DATE_TIME_OCCURRED, KEY_ITEM_AFFECTED, ASSIGNEE_DEPT,

RECORD_STATUS, RECORD_DESC, SYSTEM_NAME, RECORD_TYPE, REPORTER_DEPT,

DATE_TIME_FINISHED, IMPACT, DEFECT_TYPE, RESOLVED_BY, RESOLVER_DEPT, USER1, USER15,

USER_DATE1_TIME1, USER_DATE2_TIME2, USER_DATE3_TIME3)

(select [iD], (DATE_LAST_ALTERED) + ' ' + (TIME_LAST_ALTERED) AS DATE_TIME_LAST_ALTERED,

(DATE_OCCURRED) + ' ' + (TIME_OCCURRED) AS DATE_TIME_OCCURRED,

KEY_ITEM_AFFECTED, ASSIGNEE_DEPT, RECORD_STATUS, RECORD_DESC, SYSTEM_NAME, RECORD_TYPE, REPORTER_DEPT,

(DATE_FINISHED) + ' ' + (TIME_FINISHED) AS DATE_TIME_FINISHED,

IMPACT, DEFECT_TYPE, RESOLVED_BY, RESOLVER_DEPT, USER1, USER15,

*** (USER_DATE1) + ' ' + (USER_TIME1) AS USER_DATE1_TIME1,

*** (USER_DATE2) + ' ' + (USER_TIME2) AS USER_DATE2_TIME2,

*** (USER_DATE3) + ' ' + (USER_TIME3) AS USER_DATE3_TIME3

FROM

[WAM_IMP].[dbo].[TIMPDATA]

WHERE

id in (select td.id from wam_imp..timpdata td

left join tb_GINC_Impact imp on td.id = imp.id

where imp.id is NULL))

pessoal estou com um problema no insert, nessa parte que está

com "***", estou tendo um problema, quando eu vou pegar uma data e o campo da

outra tabela estiver em branco, o campo está sendo preenchido com a data

'01/01/1900' , alguém sabe como posso resolver este problema?

Obrigado.

[RoBiN]

Use um case, como por exemplo se o campo for nulo:

(CASE WHEN USER_DATE1 IS NULL THEN
   NULL
ELSE
   (USER_DATE1) + ' ' + (USER_TIME1)
END) AS USER_DATE1_TIME1

Assim a query ficaria:

insert into tb_GINC_Impact
([ID], DATE_TIME_LAST_ALTERED, DATE_TIME_OCCURRED, KEY_ITEM_AFFECTED, ASSIGNEE_DEPT,
RECORD_STATUS, RECORD_DESC, SYSTEM_NAME, RECORD_TYPE, REPORTER_DEPT,
DATE_TIME_FINISHED, IMPACT, DEFECT_TYPE, RESOLVED_BY, RESOLVER_DEPT, USER1, USER15,
USER_DATE1_TIME1, USER_DATE2_TIME2, USER_DATE3_TIME3)
(select [ID], (DATE_LAST_ALTERED) + ' ' + (TIME_LAST_ALTERED) AS DATE_TIME_LAST_ALTERED,
(DATE_OCCURRED) + ' ' + (TIME_OCCURRED) AS DATE_TIME_OCCURRED,
KEY_ITEM_AFFECTED, ASSIGNEE_DEPT, RECORD_STATUS, RECORD_DESC, SYSTEM_NAME, RECORD_TYPE, REPORTER_DEPT,
(DATE_FINISHED) + ' ' + (TIME_FINISHED) AS DATE_TIME_FINISHED,
IMPACT, DEFECT_TYPE, RESOLVED_BY, RESOLVER_DEPT, USER1, USER15,
(CASE WHEN USER_DATE1 IS NULL THEN NULL ELSE (USER_DATE1) + ' ' + (USER_TIME1) END) AS USER_DATE1_TIME1,
(CASE WHEN USER_DATE2 IS NULL THEN NULL ELSE (USER_DATE2) + ' ' + (USER_TIME2) END) AS USER_TIME2_TIME2,
(CASE WHEN USER_DATE3 IS NULL THEN NULL ELSE (USER_DATE3) + ' ' + (USER_TIME3) END) AS USER_DATE3_TIME3,
FROM
[WAM_IMP].[dbo].[TIMPDATA]
WHERE
id in (select td.id from wam_imp..timpdata td
left join tb_GINC_Impact imp on td.id = imp.id
where imp.id is NULL))

[Robson_S]

Deu certo muito obrigado...