This week’s SQL Server e-newsletter describes how to build a table from a list of values and then join the table to the target table. Please let us know whether you plan to use the methods described in this tip to optimize queries.
If you aren’t subscribed to the free SQL Server e-newsletter, you can automatically subscribe to this e-newsletter by pasting the following URL into your browser:
http://nl.com.com/MiniFormHandler?brand=builder &subs_channel=bldr_front_door&list_id=e046&tag=fb
* Please delete any extra spaces that appear when you paste this URL into your browser.