GROUP BY STATEMENT

[#1]

Hi

is group by function  possible  with SQL select statement used while loading the data if yes please help me with the syntax for the same

Thanking You

Vinayagam .

[#2]

[JSTO]:   // Status object information

Load

   [OBJNR] as [OBJNR],

   [STSMA] as [STSMA],

   [OBTYP] as [OBTYP];

SQL Select MAX(OBJNR) as OBJNR STSMA OBTYP  from JSTO

GROUP BY STSMA OBTYP

;

STORE * FROM [JSTO] INTO JSTO.QVD;

DROP TABLE [JSTO];

[MK_QSL]

==========================

OLEDB CONNECT32 TO .......

Load

  Supplier,

  SUM(Quantity) as TotalQty,

  SUM(Amount) as TotalAmount

Group By Supplier;

LOAD

    Supplier,

    Quantity,

    Amount;   

SQL SELECT *

FROM ABC.dbo."TableName";

==============================

Hope this help...