when i try to get only the values which shows 'HIGH' it gives me an error: Converting data type varchar to float.
HOW can i get only the records which are 'HIGH'?
At a rough guess, some of your data in the
If you RTFM at http://msdn.microsoft.com/en-us/library/ms181765.aspx, you'll see that what you are doing with your
OK, it's almost certain to knock back the speed of execution, but if you can't guarantee the quality of the data within the CTE, then it's a way to go.
The alternative is, of course, to put a
answered Sep 18 '11 at 01:09 PM