StoredProcedure to return records based on condition in SQL Server

skp

SOLVED CLOSED ACTIVE ANSWERED
User: skp
Posted: on Sep 16, 2019 01:32 AM
Forum: SQL Server
Answer: 2
Views: 1679

I have table consisting of two columns; one is empid and other is currencyid

currency id values are 1 and 2; 1 means inr symbol and 2 means dollar symbol

empid 1 has only access to currency id 2 and empid 2 has access to both currency ids 1 & 2.

Stored procedure must return currencyid or currencyids based on empid as well in web api.

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

Andrea

0 1

Reply
ANSWER
User: Andrea
Replied: on Sep 16, 2019 01:32 AM
Report

Hi @skp, Please try the following Execute StoredProcedure by passing parameter value same as column name in SQL Server It might help you. Cheers Andrea.

pandeyis...

0 2

Reply
ANSWER
User: pandeyism
Replied: on Sep 16, 2019 03:53 AM
Report

Hi skp,

Refer below sample query.

SQL

CREATE PROCEDURE sp_CheckCurrency
@empid INT
AS
BEGIN
IF (@empid = 1)
	BEGIN
		SELECT * FROM tblCheckCurrency
		WHERE currencyid = @empid
	END
ELSE
	BEGIN
		SELECT * FROM tblCheckCurrency
	END
END

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

StoredProcedure to return records based on condition in SQL Server

Company

Explore

Follow us

Contact Us