I want to create a SQL Select query with calculated fields to show a Trend column
Posted on 2014-08-22
I am just creating a SQL query using sql server 2012. I want to convert my data for a SSRS report. my sql is not great hence why I am asking the question. I believe and easy answer? I am creating a report and rather than do the calculated field in the ssrs report (which I believe would cause more overhead/performance decrease) I want to create a trend column in the SQL select query.
I will need to cast first. The values are stored as varchar. They will only be whole numbers however. but maybe Nulll.
I want to compare two columns. e.g. Table1.ColumnA and table2.ColumnB.
The output I want is weather it is positive, negative, no change or no previous value.
or if easier. a whole number which shows either positive/negative/zero or Null.