In the below statements how can I bring up the intellisense in the second select statement. When I place the cursor in the space after the SELECT and press nothing happens. Is this the expected behavior?
thx.
DECLARE @g GEOGRAPHY
SET @g = (SELECT LL FROM spatial_NTS_250 WHERE Mapsheet = ‘072E’)
–SELECT @G
SELECT XY_Polygon.STCentroid().STX AS X, XY_Polygon.STCentroid().STY AS Y, 0 AS ‘z’, LSD, Section, Township, Range, Meridian FROM spatial_ATS WHERE LL_Polygon.STIntersects(@g)=1 AND (LSD IS NOT NULL) AND (SECTION IS NOT NULL)