How to get creole language

Question

Post reply

How to get creole language

krypto69

SSChampion

Points: 13604

June 24, 2022 at 5:05 pm

#4054506

I need to update a report to show the month name in the specific language - creole.

I use the function below which uses sys.syslanguages table.

I need the month names for creole now but this table does not have Creole.

Is it safe to update this system table and Creole?

Any ideas?

Thank you.

ALTER FUNCTION pec.[fn_GetMonthName] (

    @Date DATETIME,

    @Language NVARCHAR(100)

)

RETURNS NVARCHAR(400)

AS

/*

Sample:

SELECT pec.fn_GetMonthName (GETDATE(), 'Spanish') + ' ' + CAST(DAY(GETDATE()) AS CHAR(2)) + ', ' + CAST(YEAR(GETDATE()) AS CHAR(4)) AS DateInSpanish

*/




BEGIN

    DECLARE @i INT, @m INT,@mlist NVARCHAR(1000)

    SET @m = MONTH(@Date)

    SET @mlist = (SELECT months FROM sys.syslanguages WHERE ALIAS = @language)

    SET @i = 1

    WHILE(@i < @m)

        BEGIN

           SET @mlist = REPLACE(@mlist, SUBSTRING(@mlist,1,CHARINDEX(',',@mlist)) ,'')

           SET @i = @i + 1

        END

    SET @mlist = (CASE CHARINDEX(',',@mlist) WHEN 0 THEN @mlist ELSE SUBSTRING(@mlist,0,CHARINDEX(',',@mlist) ) END )

    RETURN @mlist

END

GO

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ratbak Ten Centuries Points: 1382 More actions · Answer 1

No, don't mess w/ the system table.

Just use your own table, function, or hard-coded case statement for Creole -- or other unsupported languages (don't use a comma-delimited list -- use a separate row for each month to avoid the loop) when language is Creole -- e.g.,

CREATE TABLE dbo.CreoleMonths
    (
    MonthNumber INT NOT NULL PRIMARY KEY,
    MonthName VARCHAR(100) NOT NULL
    );

if language  = 'Creole'
    begin 
        SET @mlist = (SELECT MonthName FROM dbo.CreoleMonths WHERE MonthNumber = @m);
    end
else
    begin
        -- current logic
    end

krypto69 SSChampion Points: 13604 More actions · Answer 2

krypto69

SSChampion

Points: 13604

June 24, 2022 at 6:25 pm

#4054518

thanks sir - kinda figured that !

Jeff Moden SSC Guru Points: 1004412 More actions · Answer 3

krypto69 wrote:

thanks sir - kinda figured that !

Heh.. I wouldn't use the "current logic"... it uses some pretty slow RBAR. Use DelimitedSplitN4K, instead.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

krypto69 SSChampion Points: 13604 More actions · Answer 4

lol..yeah I've heard bad things about current logic

googles ' DelimitedSplitN4K'....oh cool. Thanks Jeff!

ratbak Ten Centuries Points: 1382 More actions · Answer 5

Use DelimitedSplitN4K, instead

I started to suggest STRING_SPLIT until I noticed 2014. Definitely DelimitedSplitN4K over that loop.

krypto69: Is that function call only used once for a title, or are you using it in rows? If multiple rows, you should also consider refactoring it into an ITVF (inline table-valued function).