View Single Post
  #1 (permalink)  
Old March 28th, 2006, 06:18 PM
Deepak Chauhan Deepak Chauhan is offline
Registered User
 
Join Date: Mar 2006
Location: FBD, HR, India.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Deepak Chauhan
Default insert multiple records into a table from values

Hi All,

I've quite a strange requirement to insert multiple records into a table.
I have some numbers say 14,32,3,5,7,811,43,45 which i want be inserted into a table T1 with one column N1

but i want all these values to be inserted as different records records in one go without using any looping .

I know this can be done using the INSERT ... SELECT ... Statements.
or slightly different way.

But not sure on how exactly it can be done.

On a slightly different requirement I want a way to get these values in the form of records without using any table.


I mean i need a select statement on the values 1,3,65,22,65,77,33

something like Select * from (1,3,65,22,65,77,33)

and the result be displayed in the form

(No Column Name)
----------------
1
3
65
22
65
77
33

Is it possible.

I know some experts out there can help me do these things.

I will appreciate any help on this

Thanks,
Deepak Chauhan
XpertGuys.com