Return multiple results from Stored Procedure in Sql Server

guhanant...

SOLVED CLOSED ACTIVE ANSWERED
User: guhananth
Posted: on Jan 30, 2022 10:41 PM
Forum: SQL Server
Answer: 1
Views: 1447

Hi,

In stored procedure i have

CREATE  PROCEDURE PRICING(
@companyid BIGINT,
@asdate datetime = null,
@version bigint = null)
as
set nocount ON
DECLARE @tmphistory TABLE(

)
THEN QUERIES. 
LIKE THAT  MULTIPLE TABLES
THEN QUERY BELOW

On executing stored procedure i am getting multiple tables. i need to read specific columns values in each declare table

Download FREE API for Word, Excel and PDF in ASP.Net

RahulYad...

0 4

Reply
ANSWER
User: RahulYadav
Replied: on Feb 02, 2022 02:52 AM
Report

Hi Guhananth,

Please refer below sample.

SQL

DECLARE @Customers_CustomerId TABLE(CustomerId INT)
DECLARE @Customers_Name TABLE(Name VARCHAR(100))
DECLARE @Customers_Country TABLE(Country VARCHAR(50))
DECLARE @CustomerId INT = 1

INSERT INTO @Customers_CustomerId  
SELECT CustomerId FROM Customers
WHERE CustomerId = @CustomerId
 
INSERT INTO @Customers_Name
SELECT Name FROM Customers
WHERE CustomerId = @CustomerId
 
INSERT INTO @Customers_Country
SELECT Country FROM Customers
WHERE CustomerId = @CustomerId

SELECT * FROM @Customers_CustomerId 
SELECT * FROM @Customers_Name 
SELECT * FROM @Customers_Country

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Return multiple results from Stored Procedure in Sql Server

Company

Explore

Follow us

Contact Us