Forum Discussion

Kammy89's avatar
Kammy89
Copper Contributor
Nov 17, 2022

Create Age variable

Hello,

 

I have a table called acrsdw.person with a DOB (date of birth variable). I want to create an age variable. However, there are two conditions I can not alter the table and I can not create a new table due to permissions issues. Is there any other way?  

1 Reply

  • José DR's avatar
    José DR
    Copper Contributor
    Nov 18, 2022

    Kammy89Create a view that calculates age.

    https://learn.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql

Resources