Forum Replies Created
Viewing 10 posts - 16 through 25 (of 25 total)
-
RE: How Create a store procedure from another store procedure
What abot the "table valued function" ?
can u clear it little bit?
-
RE: How Create a store procedure from another store procedure
ok, let it more clear!
I have a view view1 where material receiving information is summarized along with location id ,date and other necessary info
January 11, 2004 at 4:26 am
-
RE: can i pass a parameter to the view of SQLSERVER 2000
What about patritioned view , can u help me on that?
-
RE: How to select distinct month- year order by month-
It Seems to be better one,
Jonathan ! -
RE: How to select distinct month- year order by month-
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...
-
RE: How to select distinct month- year order by month-
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
...
-
RE: How to select distinct month- year order by month-
Thx ray_higdon
It is working...
-
RE: How to select distinct month- year order by month-
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...
-
RE: How to select distinct month- year order by month-
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...
-
RE: How to select distinct month- year order by month-
no, I have to find only distinct year and month only not date ...
Jonathan !Viewing 10 posts - 16 through 25 (of 25 total)