So, on a given day, the value per item is the weighted average of the purchase prices of all the purchase entries prior minus the weighted average price of all...

If the DLL is .net, you can use .net reflector to grab the source code and recompile it for x64. Be carefull doing this in case the original code...

In VS2005, you can create a new database project, which will allow you to create and debug test scripts. You can step into the sql stored procedure code this...

I do not have any problem exporting reports w/ images to excel... Do you have service pack 2 installed? I believe sp2 fixed some issues with the export...

two concatenating two nvarchar(max) variables will result in one nvarchar(max) string.

If you use varchar instead of nvarchar, you will get an extra 4000 characters, but the overall issue still remains.

Again, I don't know what requirements led to your decision to use dynamic sql, but a stored procedure will give you much better performance and security even if you have...

I doubt I'm saying anything not contained in that document, but my first impulse is to tell you not to use dynamic sql.

Depending on what you're trying to do this...

Use modulo.

=23 Mod 3