ALTER PROCEDURE dbo.sp_GetAllTicketsPaged
	@CurrentPage int,
	@PageSize int,
	@TotalRecords int output
AS
 --Create a temp table to hold the current page of data
 --Add and ID column to count the records
 CREATE TABLE #TempTable
 (
  ID int IDENTITY PRIMARY KEY,
  Ticket_ID INT,
  Ticket_Author_ID INT,
  Creation_Date datetime,
  Tech_Start_DT datetime,
  Issue varchar (200),
  Part_ID varchar (12),
  Priority varchar (20),
  Status varchar (20),
  NotesPublic varchar (2000),
  NotesPrivate varchar (4000),
  Company varchar (60),
  ContactPerson varchar (60),
  Phone varchar (14),
  eMail varchar (90)
 )
 --Fill the temp table with the Customers data
 INSERT INTO #TempTable 
 (
  Ticket_ID, 
  Ticket_Author_ID, 
  Creation_Date, 
  Tech_Start_DT, 
  Issue, 
  Part_ID, 
  Priority, 
  Status, 
  NotesPublic, 
  NotesPrivate, 
  Company, 
  ContactPerson, 
  Phone, 
  eMail
  )
 SELECT 
    	dbo.Tickets.Ticket_ID, 
    	dbo.Tickets.Ticket_Author_ID, 
    	dbo.Tickets.Creation_Date, 
    	dbo.Tickets.Tech_Start_DT, 
    	dbo.Tickets.Issue, 
    	dbo.Tickets.Part_ID, 
    	dbo.Tickets.Priority, 
    	dbo.Tickets.Status, 
	dbo.Tickets.NotesPublic, 
	dbo.Tickets.NotesPrivate, 
	dbo.TicketAuthor.Company, 
	dbo.TicketAuthor.ContactPerson, 
	dbo.TicketAuthor.Phone, 
	dbo.TicketAuthor.eMail           
 FROM 
    dbo.TicketAuthor FULL OUTER JOIN
                      dbo.Tickets ON dbo.TicketAuthor.Ticket_Author_ID = dbo.Tickets.Ticket_Author_ID
 WHERE 
	dbo.TicketAuthor.Ticket_Author_ID = dbo.Tickets.Ticket_Author_ID  
 RETURN 

 --Create variable to identify the first and last record that should be selected
 DECLARE @FirstRec int, @LastRec int
 SELECT @FirstRec = (@CurrentPage - 1) * @PageSize
 SELECT @LastRec = (@CurrentPage * @PageSize + 1)
 --Select one page of data based on the record numbers above
 SELECT 
    *
 FROM 
    #TempTable
 WHERE 
    ID > @FirstRec 
 AND 
    ID < @LastRec
 --Return the total number of records available as an output parameter
 SELECT @TotalRecords = COUNT(*) FROM #TempTable

            Dim PageSize As Integer = 3
            Dim myConnection As SqlConnection = New SqlConnection(ConString)
            Dim myCommand As SqlCommand = New SqlCommand("sp_GetAllTicketsPaged", myConnection)
            myCommand.CommandType = CommandType.StoredProcedure
            myCommand.Parameters.Add(New SqlParameter("@CurrentPage", SqlDbType.Int)).Value = _currentPageNumber
            myCommand.Parameters.Add(New SqlParameter("@PageSize", SqlDbType.Int)).Value = PageSize
            myCommand.Parameters.Add(New SqlParameter("@TotalRecords", SqlDbType.Int)).Direction = ParameterDirection.Output
            Try
                myConnection.Open()
                DataList1.DataSource = myCommand.ExecuteReader()
                DataList1.DataBind()
            Finally
                myConnection.Close()
            End Try
            CurrentPage.Text = _currentPageNumber.ToString()
            Dim _totalPages As Double = 1
            If Not Page.IsPostBack Then
                Dim _totalRecords As Int32 = CType(myCommand.Parameters("@TotalRecords").Value, Int32)
                _totalPages = _totalRecords / PageSize
                TotalPages.Text = (System.Math.Ceiling(_totalPages)).ToString()
            Else
                _totalPages = Double.Parse(TotalPages.Text)
            End If