|
-
Nov 14th, 2006, 01:34 AM
#1
Thread Starter
Hyperactive Member
[RESOLVED] date comparison [urgent]
i have a view and a procedure. example as following:
--View name : GET_ALL_VIEW
SELECT employee_code,
employee_name,
CONVERT(VARCHAR(10), date_joined, 103) AS date_joined,
FROM table_employee
--Procedure name : GET_SPECIFIC_EMPLOYEE_SP
--Parameter fields : @DateFrom DATETIME, @DateTo DATETIME
SELECT *
FROM GET_ALL_VIEW
WHERE date_joined => @DateFrom
AND date_joined =< @DateTo
I cant get the records i wan, pls help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|