data-shaping.md

title	Data Shaping | Microsoft Docs
ms.prod	sql
ms.prod_service	connectivity
ms.technology	connectivity
ms.custom
ms.date	01/19/2017
ms.reviewer
ms.topic	conceptual
helpviewer_keywords	data shaping [ADO]
ms.assetid	62bd7dc9-45b5-4ca9-8b52-457325e0ce9e
author	MightyPen
ms.author	genemi

Data Shaping

This section contains the following topics.

• Data Shaping Overview

• Data ShapingExample

• Reshaping

• Grandchild Aggregates

• Parameterized Commands with Intervening COMPUTE Commands

• Persisting Hierarchical Recordsets

• Required Providers for Data Shaping

• Shape Commands in General

• Shape APPEND Clause

• Shape COMPUTE Clause

• Fabricating Hierarchical Recordsets

• Accessing Rows in a Hierarchical Recordset

• Formal Shape Grammar

• Visual Basic for Applications Functions