Create a Table using another table!

Hi,
Sorry to trouble you all, but I am not getting anywhere!
I need to copy the contents of 1 table into a new temporary table. What I am
doing is :
SELECT *
FROM U_regulargiver
WHERE Status ='I'
OR Status ='N'
INTO TABLE #U_T_Committed
Obviously I'm doing something wrong, but I can't seem to figure out exactly
what. Can anyone please help?
Thanks in advance
RobYou screwed up with the syntax:

> SELECT *
> INTO TABLE #U_T_Committed
> FROM U_regulargiver
> WHERE Status ='I'
> OR Status ='N'
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Robert" <Robert@.discussions.microsoft.com> schrieb im Newsbeitrag
news:7BE6CA67-EF93-4A97-8BA7-22220C06E0FA@.microsoft.com...
> Hi,
> Sorry to trouble you all, but I am not getting anywhere!
> I need to copy the contents of 1 table into a new temporary table. What I
> am
> doing is :
> SELECT *
> FROM U_regulargiver
> WHERE Status ='I'
> OR Status ='N'
> INTO TABLE #U_T_Committed
> Obviously I'm doing something wrong, but I can't seem to figure out
> exactly
> what. Can anyone please help?
> Thanks in advance
> Rob
>|||You can get the results you want by writing the statement this way.
Create Table #temp
(
Test nvarchar (10),
Description nvarchar (255)
)
select * from testuser.dbo.MyTable
Insert into #temp
Select *
from testuser.dbo.MyTable
Select * from #temp
Drop table #temp
refer to Books Online for more information if you must use the INTO clause.
"Robert" wrote:

> Hi,
> Sorry to trouble you all, but I am not getting anywhere!
> I need to copy the contents of 1 table into a new temporary table. What I
am
> doing is :
> SELECT *
> FROM U_regulargiver
> WHERE Status ='I'
> OR Status ='N'
> INTO TABLE #U_T_Committed
> Obviously I'm doing something wrong, but I can't seem to figure out exactl
y
> what. Can anyone please help?
> Thanks in advance
> Rob
>

Create a Table of Contents in Reporting Services

Hi,
I need to be able to create a Table of Contents for a Price List
Catalog in Reporting Services. Using the AdventureWorks example report
(Product Catalog.rdl), I need to be able to create something similar to
the following:
Table of Contents
Accessories
Bike Racks 2
Bike Stands 2
Bottles and Cages 3
Cleaners 4
Fenders 4
Helmets 5
Hydration Packs 5
Lights 6
Locks 7
Panniers 7
Pumps 8
Tires and Tubes 8
Bikes
Mountain Bikes 13
Road Bikes 15
Touring Bikes 19
Clothing
Bib-Shorts 22
Gloves 23
Jerseys 24
Shorts 25
etc.
It seems that Reporting Services would have something built into it to
do this since it is similar to the Document Mapping feature, but I have
not been able to locate it. Has anyone out there done this? Or have
any suggestions?
Thanks in advance,
Amy BoldenDoes these values all come from a data set? Then you could give you the
names of the items if you create a table against that dataset, and just show
the categories and subcategories. I'm not sure how you could do the page
numbers, though. In first case, I find that page numbers sometimes get
really mixed up when you save a report to PDF, because it behaves
differently in the browser than in the exported document. Also, I'm not sure
if you can pick up the page numbers that the report renders. You might be
able to do some tricks by counting items in each subcategory and dividing
them by a given number of rows, which would approximately give you the right
page numbers.
Do you have to have the page numbers? If not, you can use Jump to navigation
to jump from the table of contents to any of the items in your report /
catalogue.
Kaisa M. Lindahl Lervik
"Amy" <abolden@.lexington.com> wrote in message
news:1164643397.216130.159050@.j72g2000cwa.googlegroups.com...
> Hi,
> I need to be able to create a Table of Contents for a Price List
> Catalog in Reporting Services. Using the AdventureWorks example report
> (Product Catalog.rdl), I need to be able to create something similar to
> the following:
> Table of Contents
> Accessories
> Bike Racks 2
> Bike Stands 2
> Bottles and Cages 3
> Cleaners 4
> Fenders 4
> Helmets 5
> Hydration Packs 5
> Lights 6
> Locks 7
> Panniers 7
> Pumps 8
> Tires and Tubes 8
> Bikes
> Mountain Bikes 13
> Road Bikes 15
> Touring Bikes 19
> Clothing
> Bib-Shorts 22
> Gloves 23
> Jerseys 24
> Shorts 25
> etc.
> It seems that Reporting Services would have something built into it to
> do this since it is similar to the Document Mapping feature, but I have
> not been able to locate it. Has anyone out there done this? Or have
> any suggestions?
> Thanks in advance,
> Amy Bolden
>