Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Issue with update statement RE: Issue with update statement

  • September 19, 2017 at 5:25 pm

    #1960061

    mcfarlandparkway - Tuesday, September 19, 2017 5:17 PM

    Example  -

    ReportID     path
    101           /DEV/Reports/DEV/Reports/FOlderName/ReportName1
    210           /DEV/Reports/DEV/Reports/FOlderName/ReportName2
    303            /DEV/Reports/DEV/Reports/FOlderName/ReportName3
    404            /DEV/Reports/DEV/Reports/FOlderName/ReportName4

    Like this i have total 70 reports that have incorrect path
    I need to update to the correct path like this below

    ReportID     path
    101           /DEV/Reports/FOlderName/ReportName1
    210           /DEV/Reports/FOlderName/ReportName2
    303            /DEV/Reports/FOlderName/ReportName3
    404           /DEV/Reports/FOlderName/ReportName

    Looks like a simple replace:  replace(path,'/DEV/Reports/DEV/Reports','/DEV/Reports')