Viewing 3 posts - 1 through 4 (of 4 total)
Just refer this link
http://support.microsoft.com/kb/325335....
June 21, 2013 at 12:16 am
#1626212
SELECT *
FROM @Client cl
JOIN @ValidDates vd
ON 2=2
where cl.ValidDate BETWEEN vd.StartDate AND vd.EndDate
Anything we give same value for on condition......
June 18, 2013 at 5:56 am
#1624972
select substring(ename,charindex(':',ename)+1,len(ename)) from emp
The charindex start from "0".......:-)
June 18, 2013 at 5:45 am
#1624968