I need help in getting around this problem.

I have two tables that have GPS coordinate locations (X, Y, Z in separate columns as well as a geometry column, GP) known as TableA. The second TableB also have separe columns (Xs,Ys,Zs , Xe,Ye,Ze as the start and finish points of traverses and then a geometry
column GL, of linestrings formed from Xs,Ys,Zs , Xe,Ye,Ze). I can display the geometry as well as linestrings in sqlserver 2008r2 spatial results.

My challenge is:

1.Bringing these two geometry points and linestrings together as one display when a query is run.

2.Get a logic/algorithm to retrieve all points that lie within a certain distance (for example x meters from the red linestring) so that they can be shown in both spatial results as well as in the business Intelligence environment of ss 2008r2.
Below is a sketch of the problem: I appreciate any suggestion.