I am open to that option but I need to do what's required in this link:

https://dba.stackexchange.com/questions/24954/convert-spatial-points-data-to-line-data-for-use-in-line-layer-in-sql-server-rep

THe issue with what Jeff wrote is that for my actual data,

In one...

I need to plot year, name, lat, long coordinates for hurricane paths using SSRS.

I need the same idea of what's done here:

https://dba.stackexchange.com/questions/24954/convert-spatial-points-data-to-line-data-for-use-in-line-layer-in-sql-server-rep

In particular:

SELECT

...

Well I need to write a query that would create a new column and append it to the table in the link and output as it would under s_index.

Are you...

Unique Values for one Shade: look at s_index.

That's exactly what I want but I just need to create a new column in a table with that same output.