December 2, 2008 at 12:58 pm
Hi,
I have one backup file(prod backup) 2 months old(1/10/2008)
then i have restored it on 2/10/2008 and after that one of my query which joins 2 tables
of the same database gives me 97 rows which is fine
when i tried to restore that backup on my QA server's database on 11/14/2008
it got succefuuly restored but the same query now gives 107 rows
and when i restore it today on 12/1/08 it give me 189 rows
how can this happen??
original and qa server both are sql 2000 ,EE,same SP-3a
no one touches or palays witht the bakup file.
where should i look?wht r possible causes?
here is my query
SELECT
p.person_id,
p.grantee_id,
p.grantee_type,
a.account_id,
'X' AS status,
p.grant_end_date
FROM eap_person p
INNER JOIN eap_account_number a ON a.person_id = p.person_id
WHERE
a.row_status_id = 'E' AND
convert(datetime, DATEADD(MM, 3, p.grant_end_date), 101) < convert(datetime, CURRENT_TIMESTAMP, 101)
December 2, 2008 at 1:03 pm
The query is asking for rows less than the current date. Every time you restore the database and run the query the date range is bigger which is returning more records.
That would be my guess anyway.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply