Viewing 6 posts - 1 through 6 (of 6 total)
yey hey,
cheers guys,
Thanks, the *-1 was the easiest to implement in my script, thanks a lot.
March 22, 2007 at 8:34 am
mmm, I was unaware this could happen,
would it be better to create and update a table where I have the first view ?
If so how do I get it to...
March 21, 2007 at 3:26 am
Just a thought.......
Will the month-? take the date calculations past the year end ?
What I mean is if the Date calculation is minus 3 months where the GETDATE() month is 2...
March 20, 2007 at 8:53 am
Hi,
thanks, I used the Cast ((<expresion> AS Int) to sort it out
Cheers,
Craig
March 20, 2007 at 8:41 am
Hi,
we can use either the TrnMonth or DATEPART the Entry date as they are the same data source in the tables used to create the original view.
I just thought it...
March 20, 2007 at 7:56 am
Hi,
thanks for the replies, I want to go back 12 months from current to effectively give a rolling 13 months we can report to our suppliers, performance over the last...
March 20, 2007 at 7:26 am
Viewing 6 posts - 1 through 6 (of 6 total)