I Need A Query

[peterlaursen]

I have moved your post to a more appropriate categoy.

This question is outside the scope of our product support as it is a general SQL question.

But what is the problem? Do you get an error (and which one then?) when creating the routine, does the calculation render incorrect results? In case of error try identify *where* the error occurs (run queries one by one in the editor and not wrapped in a Stored Procedure.

Also if you want help with such case you should provide a smaller and more readable test case (use the option to add CODE tags around tabular datasets etc.). Once you have reduced the test case you may also very well be able to identify the problem yourself. And alos to make it simpler for people you ask for help you should provide importable SQL dump of table structures and data.

[Author]

Posts