May 28, 2020 at 12:00 am
Comments posted to this topic are about the item Inlining Scalar UDFs
Gregory A. Larsen, MVP
May 28, 2020 at 11:34 am
Why can't you take the meaningless loop out of Function 5 and make it inline? There's no point in counting up from 0 until you reach the parameter value. Just rewrite it to look for the @RatingID.
Also, what is the point of creating the table variable in Function 4? Just query against the Rating table joined to Customer, and it can be inline.
May 28, 2020 at 1:19 pm
Why can't you take the meaningless loop out of Function 5 and make it inline? There's no point in counting up from 0 until you reach the parameter value. Just rewrite it to look for the @RatingID.
Also, what is the point of creating the table variable in Function 4? Just query against the Rating table joined to Customer, and it can be inline.
Why can't you take the meaningless loop out of Function 5 and make it inline? There's no point in counting up from 0 until you reach the parameter value. Just rewrite it to look for the @RatingID.
Also, what is the point of creating the table variable in Function 4? Just query against the Rating table joined to Customer, and it can be inline.
It wouldn't work because then the answers to the question would change.
May 28, 2020 at 4:03 pm
One of the correct answers is Function 2, but I don't see that one. I only see 1, 3, 4 and 5.
Edit: Mea Culpa, it's not labeled like the others.
14090 SW TENNESSEE LN
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply