> For the complete documentation index, see [llms.txt](https://docs.keyfax.biz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.keyfax.biz/product-suite/admin/best-practices/handling-multiple-rows-from-sql.md). # Handling multiple rows from SQL How your Databoxes can handle multiple rows of data In most cases, SQL Query Databoxes have something in common - they must return a **single row of data**. However, see below for an example of what can be achieved when handling **multiple rows** with some clever use of [XML](https://www.w3schools.com/xml/) and X[Path](https://www.w3schools.com/xml/xpath_intro.asp) statements.(you may want to seek local IT support regarding SQL, XML and XPath at this level; the Omfax Systems Administrator training is not intended to cover these technologies in any depth). ### Example A recent requirement arose where is was necessary to scan and interpret **multiple rows**. In this case, it was concerning asbestos details for a particular location (in this example,**KIT**chen) for a given property. This is the underlying data we'll be working with; it comprises two rows which detail the asbestos component and associated risk level:

So we created an SQL Query Databox which returns the above data in an XML packet (using the **FOR XML** clause): ```sql SELECT ASBESTOS_COMP + ':' + RISK_LEVEL AS ASBText, RISK_LEVEL FROM usr_Asbestos AS ASB WHERE SUB_LOC_CODE = 'KIT' FOR XML AUTO, TYPE, ROOT('Custom') ``` and this is the XML packet created: ```xml ``` This allows us to use **XPath** expressions to access the returned row(s) in a variety of ways:

Here's an explanation of the above Expressions:

Title	Value	Description
Count non-zero risk	Item("count(ASB[@RISK_LEVEL != 'ZERO'])")	As the title suggests, this will return the total number of ASB nodes (i.e. rows) where the attribute RISK_LEVEL is not equal (i.e. '!=') to the literal 'ZERO'. IMPORTANT: Note that 'count' is an XPath function so remember that XPath is case-sensitive; if you specified 'Count', an error will be returned.
Count VLOW2	Item("count(ASB[@RISK_LEVEL = 'VLOW2'])")	This expression will return the number of ASB nodes (i.e. rows) where the RISK_LEVEL equals 'VLOW2'.
Text	Item("ASB/@ASBText")	This will return the a comma separated list of the values held in each ASBText attribute.

Using Expressions with your DataBoxes in this way will allow you to add value to messages and generally control scriptflow based on the results returned, i.e. in this case:

Used with care, the combination of SQL, XML and XPath offer some extremely powerful and interesting possibilities!