By Emma Tsai
Performing functional testing for software applications is part of the job as a business analyst. Occasionally, I need to work with SQL server to do database queries so that I can verify that the application pulls data results as expected. Recently, I learned how to use PIVOT operator to group and aggregate data in SQL database. Here is how it works:
In pivot queries, here are the thr...

by Sheila Zhang
Exporting data from a database quite often is requested by a line of business or for data warehouse data updating.
For simple data transfer:

•  The data can be managed inside a select query.
•  The source data doesn’t need to merge with existing data at the destination.

You can use the SQL server import/export wizard if the data is transferred from the sourc...

by Sheila Zhang
This blog is a continuation from my previous blog: How to Query Using Microsoft SQL Server to Create XML, found here. 

Another great query using Microsoft SQL Server to create XML is using this process:

You can manually define your selected SML format by using the PATH option of the FOR XML clause.  In the PATH mode, the standard XML XPath, which describes the path...