well I disagree.....on the assumption that you wish to plot the course of the hurricane, how...

maybe

DECLARE @str VARCHAR(100) = 'Discontinued Rx # 0011122657 via Prescription File'

SELECT SUBSTRING(@str,19,10)

cory.bullard76 (8/2/2016)

---

Hello, I consider myself to be decent at SQL....I don't use it as much anymore. I have a column of data that I only want to pull the...

ok...but do...

Nusc (8/1/2016)

---

Yes I am.

THe datetime data is unique. I guess I could have done it that way.

I want to update the table with the spatial data so that when I...

hmmm...been trying to second guess what you are trying to do......are you lokking to plot the track of hurricanes?

if so...then I think you need to get data that provide a...

but in this thread its also been called "cleandata" and the column "year" is now called "season". 😛

Nusc (8/1/2016)

---

Hi,

is anyone familiar with building maps with SQL Query?

I am trying to find follow this example:

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

But I run into errors when I use my own data such as:

A .NET...

try

LEFT OUTER JOIN

hurracane b

ON

b.rowid = a.rowid + 1

AND b.season = a.season

...

Nusc (8/1/2016)

---

I still get the following error:

(88407 row(s)...

looking at that example...they are casting to varchar from a decimal...you already have...

Nusc (8/1/2016)

---

No. If you open the csv file and sort by year and name that's still not true.

That's something I need to fix. Furthermore, I need to change the data...

Nusc (8/1/2016)

---

No, not for...

here is your spread sheet data for "Emily" setup for others to use.

you will see that "Emily" does have a rowid of 1`......

CREATE TABLE hurracane(

Year ...

please read this article and post back with some set up scripts and expected results

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/