Dedirahman Sianturi

I can do everything through Him who gives me strength

Archive for June, 2009

Define Field In Virtual Table Using SQL Server 2005

June 28th, 2009

We can define the field of Virtual table in SQL Server 2005. There are some requisite when define the field of the virtual table.And this case include inserting the content of the real table to that virtual table, they are:

- The amount of the field in virtual table must same with the selected field on the real table

- The data type of each field in virtual table must same with the real table

This is the example:

Step 1:

Let us create table [Employees_TEST] , insert the content of that table from existing table. [Employees] table as the sample

create_table_employees_test

Step 2:

Create virtual table #Employees_Temp and Insert data to that table from table [Employees_TEST]

create_virtual_table

1 comment »

Posted in SQL Server

Tags: SQL Server 2005 Using Virtual Table

Use Virtual Table In SQL Server 2005

June 27th, 2009

This is the simple way to insert data from one table to another virtual table. Maybe this way will help you when makes query.

create

No comments »

Posted in SQL Server

Tags: SQL Server 2005

My Reporting Service Problem In Excel Output

June 13th, 2009

My client complain to me about his report result when he export the report to excel.I use reporting service to create the report and the project is Accounting Project. My report result vexes my client because in the report result there are merged cells in the Excel ouput.

This merged cell can be the big problem for him because this project is Accounting Project. He can not sorting his data and sum his data appropriately.So I must render the merge cell.

Here the solutions that I have, I solve the problem from this link.

1. When you design your report with reporting service make sure the left and and the right edges of all reports item line up with another