Tell me also how you did this. On Wed, Mar 30, 2011 at 12:32 AM, Shalabh Dixit <[email protected]>wrote:
> I'm done with it..!! > > On Mar 29, 8:33 pm, Shalabh Dixit <[email protected]> wrote: > > 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 > -- 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
