Post reply

convert TSQL expression into SSRS expression

  • June 5, 2012 at 2:25 pm

    #259115

    Can anyone convert this TSQL expression into SSRS expression

    As I don't know which functions work in ssrs as in TSQL

    UPPER(REPLACE(SUBSTRING(@trustee, CHARINDEX('\', @trustee) + 1, LEN(@trustee) + 1), '.', ' '))

    Example:

    Declare @trustee varchar(max)

    set @trustee = 'RASHING_houl\wddi.masdf'

    select UPPER(REPLACE(SUBSTRING(@trustee, CHARINDEX('\', @trustee) + 1, LEN(@trustee) + 1), '.', ' '))

    Thanks,

    Komal

  • June 8, 2012 at 4:32 am

    #1498624

    Why not do this at source and utilise in the SSRS dataset?

    gsc_dba

  • June 8, 2012 at 4:42 am

    #1498629

    komal145 (6/5/2012)

    Can anyone convert this TSQL expression into SSRS expression

    As I don't know which functions work in ssrs as in TSQL

    UPPER(REPLACE(SUBSTRING(@trustee, CHARINDEX('\', @trustee) + 1, LEN(@trustee) + 1), '.', ' '))

    Example:

    Declare @trustee varchar(max)

    set @trustee = 'RASHING_houl\wddi.masdf'

    select UPPER(REPLACE(SUBSTRING(@trustee, CHARINDEX('\', @trustee) + 1, LEN(@trustee) + 1), '.', ' '))

    Try:

    UCASE(REPLACE(MID(@trustee, InStr('\', @trustee) + 1, LEN(@trustee) + 1), '.', '')) as opposed to

    UPPER(REPLACE(SUBSTRING(@trustee, CHARINDEX('\', @trustee) + 1, LEN(@trustee) + 1), '.', ' '))

    l

    gsc_dba

Viewing 3 posts - 1 through 2 (of 2 total)

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