T-SQL: Cascading computed columns using CROSS APPLY operator(smehrozalam.wordpress.com)
submitted by 
mehroz(185) 2 years, 4 months ago
The powerful APPLY operator in Transact SQL is typically used to invoke a table-valued function for each row. But a very interesting usage of the cross apply operator is to produce a much readable code when we have several computed columns, in which the result of each one depends upon a previous one. This post describes such usage.
|category: Database
|Views: 18
tags:
Database another
Everyones tags:
Your Tags: