Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Advice for table design to save Job Requirement

Author  Topic 

Idyana
Yak Posting Veteran

96 Posts

Posted - 2014-08-12 : 00:29:50
Hi,

This is my requirement
1- I need to store information about Vacancy
2- This is vacancy have REQUIREMENT

3- This REQUIREMENT like a expression as following

a) Age ( = , >=, <=, between )
b) Qualification ( AND, OR)
c) Working Experience ( = , >=, <=, between )

How my table looks like to store the expression?

As a result, I can query efficiently in my Stored Procedure.

Need help

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-08-12 : 08:49:21
Need more information!

Please post an example of how you would use this expression in a SP
Go to Top of Page
   

- Advertisement -