Not sure I'd go the extra mile to bring them to tears, but I'd jump at the chance to just be rude for a million bucks...why, you recruiting for someone?
I would suggest not storing it directly in a table...images and other large binaries tend to negatively impact performance. Instead, store them in another folder (preferably one in the same path as the database), then just store the (relative) path in the database...much quicker to retrieve or...
You may need to cast your host variable to a string representation, since you are concatenating strings together to build your SQL query. Also, make sure you have a leading space in "as Previous_Amount FROM [pensions]" so that the result is something like
SELECT [Previous Amount] * 3 as...
I would think you would need multiple queries for this, since it sounds like the conditions aren't mutally exclusive.
The first one would be the simplest, giving you base counts by column A and would be processed as a cursor. Then for each row of the cursor, you have queries using the current...
I would think you would need multiple queries for this, since it sounds like the conditions aren't mutally exclusive.
The first one would be the simplest, giving you base counts by column A and would be processed as a cursor. Then for each row of the cursor, you have queries using the current...
I would think you would need multiple queries for this, since it sounds like the conditions aren't mutally exclusive.
The first one would be the simplest, giving you base counts by column A and would be processed as a cursor. Then for each row of the cursor, you have queries using the current...
I would think you would need multiple queries for this, since it sounds like the conditions aren't mutally exclusive.
The first one would be the simplest, giving you base counts by column A and would be processed as a cursor. Then for each row of the cursor, you have queries using the current...