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
 SQL Server 2000 Forums
 Transact-SQL (2000)
 display

Author  Topic 

dass05555
Yak Posting Veteran

55 Posts

Posted - 2008-03-18 : 05:30:26
dear gurus,

how to display the data without creating a table.

thanks in advance,
dass

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2008-03-18 : 05:42:08
what do you mean? be specific i guess. :-)




For fast result follow this...
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

Want Philippines to become 1st World COuntry? Go for World War 3...
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-03-18 : 06:56:33
quote:
Originally posted by dass05555

dear gurus,

how to display the data without creating a table.

thanks in advance,
dass





Select 1 as number
union all
select 10



Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -