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-11-23 : 17:37:42
|
| HI,I Have got a select query. I want to MIKTAR colomn fit the data. but I don't it.MIKTAR= IF TUR='SI' THEN MIKTAR IF TUR='SA' THEN MIKTAR IF TUR='FA' THEN SA.MIKTAR-SI.MIKTAR IF TUR='DA' THEN FA.MIKTAR + DA.MIKTAR(Previos DA.MIKTAR,EXAMPLE; 1. 1. WEEK 2.WEEK------- -------SI=1000 SI=2000SA=600 SA=1200 FA=-400 FA=-800DA=400 DA= 400(previos DA) + (-800) )---------------------SELECT TUR,I_NAME=ITEMS_NAME,W1=SUM( CASE HAFTA WHEN 1 THEN MIKTAR ELSE 0 END ),W2=SUM( CASE HAFTA WHEN 2 THEN MIKTAR ELSE 0 END ),W3=SUM( CASE HAFTA WHEN 3 THEN MIKTAR ELSE 0 END ),W4=SUM( CASE HAFTA WHEN 4 THEN MIKTAR ELSE 0 END )FROM(SELECTTUR=TUR,HAFTA=HAFTA,ITEMS_NAME=TMP.ITEMS_NAME,MIKTAR= ????????????????????????FROM(SELECT TUR='SI',MIKTAR FROM KAP_SIPARISUNIONSELECT TUR='SA',MIKTAR FROM KAP_SAYIMUNIONSELECT TUR='FA',MIKTAR FROM KAP_FARKUNIONSELECT TUR=DA',MIKTAR FROM KAP_KUMULE ) TMP) tmp2GROUP BY TUR,ITEMS_NAMEORDER BY I_NAME,TUR DESCthank you |
|
|
|
|
|
|
|
SELECT