How to create a Temporary Table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to create a Temporary Table

I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI|
===================================================
1000| Sales | -20,000.00 | 01 | 2005
===================================================
1000| Sales | -10,000.00 | 02 | 2005
===================================================
1001| Cost | 5,000.00 | 01 | 2005
===================================================
1001| Cost | 5,000.00 | 02 | 2005 the fields above have the following datatype: Fields | Datatype
===================================
GL_ID | Integer
GL_Name_VC | Variable Character
Amount | Integer
Period_TI | TinyInteger
Year_SI | SmallInteger The above database is running on Microsoft SQL Server 2000 and i would like to query
for a report that looks something as below: Description | Period 01 | Period 02 | Year to Date
=========================================================
Sales | 20,000.00 | 10,000.00 | 30,000.00
Total Sales | 20,000.00 | 10,000.00 | 30,000.00 Cost | 5,000.00 | 5,000.00 | 10,000.00
Total Cost | 5,000.00 | 5,000.00 | 10,000.00
=========================================================
Profit | 15,000.00 | 5,000.00 | 20,000.00 The above report would list 4 columns, with the last column being a calculated field as a sum of
Period01 + Period02 Amount, sorted by GL_ID and group under a summation row called
Total Sales & Total Cost.There would be a net amount appearing as Profit (Total Sales-Total Cost). Guys, hope someone out there can help me with the sql command for the above report?
Sure. Besides what I already mentioned in other responses, take a look at create table statement in BOL and also temporary table topic.
It seems that all of your questions are based on same information Select * into #temp from othertable You need to make use of sql server help file Madhivanan Failing to plan is Planning to fail
]]>