New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
2 SQL's in Single statment & write NULL values in the record set also to Excel sheet

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
2 SQL's in Single statment & write NULL values in the record set also to Excel sheet
prasadsbrk Offline
Junior Member
**
Posts: 6
Threads: 4
Joined: Aug 2009
Reputation: 0
#1
Solved: 10 Years, 9 Months ago 08-18-2009, 03:57 PM
Hi,

How to execute 2 SQL statments in single resultset & i need to write the RS values to excel including NULL's
like
set rowcount 10;
select * from emp where deptno = 10 order by empno;

such that i need top 10 records only.

Thanks in advance ....
Find
Reply


Messages In This Thread
2 SQL's in Single statment & write NULL values in the record set also to Excel sheet - by prasadsbrk - 08-18-2009, 03:57 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Convert the single to an integer Mozza 2 1,256 09-27-2018, 12:36 PM
Last Post: Ankur
  Trying to create List box in excel sheet at Run time with values yes No JACKSPARROW 0 1,594 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  How to write reports from scripts into excel anushreebehura 1 2,070 10-04-2016, 09:29 PM
Last Post: venkatesh9032
  How to Delete Rows with duplicate values in 1 columns in excel thru QTP. arpan 0 2,606 02-09-2015, 08:47 PM
Last Post: arpan
  Custom sort -Excel Sheet kiran 1 3,692 01-28-2014, 09:23 AM
Last Post: supputuri

Forum Jump:


Users browsing this thread: 1 Guest(s)