Using SQL2000.  How do I format my select statement to choose one out
of 24 different tables?  Each table is slightly different and I was
hoping I could use one select statement and format it on-the-fly
instead of using 24 different ones.  I had in mind using a case

I've been reading the docs and playing around,  but I'm still not
getting the difference. For instance,
create table a(i int check(i>0))
create table a_src(i int)

Here is sample data I'm working with:
ID    ShiftDate   SegTime
99    5/2/2005    5/2/2005 1:00:00 PM
99    5/2/2005    5/2/2005 1:04:00 PM

I am new to SQL Server 2000 so I hope I am asking the right questions.Any
help would be greatly appreciated.
I have 2 questions.
Question1 is how do I change a logical filename when restoring?

I can't make my mind up what the most efficient query is for the following
problem. My table contains records similar to this example:
ID   CAT
1    A

I'm trying to read data from Navision 2.60 ERP with own database to a
SQL Server 2000 database via ODBC. All is working except just one
thing, how to filter data with a date field.
I have some big tables that have a date field and I just want to read

I've got a data set on which I'm trying to perform the same as excel's
vlookup formula using SQL, but do not know how. Can anyone help?
If you picture me having two tables Table_A and Table_B and they look
like this;

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"?    For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?

What is the difference between a mdf file and the sql server database in the
context of new sql server 2005? What are the capabilities and limitations of
each?
Thanks

hello group,
   a few days ago i used the following backup statement and everthing
worked fine:
sp_addumpdevice 'disk','pipedump','\\192.x.x.x\L\Data\test.bak'

I have an Access DB with a column [date] holding dates from present day back
to around year 1702, and I am trying to run DTS Import with this MDB, which
fails due to a conversion error.
MSDN says the datetime data type only allows 1753-01-01 to 1900-01-01, thus

I am looking for basic info on installing and using MSDE.
I am trying to install and play with MSDE on my PC (Win2000).  I
finally managed to work my way through installation, and named
instances but I am finding no information on how to simply START the

I'm really stuck on this one so would appreciate any help you can give.
In essence, I have 1 SQL 2000 table with rows of data logging stock
movement.  To differenciate between a stock sale and a stock receipt the
table has a TRANSACTIONTYPE field so that 8,7 equal invoices and 3 ...

Is there any reason why I shouldn't cause an arithmetic error(say by
dividing by zero) in a User Defined Function for a situation where in a
stored procedure you would use RAISERROR or in code you would throw an
exception?

Which lock type or isolation level should I use to be sure that no one
will read or write or do anything with the table I'm using?
Code block should look something like this:
lock table