Recent content by krish03

Help needed....any idea......

UPDATE Sheet1 S SET (S.CLT_ID) = (SELECT DISTINCT(R.CLT_ID) FROM NTLRESULTS.SOURCE_INGENIO_TBL R WHERE R.SELLERUSERID = S.SELLERUSERID) WHERE EXISTS (SELECT DISTINCT(R.CLT_ID) FROM NTLRESULTS.SOURCE_INGENIO_TBL...

how to do that

sql query for selecting similar data from column supplier in table1 and table 2 and if data matches then need to pull out client info and user info of those matched ids which are seperate columns form table 1

Sql help SELECT SUM(CASE SYR_CTR_START_MONTH BETWEEN1AND3THEN SYR_SUM_AMZ_INV_AMT ELSE0END) Q1, SUM(CASE SYR_CTR_START_MONTH BETWEEN4AND6THEN SYR_SUM_AMZ_INV_AMT ELSE0END) Q2, SUM(CASE SYR_CTR_START_MONTH BETWEEN7AND9THEN SYR_SUM_AMZ_INV_AMT ELSE0END) Q3, SUM(CASE SYR_CTR_START_MONTH...

SELECT SUM case [SYR_CTR_START_MONTH]=1 then SYR_SUM_AMZ_INV_AMT else 0 end JAN, FROM AZ_SMY_YPC_RPT_TBL WHERE SYR_UPD_USER='EXCEPTION2'; when i run this i get ORA-00923: FROM keyword not found where expected

It says missing expression..........

How to do that...

Are the brackets correctly used

So some thing like this sum (case when [syr_ctr_start_month]=1 then syr_sum_amz_inv_amt else 0 end ) jan

NEED THIS ACCESS QUERY FOR SQL ..LET ME KNOW WHAT CHANGES TO BE MADE..... SELECT SUM(IIf([SYR_CTR_START_MONTH]=1, SYR_SUM_AMZ_INV_AMT, 0)) AS JAN, SUM(IIf([SYR_CTR_START_MONTH]=2, SYR_SUM_AMZ_INV_AMT, 0)) AS FEB, SUM(IIf([SYR_CTR_START_MONTH]=3, SYR_SUM_AMZ_INV_AMT, 0)) AS MAR...

SELECT SUM(IIf([SYR_CTR_START_MONTH]=1, SYR_SUM_AMZ_INV_AMT, 0)) AS JAN, SUM(IIf([SYR_CTR_START_MONTH]=2, SYR_SUM_AMZ_INV_AMT, 0)) AS FEB, SUM(IIf([SYR_CTR_START_MONTH]=3, SYR_SUM_AMZ_INV_AMT, 0)) AS MAR, SUM(IIF([SYR_CTR_START_MONTH] = 4 ,SYR_SUM_AMZ_INV_AMT ,0)) AS APR ...

What if i need that query to run in sql server..wil it work or any changes..

Kk got it..it should be sum(syr_sum_amz_inv_amt) as fy

SUM([SYR_CTR_START_MONTH]) AS FY unable to get the whole amount for year.....