if @fromDate = Datetime.MinValue
BEGIN
set @fromDate = (select MIN(applicant_statuss.created_on) from applicant_statuss)
end

if @toDate = Datetime.MinValue
BEGIN
set @toDate =GETDATE();
end

the following error is Comeing :

Msg 107, Level 16, State 2, Procedure sp_InterviewerPerformance, Line 21
The column prefix 'Datetime' does not match with a table name or alias name used in the query.
Msg 107, Level 16, State 2, Procedure sp_InterviewerPerformance, Line 26
The column prefix 'Datetime' does not match with a table name or alias name used in the query.

Recommended Answers

All 3 Replies

what is Datetime in your code ?

what is Datetime in your code ?

bulit in datatype in sql

then what does Datetime.MinValue returns ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.