Public Function getpreparedTags(con As ADODB.Connection) As ADODB.Command
    Dim pcmd As New ADODB.Command
    
    Set pcmd.ActiveConnection = con
    pcmd.Prepared = True
    
    With pcmd
        .CommandText = ""
        .CommandText = .CommandText & "INSERT INTO Dev.Tags( instrumentcode, instrumentsuff, area, loopnbr, hasbackup, endprojectnbr, ""p&idsection"" )                  " & vbNewLine
        .CommandText = .CommandText & "     SELECT A.instrumentcode, A.Instrumentsuff, A.area, A.loopnbr, A.hasbackup, A.endprojectnbr, A.pid                            " & vbNewLine
        .CommandText = .CommandText & "       FROM ( VALUES( ?, ?, ?, ?, ?, ?, ? )) AS A( instrumentcode, instrumentsuff, area, loopbnr, hasbackup, endproject, pid )    " & vbNewLine
        .CommandText = .CommandText & "  LEFT JOIN Dev.Tags AS T                                                                                                         " & vbNewLine
        .CommandText = .CommandText & "         ON ( A.instrumentcode, A.instrumentsuff, A.area, A.loopnbr ) = ( T.instrumentcode, T.instrumentsuff, T.area, T.loopnbr ) " & vbNewLine
        .CommandText = .CommandText & "      WHERE { T.instrumentcode, T.instrumentsuff, T.area, T.loopnbr ) IS NULL;                                                    " & vbNewLine
        .Parameters.Append .CreateParameter(0, adVarChar, adParamInput, 4)
        .Parameters.Append .CreateParameter(1, adVarChar, adParamInput, 1)
        .Parameters.Append .CreateParameter(2, adInteger, adParamInput, 4)
        .Parameters.Append .CreateParameter(3, adInteger, adParamInput, 4)
        .Parameters.Append .CreateParameter(4, adBoolean, adParamInput, 1)
        .Parameters.Append .CreateParameter(5, adVarChar, adParamInput, 10)
        .Parameters.Append .CreateParameter(6, adInteger, adParamInput, 1)
        End With
    
    Set getpreparedTags = pcmd
  
End Function
