{"product_id":"9781939666185","title":"Common Table Expressions Joes 2 Pros: A Solution Series Tutorial on Everything You Ever Wanted to Know about Common Table Expressions","description":"The Common Table Expression (CTE) is one of the more\u003cp\u003epowerful and often overlooked features in Microsoft\u003c\/p\u003e\u003cp\u003eSQL Server. This Joes 2 Pros book will show some of\u003c\/p\u003e\u003cp\u003ethe more interesting things you can do with a CTE. We\u003c\/p\u003e\u003cp\u003ewill learn how CTEs are a great alternative to derived\u003c\/p\u003e\u003cp\u003etable queries, how to do data paging with a CTE, and\u003c\/p\u003e\u003cp\u003erecursive queries with tree path and hierarchical output.\u003c\/p\u003e\u003cp\u003eThis book will also cover how to use the DELETE,\u003c\/p\u003e\u003cp\u003eUPDATE, and INSERT statements with a CTE, and how\u003c\/p\u003e\u003cp\u003eto use CTEs in stored procedures and functions. We will\u003c\/p\u003e\u003cp\u003ediscover what is good and bad with CTEs when it comes\u003c\/p\u003e\u003cp\u003eto performance, and how to avoid performance pitfalls.\u003c\/p\u003e\u003cp\u003eThe twelve chapters take us from the most basic\u003c\/p\u003e\u003cp\u003eintroduction of a CTE all the way to the more complex\u003c\/p\u003e\u003cp\u003eusage scenarios where a CTE can change the way you\u003c\/p\u003e\u003cp\u003elook at writing T-SQL queries. Learn how to use a single\u003c\/p\u003e\u003cp\u003eCTE or multiple CTEs in a single statement as well as\u003c\/p\u003e\u003cp\u003enesting them.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Joes 2 Pros International LLC","offers":[{"title":"Default Title","offer_id":47060023607536,"sku":"9781939666185","price":15.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781939666185_p0.jpg?v=1763667326","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781939666185","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}