Need help with count

[kjc]

Is it possible to obtain a count of the number of rows that would
be returned based on the following query.

select tableA.*,
tableB.fieldA,
tableB.fieldB,
tableB.fieldC,
tableC.fieldA,
tableD.fieldA,
tableD.fieldB
from tableA,
tableB,
tableC,
tableD
where
PREDICATES
group by
ALL FIELDS in the select
Thanks in advance.

[Erland Sommarskog]

kjc (ks*****@elp.rr.com) writes:

Is it possible to obtain a count of the number of rows that would
be returned based on the following query.

select tableA.*,
tableB.fieldA,
tableB.fieldB,
tableB.fieldC,
tableC.fieldA,
tableD.fieldA,
tableD.fieldB
from tableA,
tableB,
tableC,
tableD
where
PREDICATES
group by
ALL FIELDS in the select

select COUNT(*)
from tableA,
tableB,
tableC,
tableD
where
PREDICATES
group by
ALL FIELDS in the select

If you only want read the table once you can insert into a temp table,
and check @@rowcount after the INSERT.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[kjc]

Thanks for the reply Erland, but, I tried what you proposed.
What I get back is the number of rows returned by the select
all with the number 1 in each column.

Thanks again.

Erland Sommarskog wrote:

kjc (ks*****@elp.rr.com) writes:

Is it possible to obtain a count of the number of rows that would
be returned based on the following query.

select tableA.*,
tableB.fieldA,
tableB.fieldB,
tableB.fieldC,
tableC.fieldA,
tableD.fieldA,
tableD.fieldB
from tableA,
tableB,
tableC,
tableD
where
PREDICATES
group by
ALL FIELDS in the select

select COUNT(*)
from tableA,
tableB,
tableC,
tableD
where
PREDICATES
group by
ALL FIELDS in the select

If you only want read the table once you can insert into a temp table,
and check @@rowcount after the INSERT.

[Hugo Kornelis]

On Fri, 10 Dec 2004 15:27:44 GMT, kjc wrote:

Thanks for the reply Erland, but, I tried what you proposed.
What I get back is the number of rows returned by the select
all with the number 1 in each column.

Hi kjc,

Try this one instead:

SELECT COUNT(*)
FROM (
select tableA.*,
tableB.fieldA,
tableB.fieldB,
tableB.fieldC,
tableC.fieldA,
tableD.fieldA,
tableD.fieldB
from tableA,
tableB,
tableC,
tableD
where
PREDICATES
group by
ALL FIELDS in the select
) AS x

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[kjc]

Thanks Hugo,
U GO !!

Hugo Kornelis wrote:

On Fri, 10 Dec 2004 15:27:44 GMT, kjc wrote:

Thanks for the reply Erland, but, I tried what you proposed.
What I get back is the number of rows returned by the select
all with the number 1 in each column.

Hi kjc,

Try this one instead:

SELECT COUNT(*)
FROM (
select tableA.*,
tableB.fieldA,
tableB.fieldB,
tableB.fieldC,
tableC.fieldA,
tableD.fieldA,
tableD.fieldB
from tableA,
tableB,
tableC,
tableD
where
PREDICATES
group by
ALL FIELDS in the select
) AS x

Best, Hugo