Paul.Dunne 98380 (4/24/2014)

---

I have a stored procedure that contains the following syntax:

select rotable.ro, rotable.ro_name,

Br.in_error as in_error, Br.Revd as Revd,

BER3.in_error as in_error3, BER3.Revd as Revd3,

BER4.in_error as in_error4, BER4.Revd as Revd4,

BER5.in_error as in_error5, BER5.Revd as Revd5,

Ba.in_error as in_error1, Ba.Revd as Revd1

into [dbo].BenEntAcc

from rotable Left Outer Join BenEntAccR Br

ON rotable.ro = Br.ro Left Outer Join BER3

ON rotable.ro = BER3.ro Left Outer Join BER4

ON rotable.ro = BER4.ro Left Outer Join BER5

ON rotable.ro = BER5.ro Left Outer Join BenEntAccA Ba

ON rotable.ro = Ba.ro

Occasionally the table is created but is missing columns:

in_error3, Revd3,in_error4, Revd4,in_error5, Revd5.

The table has the columns before AND after the ones that are missing.

I cannot replicate this behavior on demand. Most times the table is created correctly.

I have not been able to find any reference to this type of behavior using “select into”.

SQL Server 2008 R2