HI, I have two columns A, B and C for which the sample
data is below.
Basically I need to get only those columns in a single
output table in my stored proc where the value in columns
A and B for currentperiod has doubled since previousperiod.
So in this case, I will need a output with only
Column A since the figures have doubled in current period
as compared to previous period.
Can any one please give me that TSQL ?
A B C
200 400 Currentperiod
100 300 Previousperiod