????

I'm kinda confused...

The code I provided include the following line:

ELSE ISNULL(@RunningBalance,Current_Stock) * PurchaseDaysAge

Based on your sample code you didn't assign a inital value to @RunningBalance.

So, in case of runbalance (or...

gah (7/18/2010)

---

LutzM (7/18/2010)

---

Hi gah,

GREAT JOB!!!!

As far as I can see, this solution will work.

I would make two changes:

#1: you need to cover the scenario where your stock is less than...

:blush: apologies Jeff...and the...

LutzM (7/18/2010)

---

Hi gah,

GREAT JOB!!!!

As far as I can see, this solution will work.

I would make two changes:

#1: you need to cover the scenario where your stock is less than the...

Hi Lutz

well having done some homework....I have a solution, but would appreciate any feedback on how to improve it.

For new readers this is SQL 2000 and the necessary code is...

Door Hinge.....;-)

Hi Lutz

Thanks for the link....several useful ideas for me to consider.

As always, the devil is in the detail, and I am sure you will appreciate that the example I gave...

In order to accommodate all the different reporting requirements based on a single date...I tend to build a calendar table in Excel...using the date functions/calc cols and fill down abilities.

very...

Strong words indeed...would you care to elaborate....maybe some examples.

..

Is the variable a result from an earlier task in the job or something else..perhaps a...

Hi

you may like to read some of the links pointed out in this recent thread

http://www.sqlservercentral.com/Forums/FindPost783876.aspx

Hi the following link may help:

http://sqlfool.com/2009/08/getting-started-with-variables-in-ssis/

SELECT YourDate

FROM YourTable

WHERE (DATEPART(yyyy, YourDate) = @Enter_Year)

just an idea...and no doubt already in place, buts how's your Disaster Recovery model looking?

John Rowan (9/2/2009)

---

Are you using the Merant driver for Progress? If so, Merant is a third party vendor right? Contact them instead of Progress. By the way,...