Can you explain?

 

https://www.mssqltips.com/sqlservertip/1481/auto-grow-auto-shrink-and-physical-file-fragmentation-in-sql-server/

 

"Auto shrink is a database option that is used to conserve disk space. It creates a thread that runs periodically to detect when the database has...

CELKO (8/4/2016)

---

Nusc (7/31/2016)

---

IF you don't mind saving that xlsx as a csv file and importing as a flat file source so there are no differences would be great.

Year , name,...

Does anyone know a good reference for updating tables for left outer joins?

Do I create the column I wish to store before executing the left outer join then populate the...

CREATE TABLE hurracane(

Year VARCHAR(4) NOT NULL

,Name VARCHAR(10) NOT NULL

,Latitude VARCHAR(10) NOT...

You can easily change the...

The script includes statements that removed the columns, all one needs is to run the script and that's it.

I was told to save the csv as a txt but it...

Ok reset this thread.

Here is the data:

ftp://eclipse.ncdc.noaa.gov/pub/ibtracs/v03r08/wmo/csv/year/

I want to do the following as illustrated on the microsoft website:

add a line layer to map

https://msdn.microsoft.com/en-us/library/ee240828.aspx#LineLayer

They give an example...

I get the result in the attached image.

I am pretty close to getting this done but my issue involves storing these tables into new tables. That's the biggest issue at...

THe microsoft example can plot a path with 3 points

SELECT N'Path' AS Name, CAST('LINESTRING(

-76.5001866085881 42.4310489934743,

-76.4602850815536 43.4353224527794,

...

Spiff (8/3/2016)

---

I don't know why you need all that. The query I provided creates the whole linestring - of all the points. If you really need just a...

If I insert that JOIN using:

WITH cte AS (JOIN STATEMENT)

I get the error:

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless...

Okay then going back to my previous attempt, how would I introduce the INSERT statement for this JOIN?

http://www.sqlservercentral.com/Forums/FindPost1806043.aspx

I asked how to update the table but then the discussion...

I get the same errors as I did with linestring in my previous attempts.

THe whole point of doing is this is to load this data into SSRS.

Okay it works so far. How do I save the output into the table so that I can load it in visual studio?

MY issue with using these geography statements is...

Spiff (8/3/2016)

---

OK, to be fair I was going from the question you posted in the SSRS forum. I thought your problem is that you wanted a linestring from the...