PDA

View Full Version : SelectSQL Template


paulykonikara
04-17-2006, 12:57
Hi All,

I am using wM IS6.1 and SQL Server.
Is it possible to apply group by clause to SelectSQL template?

Your response would be grealty appreciated.

-Pauly

castropb
04-18-2006, 08:36
Pauly,

Looks like for a GROUP BY clause, you'd have to use CustomSQL or DynamicSQL template. Doesn't seem to be doable with the SelectSQL template.

- Percio

rmg
04-18-2006, 10:44
Pauly,

Basically in that case you have to use customSQL template and specify your query with groupby clause.but standard selectSQL template doesnt have that option.

HTH,
RMG