This is new to me and I did some searching in the knowledge base but could not find anything on what I am trying to accomplish. Not that it doesn't exist I may not have been searching the correct information.
I have a PriceTable (pt) that needs to have three columns, BeginDate, EndDate & PriceGroupName, from the results of this stored procedure, which requires 4 parameters: dbo.spGetPriceDetail '2015-09-15', '0028', '972201', 0 (the parameters are pt.PriceDate, pt.StoreId, pt.ItemId, & the 0 (zero) is if it is With Card and a 1 for Without Card - which I will know by the PriceTable row). I am not certain how to write a sql script that would allow me to process a record in the PriceTable --> Pass the necessary information to the store procedure --> return the results to the correct columns in the PriceTable and update that row.
I am using MS SQL 2014.
Thank you in advance for you time and assistance in this matter.