Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DENIZ3E
Yak Posting Veteran
56 Posts |
 Posted - 2005-02-22 : 17:31:59
|
| HIWEEKS1,2,3,4,....53 A TABLE -------TUR DUEDATE BEGDATE VIOL QUANTIY--- ------- --------- ----- --------TOMATO 25.03.2005 02.01.2005 100 1500BIBER 15.02.2005 01.01.2005 200 2000 .... .... .....DATEPART(WW,DUEDATE)=WEEK DUEDATEDATEPART(WW,BEGDATE)=WEEK BEGDATESAYI=QUANTIY/VIOLI WANT TO convert DUEDATE,BEGDATE TO WEEK AND SUM(QUANTIY/VIOL) WITH SAME DUEDATE,SAME VIOLSUM(QUANTIY/VIOL) WITH SAME BEGDATE,SAME VIOL,WEEK 1 WEEK 2 ..... WEEK 53------- ------ ------ -------SUM(SAYI) 'DUEDDATE'SUM(SAYI) 'BEGDATE' |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-22 : 18:14:18
|
| Huh? Could you explain in words what you want to do?Tara |
 |
|
|
|
|
|
SELECT