Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2012-05-20 : 00:21:26
|
| is it better to use temporary tables or subqueries in an inline functionif an inline function performs complicated calculation and this inline function is called in a pivot thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-20 : 10:56:41
|
| can you elaborate on what exactly you're trying to achieve here? its quite difficult for us to go through current code and understand the logic------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-21 : 16:49:36
|
quote:
Originally posted by sarahmfr
is it better to use temporary tables or subqueries in an inline functionif an inline function performs complicated calculation and this inline function is called in a pivot thanks
you cant have temporary tables in inline functionUsing temporary tables means its not inline but its multistatement table valued function.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
improve performance of a function getting percenta