Forum: MS SQL  May 21st, 2008 |
| Replies: 3 Views: 1,393 Thanks for reply.
I did it this way:
SELECT * FROM Results
WHERE STID=111 AND (CASE WHEN (ISNUMERIC(ActualValue)=1) THEN CAST(ActualValue AS FLOAT) ELSE 0 END) NOT BETWEEN LowerLimit AND... |
| Forum: MS SQL May 20th, 2008 |
| Replies: 3 Views: 1,393 Hi All,
SELECT * FROM Results WHERE ActualValue NOT BETWEEN Lowerimit AND UpperLimit
In my query ActualValue is VARCHAR field. How can I get Results that are out of limit?
Shrinivas |
| Forum: MS SQL Sep 26th, 2007 |
| Replies: 0 Views: 805 Hi,
I've installed Reporting services developer. When I browse Reports folder in IIS, I get:
The request failed with HTTP status 400: Bad Request.
error. What's the reason? Can anyone help... |
