Viewing 8 posts - 1 through 8 (of 8 total)
Sorry, the number is an integer, not a date.
I have a column which has month no's in it, I want to convert them to corresponding month names.
October 19, 2005 at 7:39 am
I shall attempt to describe what I'm trying to achieve, if anyone's interested:
October 7, 2005 at 8:34 am
I totally agree, its wrong design, but I am trying to replicate what someone is doing in Excel using Pivot tables. Once I've got this working, I'll probably re-design the tables...
October 7, 2005 at 2:46 am
its OK Ken, I've figured out how to do this by using temporary tables and looping thru records
thanks for your help anyway........
October 6, 2005 at 9:36 am
sorry, Material2_Loss should say 20 -9 15
(170-150), (151-160), (185-170)
October 6, 2005 at 5:36 am
The table looks like this
Description ProductA ProductB ProductC etc
Material1_Used 100 150 60
Material1_Produced 90 140 70
Material2_Used 150 160 170
Material2_Produced 170 151 185
etc etc
The desired results would be
Descritption ProductA ProductB ProductC
Material1_Used 100...
October 6, 2005 at 5:34 am
sorry, I forgot to say, the Remote database is on a seperate server.
September 28, 2005 at 10:30 am
Thank you Remi, that was a great help, just one more question, is there any way of simplyfying the following rather long-winded statement to produce the desired results:
Select left('00',2-len(DATEPART(hh, Date1)))
+...
August 22, 2005 at 9:56 am
Viewing 8 posts - 1 through 8 (of 8 total)