SQL Server Programming Part 10 - Table Valued Functions

By Andrew Gould

You can view a written version of this tutorial at:

You can download the script used to create the Movies database used in this video at:

You can see the range of resources and courses we offer in SQL Server here:

[BijouBakson]

I'm watching this 7 years later and I must say this is gold stuff.

[hombreazu]

Your videos are far and above anything else available on the subject.  Thank you for all your work.

[rajkumarrajan]

simply AMAZING!! you are AWESOME in explaining concepts

[rajendrampremnath]

Many thanks for all 12 parts. I am a starter. These videos explained very well. Thanks again!

[Mrleothelion]

Thanks for these videos, really clear and succinct explanations. I really appreciate them!!!

[Kubapl]

Great video, super useful even 10 years later.

Is it possible to pass another table (or an array) as an argument? For example, I have a string of values separated by a comma and I would like to perform a clause where particular record contains a value equal to one in my string

[zydra_ow]

Awsome overview, even 9 years later. But couldn't you've just used union in the last example?
select
directorName, directorDOB, 'director'
from
tblDirector
union
select
actorName, actorDOB, 'actor'
from
tblActor

Thanks for the video

[oot]

best sql server videos by far and in clear english. well done. any plans for SSAS videos?

[krismaly]

Very good explanation of ITVF and MSTVF.
I think prefixing some characters before function name could identify ITVF and MSTVF may be good practice, since both are stored in the same location. What do you think?
Thanks a lot

[ipsitapani]

well explained sir but how to call function from store procedure.?

[BrankoDimitrijevic]

`WHERE YEAR(field) = some_year` is not very good for performance, unless you actually have a computed index on `YEAR(field)`. Instead, it is better to have: `WHERE field >= start_of_year AND field < start_of_next_year`.

Nice video, regardless.

[jeetsakharkar]

How to calculate networking days in sql?


Networking days = Saturday, sunday and all government holiday

[Sgoose]

why return suffices? shouldn't it be return @t

[TheQciap]

Hi Andrew, great stuff ineed but I have qq:
In a 4:42 you select bunch of text and then with one click you move it to the right to have nice structure of the code.
Who do you do that?
;)

[DanielBin]

when I execute the function, it says that 'FilmName etc could not be bound'. Anyone knows why?

[RavikantRai]

So this is basically working like a stored procedure with a UNION inside of it.

[simonlester]

Does oracle has an equivalent of sqlserver TVF ..??