A bit of a general question but curious for all opinions.
I have a Crystal Report I am re-engineering into SSRS 2008.
The Crystal Report has a large 'IF' condition that checks two character department field and then converts the value to a 20 character description.
Clearly this could have been provided better from the data source but I am not allowed to change it.
So I have to do the conversion on my SQL select statement or within an expression.
I'm curious, which is the better practice for performance or does it really make a difference and it's just down to personal preference and/or where the most processing power is available?.
The query only returns 500 odd rows but reads big tables.
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.
I have a Crystal Report I am re-engineering into SSRS 2008.
The Crystal Report has a large 'IF' condition that checks two character department field and then converts the value to a 20 character description.
Clearly this could have been provided better from the data source but I am not allowed to change it.
So I have to do the conversion on my SQL select statement or within an expression.
I'm curious, which is the better practice for performance or does it really make a difference and it's just down to personal preference and/or where the most processing power is available?.
The query only returns 500 odd rows but reads big tables.
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.