none
Need Help with Error message

    Question

  • I'm using Report Server from SQL 2012, and have set up the below stored procedure between to unrelated tables, but when executing it, I get the following error:

    Operand type clash: text is incompatible with date

    I'm thinking that I need to convert the dates, but not sure how or where in the code... any help would be appreciated.

    The SP code is:

    GO
    ALTER Procedure [dbo].[spDailyTripReport]
    
    (
    	 @Start	date,
    	 @Visit date
    )
    AS
    SELECT 
    	CompanyName,
    	PointContact,
    	city,
    	DateCreated
     from Clients
    where DateCreated = @Visit
    Union
    Select 
    	date1,
    	num_places,
    	city,
    	notes
     from Trip
    where date1 = @Start;


    Jill Trehearne

    Monday, July 01, 2013 7:24 PM

Answers

All replies