SelectSQL Template

paulykonikara · April 17, 2006, 11:27pm

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

Percio_Castro · April 18, 2006, 7:06pm

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

gupta_r.17495 · April 18, 2006, 9:14pm

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