I would like to know the possiblities of getting multiple rows with single SQL statement. Then need know the logic to retrieve entire data found in the returned rowset/records from the database. <br> <br>Thanks in advance.

You can get multiple or all of the rows with a single SQL Statement step, but you have to fetch them one row at a time. <br> <br>Immediately after your SQL Statement step, use a SQL Fetch step to get a row. After you have done whatever you want with that row, go back and fetch another using the same SQL Fetch. When you reach the SQL Fetch and it goes down the bomb, or fail path, you have fetched all the rows for your query.