FUNCTION fHtmCoverRegionAdvanced

Returns tables of HTMID ranges with flags designating inner/oouter status

Returns table of HTMID ranges covering a designated region. The code generates two different types of cover, indicated by its status
0: OUTER, which fully covers the region,
1: INNER, which contains trixels fully inside the region. For the region syntax see the description of fHtmCoverRegion.
Returns table:
htmidStart bigint, 21-deep HtmID range start
htmidEnd bigint, 21-deep HtmID range end
innerFlag int, 0:outer, 1:inner
select * from fHtmCoverRegionAdvanced('REGION CIRCLE CARTESIAN -.996 -.1 0 5')
see also fHtmCoverRegion, fHtmCoverRegionError

Input and output parameters

name type length inout pnum

@region nvarchar -1 input 1

@region sysname -1 input 1

innerFlag bit 1 output 3

htmidStart bigint 8 output 1

htmidEnd bigint 8 output 2

name	type	length	inout	pnum
@region	nvarchar	-1	input	1
@region	sysname	-1	input	1
innerFlag	bit	1	output	3
htmidStart	bigint	8	output	1
htmidEnd	bigint	8	output	2