I have the following problem. I`ve opened a Query Analyser and write the
statement:
-isql -S 'PL6XXXX' -i 'd:\SQL_Server_2000\Raport_WWW.sql'
I got the following erorr message:

Please advise on how to get the GROUP BY coded in an acceptable way:
DECLARE @LO         INT
DECLARE @HI         INT
DECLARE @StartDate     varchar(10)

I want to use the MS-Sqlserver's OPENXML function in my java application (to
load data from xml file into database)
I am using mssqlserver.jar (JDBC fro sqlserver by MS).
Can somebody tell me how do i execute the OPENXML function from JDBC.

(I don't post here often, so in case I'm violating long-standing taboos
of this newsgroup, I apologize in advance for calling a relation a
table, using nulls, and other ignorant, destructive, and comtemptible
terminology.)

I have database in Access with queries in database.
Are syntax of queries in Access same as syntax of queries in MS SQL 2000, so
that I dont have to change every query?
I can post sample query if needed.

I have database in Access with queries in database.
Are syntax of queries in Access same as syntax of queries in MS SQL 2000, so
that I dont have to change every query?
I can post sample query if needed.

I have a partitioned view sitting over several tables and I'm slowly
approaching the 256 number. Can anybody confirm if there is such a
limit for the maximum number of tables that a partitioned view can
hold?

I am creating a search function that retrieves data from a SQL database. THe
search works fine exceot for when there is a ' in the data (e.g. leopard's
leap). The query looks like this: SELECT WineryName, WineryID  FROM tblWinery
WHERE WineryName LIKE '" + ...

I'm trying this simple query but getting multiple listings for
change_number field
SELECT  c.Change_Number, c.Submission_Date, c.Short_Description,
c.CurrentStatus, dlv.Name, s.Description, kw.Subcategory

I try to convert a pseudo datetime string into a date. In Oracle I can do
to_date( MyDate, 'yyyymmddhh24miss' ); how I can do this with MS SQL ?
thanks and regards
Mark

I'm looking for an elegant way to solve a problem that I have.  I'm writing
an app that allows the user to query the database, and I provide a pulll-down
list of the fields, which I populate with the field names.  I also allow them
to input comparison criteria (=, <, >, etc).  ...

how I can use a function of my own within a select statement. I tried
create function funny() returns int
as begin
   return( 2 )

I am in the process of importing an Oracle database into SQL Server.
Once of the tables has a field called "EXEC".
SQL Server seems to reject any queries that include that particular
field because EXEC is a keyword. For eg.

I need to track the movements of applications in a database. The apps are
moved into  queues depending on the processing stage. I would like to track
for about an hour. I am new to sql. The basic query will be:
select * from app_locator

Just installed SQL 2000 client only.  Do I need to install Service Pack for
client only?