Test case ID
Database1                                                      Database2
------------------------------------------------------------------------------------------------------------------------
1                      select count(*) TotalRecords
from                         select count(*) TotalRecords from
                        TableA where
abc='12'                                         TableA where abc='12'
------------------------------------------------------------------------------------------------------------------------
2                      select count(*) TotalRecords
from                         select count(*) TotalRecords from
                        TableB where
abc='12'                                         TableB where
abc='12'
------------------------------------------------------------------------------------------------------------------------
3                      select count(*) TotalRecords
from                         select count(*) TotalRecords from
                        TableC where
abc='12'                                         TableC where
abc='12'
------------------------------------------------------------------------------------------------------------------------
Hi All,

I have 1 excel template like above containing 3 columns namely
TestcaseID, Database1,Database2 as shown above. col2 and col3 contains
queries from tables for each database resp.
What I want is to execute each queries in the sheet corresponding to
each testcaseID and then compare the result of two queries... i.e
queries contains Count(*) function so I want to compare the value of
the two queries for each testcase ID.
Similarly there are many testcases for which i need to perform the
same operation.

Can anybody pls provide their inputs on it.

Thanks
Shalabh

-- 
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en

Reply via email to