Hello,

I need to create a Stored Procedure, which has the SELECT and INSERT command.

Using Stored Procedure, I need to SELECT a record from table "tblClient" and INSERT it into "tblShipping".

Any Help..
Any Idea...
Will really be appriciated....

Thank you

__________________
Zeeshan Dar
itHighway
Get in Touch with People Texting your Website
Advanced Real Estate Listings Solution - FREE Hosting

The following syntax will work:

INSERT INTO tablename (columnaname1, columnname2, columnname3) SELECT columnaname1, columnname2, columnname3 FROM tablename2
WHERE ...

Scott

Is this how sql statement work in stored procedure??????

Yes!!! For example:

CREATE TABLE [dbo].[table1](
[col1] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[col2] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[table2](
[col1] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[col2] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO

INSERT INTO table1 (col1, col2) VALUES ('value1', 'value2')
INSERT INTO table1 (col1, col2) VALUES ('value3', 'value4')
INSERT INTO table1 (col1, col2) VALUES ('value5', 'value6')
INSERT INTO table1 (col1, col2) VALUES ('value7', 'value8')
GO

CREATE PROCEDURE [dbo].[tempstoredproc]
    -- Add the parameters for the stored procedure here
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    INSERT INTO table2 (col1, col2) SELECT col1, col2
    FROM table1

END
GO

exec tempstoredproc
GO

SELECT * FROM table2
GO