Stored Procedure to return record from multiple Database Table in SQL Server

irshad12...

SOLVED CLOSED ACTIVE ANSWERED
User: irshad1231
Posted: on Apr 09, 2019 03:00 AM
Forum: SQL Server
Answer: 1
Views: 1780

Dear All,

Can you please check my stored procedure

Getting below error

Invalid object name 'MedicalHL7.dbo.B_Pat_Demog_Info'

create procedure SickLeave_UpdatePatRank
as
BEGIN
    Select Pat_Rank_Type from [MedicalHL7].[dbo].[B_Pat_Demog_Info] WHERE PAT_MR=273236
    SELECT [MRNum] from [FNWorkflow].[dbo].[eF_SickLeave]WHERE MRNum=273236
END

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

dharmend...

0 9

Reply
ANSWER
User: dharmendr
Replied: on Apr 10, 2019 06:48 AM
Report

Hi irshad1231,

Check the below sample query.

Database

For this example I have used of Northwind database and Test database.

You can download Northwind database using the link given below.

Download Northwind Database

Test database have the table Customers with the schema as follows.

I have already inserted few records in the table.

You can download the database table SQL by clicking the download link below.

Download SQL file

SQL

CREATE PROCEDURE SelectMutipleTable
AS
BEGIN
    SELECT TOP 5 CustomerID,ContactName,Country FROM [Northwind].[dbo].[Customers]
    SELECT CustomerID,Name,Country FROM [Test].[dbo].[Customers]
END

Screenshot

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

Stored Procedure to return record from multiple Database Table in SQL Server

Company

Explore

Follow us

Contact Us