select * from qmd_ediData where transactionSet = order by transactionId delete from #_ediTableName# where ownerId = and ownerType = and eai_batchId = select transactionSet , 0 as #_c# from qmd_ediData group by transactionSet select name, length from syscolumns where id in ( select id from sysobjects where name = '#_ediTableName#' and xtype = 'U' ) and name =

Add #lcase( _c )# as #_sqlType#

alter table #_ediTableName# add #lcase(_c)# #_sqlType# null

Update #lcase( _c )# to #_sqlType#

alter table #_ediTableName# alter column #lcase(_c)# #_sqlType# null

Existing column #lcase( _c )# unchanged

update tbl_EAI_inboundBatches set loadedColumns = where batchId = and ownerId = and ownerType = insert into #_ediTableName# ( ownerId, ownertype, eai_batchId, edi_transactionId, edi_lineNumber, edi_transactionSet , #_c# ) values ( , , , , , , , , ) select * from qmd_ediData where 1 = 2