• ChrisM@Work (8/24/2016)


    paulo.margarido (8/24/2016)


    i'm aware of what "inline table-valued functions" are, i have a few of my own in the DB

    what i ask is how can i do it that way

    if you can, using that simple sample i posted, how would you turn that to a table-valued function ?

    I can't, because I've no idea what output you expect from this process.

    Here's a holiday-calculating iTVF.

    Yesterday was the Independence Day and some of our staff had a statutory holiday.

    Did you function handle it correctly?

    _____________
    Code for TallyGenerator