How to create calculated date colmn from existing date colmn

Sep 22 2017 1:33 PM

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

Answers (2)

Select Query for XML data in sqlserver.