Database

private static SqlDataReader executeQuery(String query) {
    SqlCommand command = new SqlCommand(query, Connection);
    SqlDataReader reader;
    try {
        openConnection();
        reader = command.ExecuteReader();
        return reader;
    } catch {
        throw;
    } finally {
        //connection left open because the reader is worked on elsewhere.
    }
}

CREATE LOGIN [bim] WITH PASSWORD=N'*******', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
EXEC sys.sp_addsrvrolemember @loginame = N'bim', @rolename = N'dbcreator'
CREATE USER [bim] FOR LOGIN [bim] WITH DEFAULT_SCHEMA=[dbo]
CREATE TABLE [dbo].[ReportGroups]

ALTER procedure [dbo].[usp_InsertManyRows]

@XMLDOC xml

AS
declare @xml_hndl int 

exec sp_xml_preparedocument @xml_hndl OUTPUT, @XMLDOC

Insert Into outputfiles
            (

            Processid

            )

Select 

            Processid

From
            OPENXML(@xml_hndl, '/Process/ProcessId')
            With
                        (

                        Processid int '/Process/ProcessId'

                        )

exec usp_InsertManyRows '<Process><ProcessId>8712</ProcessId><ProcessId>14444</ProcessId></Process>'

"SELECT COUNT(*) FROM current"