Function A
, scalar, returns smallint (a year)
Function B
, scalar, returns smallint (a month)
Function C
, table, displays users based on year and month.
They work fine.
I would like to set default parameter of Function C
to come from Func A
& B
like:
@year smallint = SELECT FunctA(), @month smallint = SELECT FunctB()
Is there anyway around this?
We are on Azure SQL Managed Instance.