I have Stored procedure ALTER PROCEDURE [dbo].[ProcSummaryReport]
-- Add the parameters for the stored procedure here
@DepartmentID int,
@FromDateTime datetime,
@ToDateTime datetime
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
select ProjectName,ActivityName,Sum(TotalHour)as TotalHours From ProcesslogReport where DepartmentID=@DepartmentID and Date BETWEEN @FromDateTime And @ToDateTime group by ProjectName,ActivityName
END
When i pass starttime & Endtime in mm/dd/yyyy it show Error String has not valid for datetime, i'm useing MS Sql server 2005, In ProcesslogReport Table Date column in Datetime datatype
please Help
Anil KumarPosted May 22, 2012, 1:00 PM
Secondly, check the datatype of [Date] is datetime. (also always avoid taking this type column name in future)
And also check the culture setting for your MS Sql.