crookj (12/13/2013)

---

Fickle...

Well with a little tinkering here is what I came up with:

;with C_Orders_CTE (conum, itemnum, coitemstat) as (

select conum

, itemnum

,...

Code solutions depends on a number of things. First, it would be helpful to see the actual table descriptions.

Second, I'd want to know the scope of record volumes, in...

You are closing your cursors in the wrong order. You need to close the UsernameCursor within the outer while loop (DATABASENAMEC).

Interesting side note, I've never had...

Services

To answer your initial question, the @mesg_out was not declared within the scope of the SQL you are creating dynamically. You need to declare @mesg_out inside the quoted SQL.

To...

ScottPletcher (12/10/2013)

---

For performance reasons, it would almost certainly be better to have a trigger on the Calculations table that automatically identified and saved all variables used in a normalized table...

Have you considered creating a UDF that returns a table of index values in the formula?

Kurt

how many "formulas" need to be processed?

OK, so what the approach I'd use would be to create a table variable or temp table that contains all of the indexes and associated values found in the "formula"....

The next question I'd want an answer is; how many entries in #CalculationVariables? Based on that would drive the logic.

Kurt

The way I'd approach this would to start by talking out loud the logic. What you are doing is assembling an expression then executing it. It is kind...

lager

I found this article that may help you out.

http://stackoverflow.com/questions/17361097/sql-server-2008-r2-arithmetic-overflow-error-converting-numeric-to-data-type-num

What are you doing to manage the transaction log? If your database is in Full recovery mode you should have a job that performs a transaction log backup.

Also would...