REVERSE(LEFT(REVERSE(@myString),CHARINDEX(‘>’,REVERSE(@myString))-1))
Month: October 2010
thanks goes out to the book ‘SQL Cookbook’ – Lucky Chapter 13 Hierarchical Queries … with x (tree,childid,depth) as ( select cast(name as varchar(500)), childid, 0 from vw_users_parent_children union all select cast(x.tree+’–>’+e.name as varchar(500)), e.childid, x.depth+1 from vw_users_parent_children e, x where x.childid = e.children_id )…
Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed. Fixed by: Editing the job by add a leading “” to the package path so that is reads: Maintenance PlansPlanName Steps: Right click the MaintenancePlan under SQL Server AgentsJobs and click…