HnD | INSERT INTO using SELECT, Page 1

INSERT INTO using SELECT

Posts

Marcus
User

Posts: 747
Joined: 23-Apr-2004

# Posted on: 30-May-2005 12:59:50

Frans,

Is there any support for the following? I can't find any reference to it.

INSERT INTO MyTable  (PriKey, Description)
       SELECT ForeignKey, Description
       FROM SomeView

Marcus

Otis
LLBLGen Pro Team

Posts: 39928
Joined: 17-Aug-2003

# Posted on: 30-May-2005 13:51:59

No, sorry, there's no support for that.

Frans Bouma | Lead developer LLBLGen Pro

Marcus
User

Posts: 747
Joined: 23-Apr-2004

# Posted on: 30-May-2005 13:52:50

No problem... stored procedure will do. Thanks