I have a create table procedure that runs three SP's to populate it- and I am having trouble getting them to work-
I added four more columns to the table and the first SP errors out
Msg 213, Level 16, State 1, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Do I need all of the coumns in each SP??
If so can I default the columns to null until there data can update properly??
Null as phys_low,
Null as phys_high,
Null as Los_low,
Null as Los_high
Can someone help me answer this??
Thanks!
Susie
Our community of experts have been thoroughly vetted for their expertise and industry experience.