Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by JRT76
-
SQL Server bug (Union in subquery)
Forgot to mention that the query works fine if i use a temporary table to store the results from the subquery and use a subquery to reference the temporary table values.- JRT76
- Post #2
- Forum: Microsoft SQL Server: Programming
-
SQL Server bug (Union in subquery)
I have a query where the result doesn't make sense. Please review the query below. If I change Line #4 from demandnumber >= 28500 to 28554 the query result increases from 0 to 30. This is not mathematically possible? The query also perfoms correctly if I remove the 2nd part of the union in...- JRT76
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
