Background: 为繁荣database版,版主提出灌水达到10,000的指标,包括简体中文标题50,000条, 繁体中文标题10,000,英文标题35,000条,其他语言5,000条。 现版主需要报表来根据指标落实情况(progress report)群发包子,及各id的表现( performance)给表现突出的ID发包子. Table: EntityID, Title, Language, UserID, Date Report1: TitleLanguage, Cnt_LastWeek, Cnt_Cumulative, Cnt_%, Cnt_Quote Report2: UserID, Cnt_Entity_LastWeek, Cnt_Cumulative, Cnt_4WeekAvg, Cnt_Avg 目前的解决方案:多次join,每join一次产生一个报表要求的Column(Cnt_x) Select a.TitleLanguage, b.Cnt_LastWeek, ... From ... LEFT JOIN (SELECT TitleLanguage, Count(TitleLanguage) FROM ... WHERE Date >= LastWeekStartDate AND Date <=LastWeekEndDate GROUP BY ...) AS b on a.TitleLanguage = b.TitleLanguage LEFT JOIN (...) c on ... 请教大牛: 有没有其他简单的办法?
d*s
3 楼
wmv to mpeg convert, can anyone recommend good tools ? I downloaded a few tools, but these free tools not allow to convert file of my size, which is about 200 MB. Thanks.