Multiple Checking In SQL tables

Question

0.00/5 (No votes)

See more:

I have two tables as follows

1.ItemCode(string),ItemName(string),and some more field called ItemMaster.
2.ItemCode(string),BranchName(string),Qty(int) and .... called Stocks

I want to retrieve the data from second table if the Branch and "ItemName" are correct.

Am not passing "ItemCode" field my search field is ItemName. how I can achieve this. please help me to find solution

in itemcode case I write the storedproc

SQL

Alter Procedure ItemShow 
 @BranchName varchar(20) = NULL,
 @ItemCode varchar(20) = NULL
 As
 Begin
SELECT Distinct StockInBranches.ItemCode,StockInBranches.BranchName,StockInBranches.Price,StockInBranches.Qty
		
	FROM StockInBranches 
Inner Join ItemMaster On
   StockInBranches.ItemCode= @ItemCode
 WHERE StockInBranches.BranchName=@BranchName 
 End

how to write in itemname case? please check.

Posted 9-Dec-14 20:48pm

tastini

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2014-12-09T20:53:00

Solution 1

try

SQL

ELECT Distinct StockInBranches.ItemCode,StockInBranches.BranchName,StockInBranches.Price,StockInBranches.Qty

    FROM StockInBranches
Inner Join ItemMaster On
   StockInBranches.ItemCode= ItemMaster.ItemCode 
 WHERE StockInBranches.BranchName=@BranchName and (@ItemCode is null or StockInBranches.ItemCode = @ItemCode)

if you only need to pass BranchName only then

SQL

ELECT Distinct StockInBranches.ItemCode,StockInBranches.BranchName,StockInBranches.Price,StockInBranches.Qty

    FROM StockInBranches
Inner Join ItemMaster On
   StockInBranches.ItemCode= ItemMaster.ItemCode 
 WHERE StockInBranches.BranchName=@BranchName

Posted 9-Dec-14 20:53pm

DamithSL

Updated 9-Dec-14 20:58pm

v2

Comments

tastini 10-Dec-14 2:55am

Here I am going to pass the ItemCode value for @ItemCode?

DamithSL 10-Dec-14 2:56am

you can pass null value if you don't have value for ItemCode

tastini 10-Dec-14 2:57am

But I want to pass ItemName value instead of ItemCode.

DamithSL 10-Dec-14 2:59am

check my update

tastini 10-Dec-14 3:03am

still , please check my doubt , I have two tables, first table having itemcode and itemname and second table having only itemcode and branch. I want to retrieve data from second table if the search matches "itemname and branch" here am not passing itemcode. what I write that's not correct procedure.

dhineshmca.g 10-Dec-14 4:45am

dwwdqw

dhineshmca.g 10-Dec-14 4:45am

dqwdqwdqw

dhineshmca.g 10-Dec-14 4:45am

qwfFEFE

dhineshmca.g 10-Dec-14 4:45am

WWsfasfsfasf

dhineshmca.g 10-Dec-14 4:46am

fqeqwefe

dhineshmca.g 10-Dec-14 4:46am

qwedadsf

dhineshmca.g 10-Dec-14 4:46am

sdfasfdsafdas