The problem is i need to perform this query about 85 times because the value '1001' is different for each entry. What is the right way of typing this SQL query to accomplish the above without having ...
Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...