How do I put a function within a function?

[Tarzan613]

select month(ord_date),(select daysinmonth(month(ord_date))
from ord
where ord_date>'1/2/02'
group by month(ord_date)

returns this error

Server: Msg 8120, Level 16, State 1, Line 3
Column 'ord.ORD_DATE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

daysinmonth is a user defined function that returns the number of working days in a month.

 

[tlbroadbent]

All columns in the select list must eaither be in the Group By clasue or be part of an aggregate function. You don't need the Select to get the results of the daysinmonthfuncition.

select
Mnth=month(ord_date),
DaysInMnth=daysinmonth(month(ord_date))
from ord
where ord_date>'1/2/02'
group by
month(ord_date),
daysinmonth(month(ord_date)

Alternate: Use an aggregate function
(MAX, MIN, SUM, etc.)

select
Mnth=month(ord_date),
DaysInMnth=MAX(daysinmonth(month(ord_date)))
from ord
where ord_date>'1/2/02'
group by
month(ord_date) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.