Viewing 10 posts - 16 through 25 (of 25 total)
What about patritioned view , can u help me on that?
..Better Than Before...
It Seems to be better one,Jonathan !
..Better Than Before...
It might be ok if the quary is as follows:
select distinct datename(month,a.productiondate)+'-'+ datename(year,a.productiondate)as Date, a.productiondate
into ##newtable
from tblDailyConsumption a
order by a.productiondate
select distinct Date from ##newtable
However , Thx all for...
..Better Than Before...
ray_higdon
One problem here boss!
It is showing unexpected ans for data
2003-07-03
2003-07-09
2003-09-26
2003-10-27
That is :
July-2003
July-2003
September-2003
October-2003
...
..Better Than Before...
Thx ray_higdon
It is working...
..Better Than Before...
quote:
How about:select datename(month,productiondate)+'-'+ datename(year,productiondate)
from tblmytable
group by datename(month,productiondate)+'-'+ datename(year,productiondate)
HTH
Ray Higdon MCSE, MCDBA, CCNA
May be you...
..Better Than Before...
quote:
How about:select datename(month,productiondate)+'-'+ datename(year,productiondate)
from tblmytable
group by datename(month,productiondate)+'-'+ datename(year,productiondate)
HTH
Ray Higdon MCSE, MCDBA, CCNA
May be you...
..Better Than Before...
no, I have to find only distinct year and month only not date ...
..Better Than Before...
Viewing 10 posts - 16 through 25 (of 25 total)