Audit package details in using Stored procedure

Where [dbo].[PDV_Insert_PDV_Audit_Package] =Name of the SP

      PDV_Audit_Package is Table name where we are storing audit details.

Create Procedure [dbo].[PDV_Insert_PDV_Audit_Package]

(

      @ParentPackageID UniqueIdentifier, 

      @ParentPackageName NVarchar(50),   

      @PackageID UniqueIdentifier,

      @PackageName NVarchar(50),

      @Host NVarchar(50),

      @ExecutionStatus Varchar(20),

      @ExecutionID Varchar(14)

) As

Begin

      Set NoCount On

     

      Insert PDV_Audit_Package

            (

                  ParentPackageID,

                  ParentPackageName,

                  PackageID,

                  PackageName,

                  Host,

                  ExecutionStatus,

                  ExecutionID,

                  PackageExecutionTime

            )

      Values

            (

                  @ParentPackageID,

                  @ParentPackageName,

                  @PackageID,

                  @PackageName,

                  @Host,

                  @ExecutionStatus,

                  @ExecutionID,

                  GETDATE())

End

substract string from column in sql

SELECT eventname
 ,CASE 
  WHEN charindex('vs', eventname) > 0
   THEN rtrim(SUBSTRING(eventname, charindex('vs', eventname) + 3, len(eventname)))
  END Away_Team
 ,replace(replace(eventname, CASE 
    WHEN charindex('vs', eventname) > 0
     THEN rtrim(SUBSTRING(eventname, charindex('vs', eventname), len(eventname)))
    END, ''), SUBSTRING(replace(eventname, CASE 
     WHEN charindex('vs', eventname) > 0
      THEN rtrim(SUBSTRING(eventname, charindex('vs', eventname), len(eventname)))
     END, ''), 0, PatIndex('%[0-9]%', replace(eventname, CASE 
      WHEN charindex('vs', eventname) > 0
       THEN rtrim(SUBSTRING(eventname, charindex('vs', eventname), len(eventname)))
      END, '')) + 2), '') Home_Team
--SUBSTRING(replace(eventname,case when charindex('vs',eventname)>0 then 
--rtrim(SUBSTRING(eventname,charindex('vs',eventname),len(eventname))) end,''),0,PatIndex('%[0-9]%',
--replace(eventname,case when charindex('vs',eventname)>0 then 
--rtrim(SUBSTRING(eventname,charindex('vs',eventname),len(eventname))) end,''))+2)
FROM tablename

where eventname  is a column name