Obtaining Data as XML from SQL Server

Please refer the following links to convert the sql server table data as xml.


http://msdn.microsoft.com/en-us/library/ke345d80(v=VS.71).aspx


http://stackoverflow.com/questions/4625229/sql-server-t-sql-get-data-into-xml-using-for-xml-path


Eg: Select ID,Field1,Field2 from Test_TABLE 
      FOR XML PATH(''),ROOT('root')

Converting Rows into Columns using TSQL

To convert the rows into columns please refer the following link.

http://venkattechnicalblog.blogspot.com/2008/07/rows-to-columns-in-sql-server.html

Service Unavailable 503 Error in Sharepoint 2010

This error occurs when the password for the account in a active directory changes. 
If you get this error,
1. Go to IIS.
2. Select the application pool.
3. In the Application pool window, right click on Sharepoint Central Administration V4(V3.29.2011) and select Advanced Settings.
4. A window opens and select the option "Identity" in Process Model heading.
5. Select the option Built-In Account and select Local System as the option from drop down list.
OR
6. You can also select the Custom Account option. Click on Set button. Enter Username as Domain\username(Eg: AD\username) and password and go on clicking OK button.


Now launch the Sharepoint Central Administration and enjoy :)

Installing AdventureWorks Database

http://msftdbprodsamples.codeplex.com/releases/view/55926

Instal & Configure Sharepoint 2010.

Please refer the following link to install and configure Sharepoint 2010.

http://mosshowto.blogspot.com/2009/11/installing-sharepoint-2010-windows-2008.html