+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: 2 SQL's in Single statment & write NULL values in the record set also to Excel sheet (/Thread-2-SQL-s-in-Single-statment-write-NULL-values-in-the-record-set-also-to-Excel-sheet)
2 SQL's in Single statment & write NULL values in the record set also to Excel sheet - prasadsbrk - 08-18-2009
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 ....
RE: 2 SQL's in Single statment & write NULL values in the record set also to Excel sheet - Saket - 08-18-2009
use top(n) in your SQL statement
select top(10) from emp where deptno = 10 order by empno;
RE: 2 SQL's in Single statment & write NULL values in the record set also to Excel sheet - Tarik Sheth - 08-18-2009
You can use row number <11 in the where condition.