Very stupid question but I am pressed for time
I have a 200 mb file that has three columns of data.
Latitude, Longitude, and Altitude
I want to sort by altitude.
I have downloded the SQL Server and am trying to sort the data in Sql sever
Analyzer. There is no where to find instructions on how to input the sql
anywhere and I dont have enough time to understand sql server to figure out
how to do this.
Is there Access like function where you could visually do this?
If not , what is the easiest way of doing this in sql server?
please tell me how you would solve this problem.
Thanks in advance.
Use Query Analyzer to run the query:
select
*
from
MyTable
order by
Altitude
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"t" <t@.discussions.microsoft.com> wrote in message
news:ACB53185-1A1A-4641-BA32-D04F369F34E2@.microsoft.com...
Very stupid question but I am pressed for time
I have a 200 mb file that has three columns of data.
Latitude, Longitude, and Altitude
I want to sort by altitude.
I have downloded the SQL Server and am trying to sort the data in Sql sever
Analyzer. There is no where to find instructions on how to input the sql
anywhere and I dont have enough time to understand sql server to figure out
how to do this.
Is there Access like function where you could visually do this?
If not , what is the easiest way of doing this in sql server?
please tell me how you would solve this problem.
Thanks in advance.
|||My problem is where do I enter that.
i have opened the txt db file in query analyzer and can not figure out how
to implement it. My goal is to break up the db by altitude. what do people
who use this or other dabase use to accomplish this kind of request.
Is sql server too big for it? Problem is I can not do it in access or
excel(over 100mb).
Please advise
"Tom Moreau" wrote:
> Use Query Analyzer to run the query:
> select
> *
> from
> MyTable
> order by
> Altitude
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "t" <t@.discussions.microsoft.com> wrote in message
> news:ACB53185-1A1A-4641-BA32-D04F369F34E2@.microsoft.com...
> Very stupid question but I am pressed for time
> I have a 200 mb file that has three columns of data.
> Latitude, Longitude, and Altitude
> I want to sort by altitude.
> I have downloded the SQL Server and am trying to sort the data in Sql sever
> Analyzer. There is no where to find instructions on how to input the sql
> anywhere and I dont have enough time to understand sql server to figure out
> how to do this.
> Is there Access like function where you could visually do this?
> If not , what is the easiest way of doing this in sql server?
> please tell me how you would solve this problem.
> Thanks in advance.
>
|||1. Create a Database using Enterprise manager.
2. Right Click on said new Database and Select All Tasks>Import Data
3. Select the datasource (excel? Textfile?)
4. Step through the wizard
5. Using Query analyser or indeed create a view run the code select * from
table order by Altitude
6. tada
"t" <t@.discussions.microsoft.com> wrote in message
news:ACB53185-1A1A-4641-BA32-D04F369F34E2@.microsoft.com...
> Very stupid question but I am pressed for time
> I have a 200 mb file that has three columns of data.
> Latitude, Longitude, and Altitude
> I want to sort by altitude.
> I have downloded the SQL Server and am trying to sort the data in Sql
sever
> Analyzer. There is no where to find instructions on how to input the sql
> anywhere and I dont have enough time to understand sql server to figure
out
> how to do this.
> Is there Access like function where you could visually do this?
> If not , what is the easiest way of doing this in sql server?
> please tell me how you would solve this problem.
> Thanks in advance.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment