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.
| Author |
Topic |
|
cragi
Starting Member
14 Posts |
 Posted - 2005-11-25 : 13:15:15
|
| I have a SQL2K/VB.NET05 -based website that uses a complex search query, whose results will contain additional logic to be evaluated. There are thousands of records and growing, so it is not feasible to code this within the program...it must be evaluated inline or after the query, and it is also not feasible to set up additional fields and tables to handle the logic.For a very general example: In the .NET code, the following variables are recognized:sex="M"Paid=4350.00Outstanding=28000.50 One of the query result fields will contain the additional logic to evaluate and another will tell the type of expression..EVAL EXPRBOOL Sex='F' and Paid/Outstanding < 27.50BOOL Sex='M' and Paid/Outstanding < 38 or Sex='F'INT Paid*52.33In other words..the thousands of records being returned have their own additional logic to evaluate. Is there a way this can be done by importing the variable into SQL server and testing it during the query?If not, is there a way that I can run the code in the middle of .NET? I know I could run scripted code while in ASP, but ASP.NET is compiled, so I dont know if it can be done there.... |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-26 : 05:01:06
|
| Can you just convert them into appropriate syntax to tag onto the WHERE clause?Kristen |
 |
|
|
|
|
|
how to evaluate logic output from a query