not sure if this can help (the query is pretty big)

Declare @d1 date, @i tinyint;

set @i = 1;

set @d1 = case when EOMONTH(GETDATE()) > Getdate() then eomonth(getdate(), -1) else eomonth(getdate())...

I used a while loop and got all the dates with 6 grids. How can I append all these results in the while loop one after another or in one...

Thank you for the inputs. I did get the results in a different way. I pulled the rates first and then added the credit and debit account accordingly and it...

yes..I need the largest value among the 3 values and display either a Credit or Debit (+/-).

That is not true in all the cases.

Online 14 of the excel sheet I have 2 negative values and a 'zero'. It compared and calculated the highest among the...

Sorry, for not posting the sample data. Here is some sample data attached. I have issues only when the comm2 has negatives values and comm1 & comm3 are 'Zeros'. I...