When would you use a table-valued function?
<p>I'm currently learning about functions in sql server and I don't understand why/when you would use an <a href="https://technet.microsoft.com/en-us/library/ms189294(v=sql.105).aspx" rel="noreferrer">inline table valued function</a>. </p>

<p>I've tried reading about it and some examples but it is still unclear to me. Can someone explain or provide an easy to understand use-case scenario?</p>