Hi. Any help is appreciated. I am using SQL Server 2008 Native connection to MFG_PRO to import data in. However I need to test if a column exists and set it to a variable.
set @1 = select column name from pub.table where exists else @1 = 'AUS' data. I HAVE DOMAIN DATA IN ONE VERSION AND NON IN AN EARLIER VERSION.
In my bulk insert from MFG-PRO instead of using the column name I want to use the @1 variable.
Can this be done ?
Regards
Shane
set @1 = select column name from pub.table where exists else @1 = 'AUS' data. I HAVE DOMAIN DATA IN ONE VERSION AND NON IN AN EARLIER VERSION.
In my bulk insert from MFG-PRO instead of using the column name I want to use the @1 variable.
Can this be done ?
Regards
Shane
