Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to calculate SUBTOTAL/TOTAL on count(*)
Sorry for the late reply... out of office, but the following might work: SELECT A.NAME as name, a.date as date, count(*) as temp, '' as totcount FROM MYTABLE a GROUP BY NAME,DATE union all SELECT A.NAME as name, '' as date, '' as temp, count(*) as totcount FROM MYTABLE a GROUP BY NAME... -
Multi row string concatenation
I am currently struggling with a particularly nasty old DB schema and query set, if anyone can help with resolving the below problem i would be very grateful. The example below is a simplified (Non real) version of the problem. Essentially i have two tables (both fairly normalized) which...
