sql server - Transfer polygon information to point later using STContains() -

i build query transfer information polygon layer (~1100 records) point layer (~300 points). want comp_numb , stand_number values transferred points layer when new point added database.

i have built following query (it select query change update query when working properly):

select gps.invent_plot_id, stands.comp_numb, stands.stand_number forestry.dbo.[gsca #] stands inner join gps_data.dbo.gps_forest_inventory_test gps     on stands.geometry.stcontains(stands.geometry) = 1 

when run query returns >590,000 records. have looked around @ examples such this.

where go next?