My SP wont except an english date format I havent come across this before with my store procedures they have been accepting english date formats now for months - e.g. 13/12/2008
alter procedure [dbo].[spWDReportMedicalHi
story]
@strClientName varchar(50),
@dtmWellnessDate datetime,
@empFirstName varchar(50),
@empLastName varchar(50)
as
Begin
SELECT tblWellness.strMedicalHist
ory
FROM tblWellness INNER JOIN
tblOhperaEmployees ON tblWellness.fkEmp = tblOhperaEmployees.uidCase
Employee INNER JOIN
tblClients ON tblWellness.fkClient = tblClients.uidClient
WHERE
(tblWellness.dtmWellnessDa
te = CONVERT(DATETIME, @dtmWellnessDate, 103)) AND (tblClients.strClientName LIKE @strClientName + '%')
AND (tblOhperaEmployees.strLas
tName LIKE @empLastName + '%')
AND (tblOhperaEmployees.strFir
stName LIKE @empFirstName + '%')
End
Start Free Trial
