pls try the following with your own scenario/funtionality needs.

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

Cross-Tab Reports

Sometimes it is necessary to rotate results so that columns are presented horizontally and rows are presented vertically. This is known...

Take a look of this information, which I think might be useful to you. Please read and try to implement with the same methodology listed overhere.

http://msdn2.microsoft.com/en-us/library/ms189858.aspx

take look of this example.....

http://database.ittoolbox.com/groups/technical-functional/sql-server-l/group-by-datetime-field-431215

you can do so by means of Using the Copy Database Wizard. plz browse the following link and try to implement according to your own functionality needs.

http://technet.microsoft.com/en-us/library/ms188664.aspx

rush thru this link...

http://www.sql-server-performance.com/tips/query_analyzer_p1.aspx

browse through this link.

http://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid87_gci1204201,00.html

plz mak uze of the followin link.

http://www.sql-server-helper.com/functions/get-date-only.aspx

plz mak uze of the following link....

http://www.databasejournal.com/features/mssql/article.php/3691721

Following user defined function returns number of weekdays between two dates specified. This function excludes the dates which are passed as input params. It excludes Saturday and Sunday as they...

plz go through the following code instructions. I think this will work for you.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

In the SQL Server 2005, after you create a SSIS package ( DTS), you want to create...

The easiest way of restoring a database is by means of using database publishing wizard. The feature of using this wizard, is it will carry both schema & data of...

This is due to space constraint issue. If you open the Enterprize Manger, you can able to see the respective databases goes into (SUSPECT) mode. Please ensure that you have...

What Makes you to shift from NA to DBA? You have the edge of experience on your own skill and moving on to the other area is in some other...

I potentially see a true DBA person should have atleast 2+ years of SQL programming experience (either worked on Client server environment/web based) application development by pro-actively helping/involving the sub-teams...