Developers; A Rap on the Knuckles
March 14, 2009
Not painting all with the same brush of course! This is more tongue in cheek 🙂
I know that the new version has different coding requirements than the old version.
But I have a confession – I am not a software coder – can I modify a string or variable here & there?
A quick script?
But when you want the lower level stuff – it may be quicker to actually learn it –
Because if you want me to learn to write the following for you ….
You will be waiting a while
ALTER PROCEDURE dbo.E_ail_FinRew
SELECT CustomerNo, First_Name, Last_Name,
Year, Make, Model,
Convert(Varchar,Term) + ‘ ‘ +
CASE WHEN @Lang = ‘En’ THEN ‘Month ‘ ELSE ‘mois ‘ END +
CASE WHEN @Lang = ‘En’ THEN
CASE WHEN Financing = ‘L’ THEN ‘Lease’ ELSE ‘Finance’ END
CASE WHEN Financing = ‘L’ THEN ‘FR-Lease’ ELSE ‘FR-Finance’ END
END AS FinanceType,
You can subscribe to this blog by clicking the RSS icon on the Home Page!