How to get creole language

Question

Post reply

How to get creole language

krypto69

SSChampion

Points: 13591

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: 1328 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: 13591 More actions · Answer 2

krypto69

SSChampion

Points: 13591

June 24, 2022 at 6:25 pm

#4054518

thanks sir - kinda figured that !

Jeff Moden SSC Guru Points: 1003851 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: 13591 More actions · Answer 4

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

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

ratbak Ten Centuries Points: 1328 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).