Micah
4Penny.net
Points: 7359

8/10/2021 8:25:40 AM

Use ROW_NUMBER to include header-level fields only once per document

This is a SELECT statement that shows how to use ROW_NUMBER()  to include a header-level field only once per document

In other words, if you have a query that returns the invoice header and the lines and you want the (header level) tax to be included only once in the lines, this will show you how to do that.

4Penny.net
Version: Unknown or N/A
Section: SQL Scripts,SQL for Beginners
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3