<div>
Thanks Jim, so what I did was to insert into the Stored procedure the new column as advised.<br />
<br />
Thanks for your help.
</div>


Thanks Jim, so what I did was to insert into the Stored procedure the new column as advised.

Thanks for your help.

<div>
Thank Jim for your help. really appreciate
</div>


Thank Jim for your help. really appreciate

<div>
<div class="content wysiwyg-content">
I don't want to use a temp table. I want the information from the store procedure to go to a table I have created. The store procedure only generates 5 columns but I have added a date column and another column that requires update from time to time. So want am trying to do is to make the stored procedure to fill in the date column with a getdate()/date and time of when the stored procedure was ran and update the other column with the new information entered from the application
</div>
</div>


I don't want to use a temp table. I want the information from the store procedure to go to a table I have created. The store procedure only generates 5 columns but I have added a date column and another column that requires update from time to time. So want am trying to do is to make the stored procedure to fill in the date column with a getdate()/date and time of when the stored procedure was ran and update the other column with the new information entered from the application

0 down vote favorite INSERT INTO Test EXEC p4_Proc

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Golang, also called Go, is an open source programming language that is a statically-typed language with syntax loosely derived from C, adding automatic memory management, type safety, some dynamic-typing capabilities, additional built-in types such as variable-length arrays and key-value maps, and a large standard library. Go is a general-purpose systems programming language that aims to be efficient both for development and execution with a focus on fast compilation and increased maintainability of large projects. Go was originally targeted at systems programming tasks such as building server/web applications, high throughput middleware and databases.