How CR call view/temp table? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

SQL Server 6.5 \ SQL Server 7.0

How CR call view/temp table?

Author

Topic

siktui82
Starting Member

8 Posts

Posted - 2007-06-25 : 05:28:38

I wish to create a view in SQL to create a temp table to store data. How do i use CR to create report to pull out the data?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-25 : 06:07:20

Not clear what exactly you want. A view is just a SELECT query, it can not be used to create a temp table.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-25 : 06:11:36

Create view and then use that View as datasource to CR. Dont create temp table

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-25 : 06:13:49

Also read about Create View in sql server help file

Madhivanan

Failing to plan is Planning to fail

siktui82
Starting Member

8 Posts

Posted - 2007-06-27 : 22:12:44

The issue was i tried to update data from 2 table.

table 1

COLUMN 1 COLUMN 2
A 1
B 2
C 2

table 2
COLUMN A COLUMN B COLUMN C
A G H
C B P

when i do select table1.column1,table2.columnb,table2.column3 from table1 inner join table2 on table1.column1=table2.column2 Notice that B result will not show in the result. How do i make it to show up?

Thanks.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-28 : 09:19:41

Use left outer join

Madhivanan

Failing to plan is Planning to fail

siktui82
Starting Member

8 Posts

Posted - 2007-06-28 : 21:20:04

Thanks for the help. able to get the report right

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources