Here is my insert statement followed by the values...
for certain values, I want to use the return value from the a sp (which is a identity value) and use that in my insert
......
INSERT into Pickups (Pickup, PUTimFrTu, PUTimToTu,PUTimFrWe,PUTimToWe, PUTimFrTh, PUTimToTh, PUTimFrFr, PUTimToFr, PUTimFrSa, PUTimToSa, PUTimFrSo, PUTimToSo,
PUOnFr, PUOnThu, PUOnSa, PUOnSo, BusnType, UseTruck, NeedApptm, InclHoopCarrNot,
Scale, PUVMCntcID, ScaleType, ScaleAddr, PUOnMon, PUOnTue, PUOnWed, ShortSiding, IntTranNotes, CarrNotNotes, UseRailcar, UseVessel, PickupVerMeth, SlsBuyCntcID, SlsMLev1CntcID, SlsMLev2CntcID, SlsShpCntcID,
MakeHeavyLoads, HasBaler, HarmMillBuyer, IntSlsNotes, HowNotifyDowngr, DowngrCntcID, PUNoType, PUNoCntcId, Tran1CntcID, SendMethTran2, Tran2CntcID, PUTimFrMo, PUTimToMo)
Values ( @mcAccount,@PuTimFrTuPU, @PuTimToTuPU, @PuTimFrWePU, @PuTimToWePU, @PuTimFrThPU, @PuTimToThPU, @PuTimFrFrPU, @PuTimToFrPU, @PuTimFrSaPU,@PuTimToSaPU,
@PuTimFrSoPU, @PuTimToSoPU, @PuOnFriPU, @PuOnThuPU, @PuOnSatPU,@PuOnSunPU,@BusnTypePU, @UseTruckPU, @NeedApptmPU, @InclHoopCarrPU, @ScalePU,
@PuvmCntcIDPU,@ScaleTypePU, @ScaleAddrPU, @PuOnMonPU, @PuOnTuePU,@PuOnWedPU, @ShortSidingPU, @IntTranNotesPU, @CarrNotNotesPU, @UseRailCarPU,@UseVesselPU, @PickUpVerMethPU, @SlsMLev1CntcIDPU, @SlsMLev2CntcIDPU, @SlsShpCntcIDPU, @SlsBuyCntcIDPU,
@MakeHeavyLoadsPU, @HasBalerPU, @HarmMillBuyerPU, @IntSlsNotesPU, @HowNotifyDownGrPU, @DownGrCntcIDPU, @PUNoTypePU, @PUNoCntcIdPU, @Tran1CntcIDPU, @SendMethTran2PU, @Tran2CntcIDPU,@PuTimFrMoPU, @PuTimToMoPU)