rogynskyy
Last Activity: Jun 29 '07, 04:09 PM
Joined: Apr 9 '07
Location:
-
How do I sum them up then?... -
Hi guys,
I'm running MSDE 2000 A on Win XP
I've got a database with several tables, all of the tables display data in query manager.
I wrote this simple query:
...Code:Select Feed_3PT_CC.LIST_NO, Feed_3PT_CC.LIST_PRICE, Feed_3PT_CC.STREET_NO, Feed_3PT_CC.STREET_NAME, Feed_3PT_CC.PROP_TYPE, Feed_3PT_CC.NO_BEDROOMS, sum (Feed_3PT_CC.NO_FULL_BATHS+
Leave a comment:
-
Help with a simple query
Hi guys,
I'm running MSDE 2000 A on Win XP
I've got a database with several tables, all of the tables display data in query manager.
I wrote this simple query:
...Code:Select Feed_3PT_CC.LIST_NO, Feed_3PT_CC.LIST_PRICE, Feed_3PT_CC.STREET_NO, Feed_3PT_CC.STREET_NAME, Feed_3PT_CC.PROP_TYPE, Feed_3PT_CC.NO_BEDROOMS, sum (Feed_3PT_CC.NO_FULL_BATHS+
-
Thank you guys so much! It worked. The problem was that I did not have permissions in the system.
Now I have one more little complication.
I need to pull data from several tables with one query and export it into one spreadsheet file
I create a query with this code:
...Code:LIST_NO, LIST_PRICE, STREET_NO , STREET_NAME, PROP_TYPE, NO_BEDROOMS, NO_FULL_BATHS,
Leave a comment:
-
It returns me one row. I guess something is wrong with rights. Will call their support now.
Thanks,
Oleg...Leave a comment:
-
It is impossible.
It has records. I tried different tables - same results.
It is an ongoing database.
Any other possible reasons?...Leave a comment:
-
I executed this command:
and it returned me a list of system objects. This means I'm connected and SQLGrinder works well.Code:Select name from sysobjects
Any ideas?
I just ran the following command
[CODE] Select LIST_PRICE from Feed_3PT_SF[CODE]
And it returned me a LIST_PRICE column without any data in it...Leave a comment:
-
The database is huge. Could it be a reason that there is too much data, so it cannot display it?
Also,
Is there any way to modify the query to include data only for the past 7 days?
What would it be?
Thanks,
Oleg...Leave a comment:
-
They have stuff. It is one of the biggest real estate databases.
Which program is the best for use on a MAC?
I need to pull certain columns and export them into comma delimited....Leave a comment:
-
I do it - it shows me columns in the output section of the SQLGrinder, but the columns are empty. There are no entries in them
Any ideas?...Leave a comment:
-
Thank you so much for the reply!
One thing - they deny me a permissiont o create a view on the server side.
What would be my solution?
How should I change the query text?
Thanks,
Oleg...Leave a comment:
-
I'm on a client side. Server is a remote real estate database, operated by a 3d party. My task is to get out the following columns from the database for the period of the past 7 days.
LIST_PRICE decimal,
MAP varchar(6),
STREET_NO varchar(10),
STREET_NAME varchar(30),
SQUARE_FEET decimal,
PARKING_FEATURE varchar(9)
Table name is Feed_3PT_SF
Thanks a lot!!!
...Leave a comment:
-
When I use the text in part 1 and then try to execute it (using "Execute" command of SQLGrinder, it still gives me the following error:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near 'LIST_PRICE'.
Do you know what could it be?
Thanks a lot!
Oleg...Leave a comment:
-
Simple query for MSSQL
Hi guys,
I have to run a simple query on a MSSQL 2000.
I'm new to database usage.
I need to create a view with the following table columns
LIST_PRICE decimal;
MAP varchar(6);
STREET_NO varchar(10);
STREET_NAME varchar(30);
SQUARE_FEET decimal;
PARKING_FEATURE varchar(9)
Here is a query that SQLGrinder (I'm a Mac user) has generated for me:...
No activity results to display
Leave a comment: