Avatar of Eduardo Fuerte
Eduardo Fuerte
Flag for Brazil

asked on 

Could you explain and give a workaround on what is causing an UNION ALL to consider an original char(8) column by using MSSQLServer?

Hi Experts

Could you explain and give a workaround on what is causing an UNION ALL to consider an original char(8) column from the constituent tables that had be uncorrectly considered as an int  column at the resultant table,  by using MSSQLServer?

Accordingly to:



SELECT *
  INTO  TargetTable
FROM
(
SELECT  * FROM dbo.LOG_LOGRADOURO_AC_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_AL_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_AM_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_AP_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_BA_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_CE_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_DF_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_ES_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_MA_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_MG_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_MS_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_MT_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_PA_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_PB_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_PE_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_PI_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_PR_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_RJ_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_RN_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_RO_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_RR_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_RS_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_SC_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_SE_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_SP_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_TO_OK
UNION ALL
SELECT  * FROM dbo.LOG_LOGRADOURO_GO_OK
) a

Open in new window


Thanks in advance
Microsoft SQL Server

Avatar of undefined
Last Comment
Eduardo Fuerte

8/22/2022 - Mon