Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Contributor
2340 Points
424 Posts
Sep 14, 2008 01:34 PM|LINK
SELECT Companyname, role, Location, date FROM callcenter where Location Like '%' + @city + '%' and DATEDIFF(Day, postdate, getdate( ) ) <= @datediff and Role IN (Fresher,Vp-operations)
anonymouswri...
Contributor
2340 Points
424 Posts
Re: problem in pattern matching..
Sep 14, 2008 01:34 PM|LINK
SELECT Companyname, role, Location, date FROM callcenter where Location Like '%' + @city + '%' and DATEDIFF(Day, postdate, getdate( ) ) <= @datediff and Role IN (Fresher,Vp-operations)