You can use ALTER TABLE to add each column.
>In My the case the feilds name should be a variable
>such as
>cpstage1,npstgqty1
>cpstage2,npstgqty2
>.
>..
>cpstagen,npstgqtyn
>
>Where in the value of n is determined in the run time. Is there any way to loop the create command
>
>Thanks in advance
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer