How to nest XML output in a SQL SELECT statement

A customer asked, “How to format [or structure] XML Output to include a sub-group inside the XML”. The customer is using a SELECT statement with FOR XML, and wants to nest an XML element such as the following: Before <BusinessPartner>     <Key>1234</Key>     <Name>Test Company</Name>   </BusinessPartner> After <BusinessPartner>     <Key>1234</Key>     <CompanyDetails>           <Name>Test…

1

Data Explorer and Office 365 – Create a report from an Azure SQL Database source

This post shows how to create an Excel task report from a “Data Explorer” query connected to a Windows Azure SQL Database instance provisioned with Access 2013. In Access 2013, you can create an Access web app. When Access 2013 provisions the web app to Office 365, it creates a complete Windows Azure SQL Database…

0

10 reasons to use Data Explorer from the Community

Before starting this post, I want to thank all of our customers for commenting about how much they love Data Explorer. Keep on giving us your feedback, we are reading your comments, and plan to create more tutorials based on your comments. In fact, please let me know what tutorials you would like in our…

2

Data Explorer: An introduction to table relationships and the Expand operation

This post is an introduction to table relationship concepts as related to the Data Explorer Expand operation. The Expand operation makes combining data together really easy. One of the goals of efficient data management design is to remove duplicate data that is contained in a data source. To achieve that goal, a data management application…

1

Migrate a WCF Data Service to Windows Azure

I just published a step by step guide to publish and consume a Windows Azure WCF Data Service connected to an Azure SQL Database using Azure Access Control Service (ACS) claims-based authentication. The content has several lessons about exposing an Azure SQL Database on Windows Azure as a WCF Data Service. You can download a…

0