Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Grouping by a function
Thanks Rac2 for taking the time to answer my question, I tried your suggestion and unfortunately it didnt work, the error message told me "Name expected". I wrote the code GROUP BY c.SUR_NAME, {fn MONTHNAME(a.SCV_DATE)}, {fn MONTHNAME(a.SCV_DATE)} and also GROUP BY c.SUR_NAME... -
Grouping by a function
Hi everyone, I work at a hospital and I need to aggregate data into months I am trying to Group some data by a month and year function, the code is below However the database wont let me, it keeps telling me I need to name my coloums, Ive tried doing this about 10 different ways with no luck eg... -
Has anyone come across U/SQL and Date Functions
Can anyone please help? I have just inherited a big headache. I have a Corvu database running of a language called U/Sql, I've never heard of it, nor anyone I know. The only literature I can find says it is similar to ANSI SQL. My problem is I desperately need a date function that returns data...
