alex wrote:
> I am creating this view:
>
> create view
> pfw_19_rsybtest_h
> as
> select
> (
> convert(varchar(4),datepart(yy,sybtest.mydate))
> || '-'
> || convert(varchar(2),datepart(mm,sybtest.mydate))
> ) sybdate
>
> from sybtest
> group by sybdate
>
>
> Without the "group by" clause the view works well, returning the dates
> as "2005-12" "2006-1" ... (i want to be able to group by months)...
>
> But with the group by clause, i get the following error:
>
> Column 'sybdate' specifies storage type 0, which does not currently exist.
>
>
> I've tried using convert against the returned value...
>
> eg: convert(varchar(255),....) sybdate
>
> ... but the result is the same.
>
> any tips for getting this done?
>
> thanks.
> alex.

GROUP BY is used to group the results of an aggregating function
such as summing or averaging values for a group. You are not
doing that in your query.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)