How to create calculated date colmn from existing date colmn

Question

I have tblStore which has FixtureDate. Now I need to write a store procedure which will return the table but with extra column 'OpeningDate' This OpeningDate will have FixtureDate + 10days. How do i achieve this? Please help me tblStore stNum city FixtureDate 1 NYC 1/23/2017 2 NYC 1/23/2017 3 NYC 1/23/2017

Nepethya Rana · Answer

For meeting id 1.. I want all agenda daily notes in one cell.. Day1 day2 agenda.. tblMeeting ID Agenda 1 This Is day 1 First agenda.This Is day 1 Second agenda.This Is day 2First agenda.This Is day 2  Second agenda.

Tapan Patel · Answer

CREATE PROCEDURE dbo.SPName AS BEGIN SELECT Columns  FixtureDate DATEADD( DAY 10FixtureDate) [OpeningDate] FROM dbo.tblStore END GO

tblStore
stNum	city	FixtureDate
1	NYC	1/23/2017
2	NYC	1/23/2017
3	NYC	1/23/2017