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