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 |
|
shanish
Starting Member
2 Posts |
 Posted - 2012-03-15 : 01:48:38
|
| I have a query here,I have a table consist of a column 'Marks'. In that marks I've to check whether it is greater than 50 or not. If it is 50 its pass else fail, for this I wrote a query as SELECT MARKS, CASE WHEN MARKS >= 50 THEN 'PASS' ELSE 'FAIL' END AS STATUS FROM TABLENAMEhere I can get the expected result, but the problem is I need to give a parameter as, if I give 0 it shold display only the fail results, and if I give 1 should show only pass, if 2, both fail and pass.........how is it possible can anyone help me |
|
|
shanish
Starting Member
2 Posts |
Posted - 2012-03-15 : 02:10:59
|
| I've to create a report using SSRS, and the query should work in SSRS, can anyone help me |
 |
|
|
|
|
|
sql condition checking