Data Access with Scalar UDF's

This video shows you how to use data access inside of a scalar user defined function

Andrew Novick is a SQL Server consultant building business solutions with the Microsoft tools. His expertise in database design, T-SQL coding, SQL Server security, database performance tuning, and database partitioning can be a valuable asset to many projects. Andrew Novick also offers training and mentoring services to relevant projects. His writing on computing can be seen at his web site ht...

Steve Harris on 7/14/2009

how would you need to restucture the statement

Dipak Saha on 7/14/2009

Great topic

CD2071C291 on 7/14/2009

Tell us how to restructure the inefficiency for larger datasets.

Carla Wilson on 7/14/2009

Because the ORDER BY is processed after the SELECT, you could use the alias of the calculated column in the SELECT, Territories, instead of the third call to the UDF, ie. ORDER BY Territories

Jonathan on 7/15/2009

Leaving the viewer hanging on how we might want to re-structure our statement is bad. At least throw forward to a 2nd video that explains that or some resources where that can be researched. Otherwise this is demonstrating a bad way to do stuff...

Steve Erickson on 7/15/2009

I would liked to of heard how to restructure the last query used in the video.

Steve Erickson on 7/15/2009

I would liked to of heard how to restructure the last query used in the video.

Caleb Bell on 7/16/2009

It would be nice to show how to restructure the statement to only call the UDF once at the end of the video.

pranab on 7/17/2009

good one

A Alagu Ganesh on 2/5/2010

Good