Data for my question about Max(LoadingDate)

[pacoli2013]

Hello,

I cannot add DataFiles to my first question about Max(LaadingDate)

So here is some data and a script

Regards

Court

[sunny_talwar]

You were having LoadingDate in your Group By statement.... Try this

LOAD

  Company,

      DataLevel,

      Max(LoadingDate) as LoadingDate,

      SalesOrderNumber,

      Description,

      SalesOrderStatusCode,

      SalesOrderTypeCode,

      LatestConfirmationDate,

      DWHReportingCompCurrencyExchangeRateToCompCurrency

FROM [TrnDat_SalesOrderHdr.qvd] (qvd)

  Group By Company, DataLevel, SalesOrderNumber, Description, SalesOrderStatusCode,

  SalesOrderTypeCode, LatestConfirmationDate, DWHReportingCompCurrencyExchangeRateToCompCurrency;

[pacoli2013]

Thanks Sunny,

So simply, why did't I figure it out by myself.

Perhaps I'm working too long at the same Document and become blind for such little things.

Regards

Court