Comments by krishnaraosan

krishnaraosan 7-Mar-19 2:15am View

Hi i havent tried iam new to c#.

krishnaraosan 7-Mar-19 2:14am View

Hi i havent tried iam new to c#.

krishnaraosan 8-May-18 2:38am View

i need to join with master table for all accounts not only for one account

krishnaraosan 13-Dec-17 2:41am View

In table i have rows

AccountNo Remarks Month
Q49457 Abandoned 10
Q49457 Abandoned 11
Q49457 Locked-2 9
Q49458 Locked 11
Q49458 Abandoned 10

Now i want Output based on accountno month wise as below

AccountNo 11 Month 10 Month Remarks 9 Month Remarks
Q49457 Abandoned Abandoned Locked-2
Q49458 Locked Abandoned

krishnaraosan 13-Dec-17 2:06am View

I have not used any query i am expecting query from you

krishnaraosan 24-Nov-17 0:23am View

SO HOW CAN I GET RECORDS FOR NULL VALUES AND QUARTERLY IN ONE QUERY

krishnaraosan 24-Nov-17 0:13am View

Iam using same query in the where condition it's not getting records for null values.I can fetch records when frequency is quarterly but not for null values.

select * from MASTER
where FREQUENCY=(CASE WHEN FREQUENCY IS NULL THEN 'MONTHLY' ELSE 'Quarterly' END)

krishnaraosan 23-Nov-17 23:52pm View

I have column name frequency where it consists value null and Quarterly

FREQUENCY--Column Name
NULL
Quarterly

Please find the query below.
I want to fetch records for both null value and quarterly.With the below query only null values records are fetched not quaterly

select * from MASTER
where FREQUENCY=(CASE WHEN FREQUENCY IS NULL THEN 'MONTHLY' ELSE 'Quarterly' END)

krishnaraosan 23-Nov-17 6:49am View

I have column name frequency where it consists value null and Quarterly

FREQUENCY--Column Name
NULL
Quarterly

Please find the query below.
I want to fetch records for both null value and quarterly.With the below query only null values records are fetched not quaterly

select * from MASTER
where FREQUENCY=(CASE WHEN FREQUENCY IS NULL THEN 'MONTHLY' ELSE 'Quarterly' END)

krishnaraosan 23-Nov-17 6:06am View

YES NULL VALUES ARE THERE .
I WANT QUERY WHEN VALUE IS NULL IT SHOULD SHOW AS mONTHLY or Quarterly in where condition to flter

Comments by krishnaraosan (Top 10 by date)