SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Translation
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sue70
Starting Member

United Kingdom
3 Posts

Posted - 09/21/2012 :  14:16:47  Show Profile  Reply with Quote
Hi all,

I am trying to write test cases for the following rules but they are a bit confusing. Please help. The rules are as follows:

RULE 1: If the lower range rule is ‘Less Than’ or ‘Less Than or Equal’ and an upper range rule is entered the criteria will effectively read:
Lower Value <= value OR Upper Value ……


RULE 2: If the lower range rule is ‘Equal’, ‘Greater Than’ or ‘Greater Than or Equal’ and an upper range rule is entered the criteria will effectively read
Lower Value >= value AND Upper Value ……

Many thanks in anticipation of your help.

Sue

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 09/21/2012 :  14:26:14  Show Profile  Reply with Quote
so is lower range parameter a text based field?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 09/21/2012 :  14:28:11  Show Profile  Reply with Quote
Are you trying to write rules in SQL, or are you trying to develop test cases (before writing them in SQL or some other language)?

Can you post some examples of what you have tried, even if they are not complete or correct?
Go to Top of Page

Sue70
Starting Member

United Kingdom
3 Posts

Posted - 09/22/2012 :  07:50:35  Show Profile  Reply with Quote
quote:
Originally posted by sunitabeck

Are you trying to write rules in SQL, or are you trying to develop test cases (before writing them in SQL or some other language)?

Can you post some examples of what you have tried, even if they are not complete or correct?



Yes I am trying to develop test cases for the front end of a report and convert this test cases into SQL Queries for the back end validation of an application, However, because the developer is on vacation I am unable to confirm what these rules mean. For starters, I need help with the interpretation of the rules and secondly need help for how to write the sql queries.

My interpretations of the rules are as follows:

RULE 1: Does that mean that report will be generated for <= value OR Upper Value (1 set of report: EITHER/OR)


FOR RULE 2: Does that mean that report will be generated for <= value AND Upper Value (2 sets of reports: 'AND')


The information I gave above is a functional requirement of a report for a system used in finding the totals of aggregate score, Lower and Upper score of pupils performance that met a certain criteria when the report is run.
E.g Upper Score = 360, Lower Score= 118 some of the test cases I have written are as follows:

Rule 1( 118 <= OR Upper Value 360)meaning 118<=0R 360
Rule 2( 118>= AND Upper Value 360) meaning 118>=AND 360

I HOPE I have made a bit of sense, any help will be appreciated.




Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 09/22/2012 :  08:52:42  Show Profile  Reply with Quote
Hard to say what the rules mean without knowing the business requirements. But, the way it is written, for example Lower Value <= value OR Upper Value it seems what they mean is that the report will be generated for:

a) values less than or equal to the Lower Value (regardless of whether the upper value is provided or not)
OR
b) if there is an upper value (regardless of the value provided)

Go to Top of Page

Sue70
Starting Member

United Kingdom
3 Posts

Posted - 09/25/2012 :  03:56:27  Show Profile  Reply with Quote
Thankssunitabeck for your feedback, Its really appreciated. I will have to clarify the requirement with the Developer

Regards
Sue70


quote:
Originally posted by sunitabeck

Hard to say what the rules mean without knowing the business requirements. But, the way it is written, for example Lower Value <= value OR Upper Value it seems what they mean is that the report will be generated for:

a) values less than or equal to the Lower Value (regardless of whether the upper value is provided or not)
OR
b) if there is an upper value (regardless of the value provided)



Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 09/25/2012 :  07:35:09  Show Profile  Reply with Quote
You are welcome (even though I suspect I was not of much help )
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000