Viewing 15 posts - 466 through 480 (of 2,452 total)
I don't want to use ISO_TIMe because it's easier to order with rowid as INT.
well I disagree.....on the assumption that you wish to plot the course of the hurricane, how...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 3, 2016 at 2:06 pm
maybe
DECLARE @str VARCHAR(100) = 'Discontinued Rx # 0011122657 via Prescription File'
SELECT SUBSTRING(@str,19,10)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 2, 2016 at 11:29 am
cory.bullard76 (8/2/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 2, 2016 at 11:09 am
Nusc (8/1/2016)
I prefer to update the table in management studio. the idea is the provide as very little code in the sql query wizard for map services in SSRS.
ok...but do...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 2:58 pm
Nusc (8/1/2016)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 1:45 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 1:32 pm
Phil Parkin (8/1/2016)
A quick side note: it's hurricane, not hurracane, I think.
but in this thread its also been called "cleandata" and the column "year" is now called "season". 😛
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 12:28 pm
Nusc (8/1/2016)
is anyone familiar with building maps with SQL Query?
I am trying to find follow this example:
But I run into errors when I use my own data such as:
A .NET...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 12:26 pm
try
LEFT OUTER JOIN
hurracane b
ON
b.rowid = a.rowid + 1
AND b.season = a.season
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 12:12 pm
Nusc (8/1/2016)
J Livingston SQL (8/1/2016)
suggest you change
indexid = ROW_NUMBER() OVER (PARTITION BY [Name] ORDER BY [Name])to this
ROW_NUMBER() OVER(PARTITION BY NAME, YEAR ORDER BY Latitude)
I still get the following error:
(88407 row(s)...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 11:37 am
Nusc (8/1/2016)
why are you changing to decimals?
Because of this working example:
This is precisely what I need to do.
looking at that example...they are casting to varchar from a decimal...you already have...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 11:34 am
Nusc (8/1/2016)
That's something I need to fix. Furthermore, I need to change the data...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 10:43 am
Nusc (8/1/2016)
J Livingston SQL (8/1/2016)
here is your spread sheet data for "Emily" setup for others to use.you will see that "Emily" does have a rowid of 1`......
No, not for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 9:39 am
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 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2016 at 3:27 am
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/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 30, 2016 at 1:07 pm
Viewing 15 posts - 466 through 480 (of 2,452 total)