If CreateTempTableRI_Note(cmd) Then
            If InsertIntoTempTableRI_Note(cmd, SaveType, RI_Note) Then
                'cmd = New SqlCommand(gconSPRotair_RI_Note, New imsDataServices().Connection)
                cmd.CommandText = gconSPRotair_RI_Note
                cmd.CommandType = CommandType.StoredProcedure
                cmd.Parameters.Clear()
                Parameter = cmd.Parameters.Add("@ReturnMessage", SqlDbType.VarChar, 100)
                Parameter.Direction = ParameterDirection.Output
                Parameter = cmd.Parameters.Add("@ReturnCode", SqlDbType.Int)
                Parameter.Direction = ParameterDirection.Output
                mintSPRC = cmd.ExecuteNonQuery
                If mintSPRC = -1 Then
                    If Val(cmd.Parameters(1).Value) = 0 Then
                        Return True
                    Else
                        Return False
                    End If
                Else
                    mstrLastError = cmd.Parameters(0).Value.ToString
                    Return False
                End If
            End If
        End If

        cmd = New SqlCommand("SET NOCOUNT ON", New imsDataServices().Connection)
        'cmd = New SqlCommand
        'cmd.Connection = New imsDataServices().Connection
        If Not TempTableExists(cmd.Connection, gconTempTableRI_Note) Then

            intRC = 0
            strSQL = "SELECT " & _
            [String].Format("{0}", _
            gcontblRI_Note_DeleteBy) & _
            " INTO " & gconTempTableRI_Note & _
            " FROM " & gconTableRI_Note & _
            " WHERE 0 = 1"

        Else

            intRC = -1
            strSQL = "TRUNCATE TABLE " & gconTempTableRI_Note

        End If

        cmd.CommandText = strSQL
        mintSPRC = cmd.ExecuteNonQuery

        If mintSPRC = intRC Then
            Return True
        Else
            Return False
        End If

        strSQL = "INSERT INTO " & gconTempTableRI_Note & _
    " (" & [String].Format("{0}", _
    gcontblRI_Note_DeleteBy,) & ")" & _
    " VALUES (" & gconParameter_Note_DeleteBy & ")"

        cmd.CommandText = strSQL
        With RI_Note
            cmd.Parameters.AddWithValue(gconParameter_Note_DeleteBy, IIf(.Field("DeleteBy") = vbNullString, DBNull.Value, .Field("DeleteBy")))
 
        End With

        If cmd.ExecuteNonQuery > 0 Then
            Return True
        Else
            Return False
        End If

quote:

---

Originally posted by nigelrivett

Is this actually a global temp table or just a temp table?

---

quote:

---

Originally posted by nigelrivett

If a global I suspect it's used because someone thought that it would be available for a query run on another connection. Problem is that it will be dropped as soon as the creating connection is dropped - I suspect the issue is that a second instance is seeing that the table exists, doesn't create and the creating connection is closed and the second connection finds the table has been dropped before it can be used.

---

quote:

---

Originally posted by nigelrivett

Why isn't it a permament table - doesn't seem to be any reason not to be one as it is used as a staging table so the database must be set up. Looks like it is trying to be generic by table but that isn't going to work

---

quote:

---

Originally posted by nigelrivett



It's best to keep things simple if you don't understand how things work and that seems to be the problem - needless complication.
All communication with the server should be by stored procedures and that will prevent attempts at fragile processes like this.

---

quote:

---

Originally posted by Mar
I just want to first point out that I do not like the procedure that we have in place, but my protests have not helped at all.

---