How to check whether values exist in a table

Question

0.00/5 (No votes)

See more:

C#

Sno       From          To     Allotedto
 1         1            150       A
 2         151          249       B
 3         250          500       C
 4         450          459       D

Sno 4 should not allowed in the context because the values 450 t0 459 is present in sno 3 range.How to check these condtion in sql server.

Posted 25-Jul-13 1:59am

Bhagavan Raju M

Updated 25-Jul-13 2:02am

Thanks7872

v3

Add a Solution

Comments

vinayoukuri 25-Jul-13 8:09am

Do you like to select such records or you want to stop inserting such records into table.

Bhagavan Raju M 25-Jul-13 8:12am

@vinayoukuri I want to stop inserting records into table

Maciej Los 25-Jul-13 8:26am

I'm sure that i had posted answer for similar question...

2 solutions

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)

Adarsh chauhan · Accepted Answer · 2013-07-25T02:08:00

Solution 1

Try this..

VB

declare @from int
declare @to int

set @from= 450
set @to= 459


if exists(select * from tableName where ([From]<=@from and [To] >=@from) or ([From]<=@to and [To] >=@to))
print 'Invalid Range'
else
print 'Valid Range'

Posted 25-Jul-13 2:08am

Adarsh chauhan

Updated 25-Jul-13 2:10am

v2

NITDGP2005 · Accepted Answer · 2013-07-25T07:26:00

U can use between statement

SQL

IF EXISTS( SELECT 1 FROM tbl_Range t WHERE  @To BETWEEN t.[From] AND t.[To]
                                              AND  @From BETWEEN t.[From] AND t.[To])
  BEGIN
    print 'duplicate';
  END
 ELSE
  BEGIN
    print 'Not duplicate';
  END

tbl_Range is the table name