Viewing 5 posts - 1 through 5 (of 5 total)
For those interested it was also posted at www.dbforums.com/sybase
From the other threads
and
It seems all you really need is a crostab query?
April 29, 2009 at 6:57 am
karthikeyan (5/14/2008)
3) Will concatenation in WHERE clause affect the performance ?Again i think 'Yes'.
The way you use it - Yes, it can't use the index
This is OK
where col...
May 16, 2008 at 5:24 am
michael.rogers (5/15/2008)
WHERE Month(o.READING_DATE) = @StatusDateMonth and Year(o.READING_DATE) = @StatusDateYear
Functions on a column (READING_DATE) will prevent an index from being used and as your data grows your query will become slower...
May 16, 2008 at 12:24 am
select ymonth from(
select
'Jan' union all select
'Feb' union all select
'Dec')f(ymonth)
order by convert(datetime,'1 '+ymonth+' 1900')
-- OR --
select ymonth from(
select
'1' union all select
'2' union all select
'12')f(ymonth)
order by...
January 2, 2008 at 3:56 am
Viewing 5 posts - 1 through 5 (of 5 total)