Viewing 15 posts - 2,326 through 2,340 (of 2,452 total)
????
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 19, 2010 at 9:31 am
gah (7/18/2010)
LutzM (7/18/2010)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 18, 2010 at 1:09 pm
Jeff Moden (7/18/2010)
gah (7/18/2010)
also a sincere thanks to Jeff Modem for his articleIt's actually spelled "Moden" but I'll take the compliment. 🙂 Thanks, Graham.
:blush: apologies Jeff...and the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 18, 2010 at 1:06 pm
LutzM (7/18/2010)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 18, 2010 at 10:30 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 18, 2010 at 8:14 am
Door Hinge.....;-)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 17, 2010 at 2:08 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 16, 2010 at 11:59 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 16, 2009 at 12:17 pm
rf44 (9/10/2009)
This is one of the most arrogant, presumptuous and unfounded assertion I ever read.
Strong words indeed...would you care to elaborate....maybe some examples.
..
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 10, 2009 at 2:32 pm
knight (9/4/2009)
I'm trying to pass a variable between the tasks in a job.
Is the variable a result from an earlier task in the job or something else..perhaps a...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 8, 2009 at 6:06 am
Hi
you may like to read some of the links pointed out in this recent thread
http://www.sqlservercentral.com/Forums/FindPost783876.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 8, 2009 at 3:43 am
Hi the following link may help:
http://sqlfool.com/2009/08/getting-started-with-variables-in-ssis/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 5, 2009 at 11:01 am
SELECT YourDate
FROM YourTable
WHERE (DATEPART(yyyy, YourDate) = @Enter_Year)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 4, 2009 at 4:50 am
just an idea...and no doubt already in place, buts how's your Disaster Recovery model looking?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 3, 2009 at 12:38 pm
John Rowan (9/2/2009)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2009 at 10:39 am
Viewing 15 posts - 2,326 through 2,340 (of 2,452 total)