Select the case when the grouping (date)=1 then 'total' else CONVERT (varchar (10), date, 120) end as a date, sum (quantity) as the number, the sum amount of (amount) as the from TB group by the CONVERT (varchar (7), date, 120), date, name, quantity, amount with rolluphaving (grouping (date)=0 and grouping (name)=0 and grouping (quantity)=0 and grouping (amount)=0 and grouping the CONVERT (varchar (7), date, 120))=0) or (grouping (CONVERT (varchar (7), date, 120))=0 and grouping (date)=1 and grouping (name)=1 and grouping (quantity)=1 and grouping (amount)=1)

The SQL statements in SQL2000 can correct operation, the result is correct, why return a result set in a on the VB program without total line, is how to return a responsibility? Such as modified?

CodePudding user response:

I done. The next eldest sister-in-law have praised me so much.

As saying the building Lord, you put the code with code format, or look at my hair was messy.

CodePudding user response:

In the SQL profiler (named event detector in Chinese?) See what is truly executed SQL tools,

CodePudding user response:

CodePudding user response:

T - SQL syntax and VB6.0 by use of grammar can be the same?

CodePudding user response:

I was performed separately, calculation mainly on application side to do it