Re: SQL Union issue, detail records returned when condition not satisf

> For example, the year 2005 has SUM(Service) = 4000. The total / SUM row
is
> not displayed since the having clause is not satisfied, but the detail
> records are still returned.
>
> Any suggestions or insights is greatly appreciated.

Several points

1) What database is this (and service pack)?
2) It could possibly be a bug in the database, have you checked to see
whether you are running the latest service pack?
3) If this SQL Server you might want to raise this in
microsoft.public.sqlserver.programming. DDL is usually required.

Stephen Howe


.

Relevant Pages

  • Re: create database fatal error
    ... CREATE DATABASE statement i run the catalog.sql and catproc.sql scripts. ... sysaux datafile ... This clause is optional, as is the DATAFILE clause of the ...
    (comp.databases.oracle.server)
  • Re: Applying SP on SQL Cluster (active/passive) after new nodes Ad
    ... Senior Database Administrator ... Microsoft SQL Server MVP ... service pack is running. ... > us either since many of the app IDs are db_owner in their database. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Crosstab query and report
    ... I download your example database called CrossTab.mdb. ... >> report I am using. ... It also contains some VBA code which I do understand. ... >> Duane, If I remove the where clause, the report runs great. ...
    (microsoft.public.access.reports)
  • Re: Selecting Rows in groups
    ... to write stored procedures ... solid data architecture ... determining the types of database calls - chunky or chatty. ... Builds the Select clause for the query based on the data ...
    (microsoft.public.sqlserver.programming)
  • Re: Selecting Rows in groups
    ... to write stored procedures ... solid data architecture ... determining the types of database calls - chunky or chatty. ... Builds the Select clause for the query based on the data ...
    (microsoft.public.sqlserver.programming)