never mind about part I added ... View more

  Hi Thank you for help                                      ... View more

Thank you ... View more

This is what I am trying to do T1.Count1 is a char value and I am trying to convert to Num. I thought if I assign the new name count can work as show below:   CREATE TABLE AUTO.QUERY_FOR_BUS_DAY AS SELECT t1.'Active_Messages'n, t1.'Total_Active_Messages'n, t1.Aging, Count =input(t1.Count1, 4.), t1.'Age_Date'n, t1.'Report_Date'n,   ... View more

Thank you ... View more

thanks question I see you use to select statement would tell me what the second one will do? ... View more

thanks for your respond I did not explain what happing with my data 1) I have this data that has weekeday from (monday --- Fri... 2,3,4,5,6,). i did replace sat and sun weekdays (1and 7) with Monday(2) which I do not wanted sat sun in my report but I want the sum of the count and total activity been shown for Moday. Same for BusDay for example Active_Messages    Total_Active_Messages    Age_Date    Count    Week_Day    BusDay QUEUE:1            3            3/17/2017    3    6        1 QUEUE:1            3            3/16/2017    2    5        2 QUEUE:1            3            3/15/2017    1    4        3 QUEUE:1            3            3/14/2017    4    3                   4 QUEUE:1            3            3/13/2017    1    2        5 QUEUE:1            3            3/12/2017    2    2        5 QUEUE:1            3            3/11/2017    3    2        5 after calculation shoud be  here I don't wanted SUN AND SAT QUEUE:1            9            3/13/2017    6    2        5 I thought if I use case where week_days =2 then sum(count ) as count                                                        max(Week_days)                                                         max(BusDay) .........  some how did not work.. ANY Advice QUEUE:1            3            3/10/2017    1    6        6 QUEUE:1            3            3/9/2017    2    5        7 QUEUE:1            3            3/8/2017    3    4        8 QUEUE:1            3            3/7/2017    2    3        9 QUEUE:1            3            3/6/2017    0    2        10 QUEUE:1            3            3/5/2017    1    2        10 QUEUE:1            3            3/4/2017    1    2        10 SAME HERE . . . ... View more