Ok. I got it working with your help. Thanks so much TG. Learn something new every day. I knew you could alias the tables, but didnt know you could do it with columns, too.
Working code below in the event any one else is having this issue and looking for an answer.
Code:
ALTER PROCEDURE [dbo].[SP_ObtainTicketInformation]
@TicketNumber AS INT,
@RMANumber AS INT,
@StoreNumber AS INT,
@TicketStatus AS VARCHAR(16),
@CreatedBy AS VARCHAR(250),
@DateFrom AS DATETIME,
@DateTo AS DATETIME
AS
SET NOCOUNT ON
BEGIN
SELECT T.TicketID, T.TicketStatusID, T.StoreNumberID, T.RMANumber, T.DateCreated, T.CreatedBy, T.DateLastModified, T.DateResolved,
       TS.TicketStatusID, TS.TicketStatus, 
       SN.StoreNumberID, SN.StoreNumber, 
       C.TicketAuthors AS CreatedByUser,
	   M.TicketAuthors AS ModifiedByUser
FROM [TICKETMANAGER].[dbo].[Tickets] AS T
INNER JOIN [dbo].[StoreNumbers] AS SN
ON SN.StoreNumberID = T.StoreNumberID
INNER JOIN [dbo].[TicketAuthors] AS C
ON T.CreatedBy = C.UsersID
INNER JOIN [dbo].[TicketAuthors] AS M
ON T.LastModifiedBy = M.UsersID
INNER JOIN [dbo].[TicketStatus] AS TS
ON TS.TicketStatusID = T.TicketStatusID
WHERE T.TicketID = @TicketNumber
OR T.RMANumber = @RMANumber
OR T.StoreNumberID = @StoreNumber 
OR T.TicketStatusID = @TicketStatus
OR C.UsersID = @CreatedBy
OR T.DateCreated BETWEEN @DateFrom AND @DateTo AND T.DateResolved IS NOT NULL
AND T.LastModifiedBy = M.UsersID
END