MS SQL >> SQL Abfrage als DTS Paket

[Leuselator]

Stimmt:

SQL-Code:

SELECT article
       , COUNT(article)    AS Auftraege
       , SUM(DISTINCT qty) AS Prints
    FROM etikett_positions
   WHERE creation >= dbo.fx_EncodeDate(Datepart(Year ,GETDATE()), // hier war creation Unsinn
                                       Datepart(Month,GETDATE()),
                                       Datepart(Day  ,GETDATE())-1,
                                       18,0,0,0)
     AND creation <= GETDATE()
GROUP BY article

SQL-Code:

  SELECT article
       , COUNT(article)    AS Auftraege
       , SUM(DISTINCT qty) AS Prints
    FROM etikett_positions
   WHERE creation >= dateadd(hh,18,round(convert(float,getdate()-1),0,1)) // und hier auch
     AND creation <= GETDATE()
GROUP BY article

Gruß