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? 

sure.

A quick script?

ditto

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

@AccountNo Varchar(40),

@StartDate Varchar(10),

@EndDate Varchar(10),

@Lang char(2)

AS 

SELECT CustomerNo, First_Name, Last_Name, 

Year, Make, Model,

DelDate, 

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

ELSE 

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!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s