Looping through a table 1

[ice78991]

I have a function called get_bikes which creates and returns a table of BikeIDs in a column called bike
In my stored procedure, I want to insert this data into a new table called BikeOwners with 2 columns OwnerID and BikeID

In my stored procedure I have tried things like

INSERT INTO BikeOwners
(OwnerID,
BikeID)
VALUES
(@Owner,
SELECT bike from getbikes(DEFAULT))

But it's not working. What should I be doing ?

 

[ca8msm]

I don't know why you've created a function to return a table. Can you provide the code for the function, and the sql code to create both the tables in question?



-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[gmmastros]

Try this....

INSERT 
INTO   BikeOwners
       (OwnerID, BikeID)
Select @Owner, bike 
from   dbo.getbikes(DEFAULT)

There are 2 formats for inserting data.


Insert Into Table(Columns) Values(data)


Insert Into Table(Columns) Select columns From SomeOtherTable



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[ice78991]

Thanks. That's fixed it