Can i install SQL server 2000 on XP Prof? is there any seperate version
for XP Prof?
Where can i get Free SQL Server 2000 book in PDF foramt. I cannot able to
purchase books. I cannot bare.

we have a table with a column of type "datetime"
We want to get the smallest timespan between two entries.
Now we get this timespan with the following query (it works but it's to
slow, it runs 5 secs with 250000 entries):

We have a tableA with a varchar field whose contents are
hexadecimal. We want to insert these hexadecimal contents
from a varchar field into different table, tableB in
decimal format.

Is there a way in SQL Server to run the simple query
having something like IIF function in Access.
Similar to this easy query.
SELECT Mobile,iif([PlanType]=1, "New", "Upgrade") As Type FROM  Acts WHERE

Hi,
I am new to MS SQL server. I installed the sql server 2000 evaluation
edition on my PC( Windows XP Pro,SP 1). I can work with enterprise
manager without any problem but I cannot open the SQL Query analyzer.

I have data in 3 tables that I want to add together to get a total figure
So far I have an sp that uses a union query that gives me 3 totals (1 from
each table)
How can I now add these 3 totals together?  is it a subquery of somesorts or

SELECT     discounts.*, discounttype AS Expr1
FROM         discounts
WHERE     (discounttype = 'Initial & Customer')
This query in pub database does not bring anything because of  ‘&’ in where

can you update date a column with an if then statement.  This is a simple
example and I want to do something more complex, but I can't figure out how
to do this simple example.  can someone help?
update car set field1 = (if (select passengers from car where id=1)='3' begin

I've got one table that holds various information fields and a field for the
city, and another table that holds city and state (and zip, etc).  I want to
query both tables to show the number of states for which records in the first
table were submitted.  Problem is that although ...

I've got one table that holds various information fields and a field for the
city, and another table that holds city and state (and zip, etc).  I want to
query both tables to show the number of states for which records in the first
table were submitted.  Problem is that although ...

Can anyone advise me of how to make sure that a customer is inputting
correct information into the database.
I am building a website, where customers are not logging in, but request
info. by name, addr. and postcode/city, email. I want to check if the

I have a expenses table, in this table I have the account, exp_date,
exp_type and amount fields.
I have three exp_type (real, budget and myu) I would like to create a table
with

I've a problem to remove certain character from one
column/field eg. 500000000000ABC. How to remove ABC ?
Thanks in advance.

I want to condense several rows of a table using a select
statement, function, or stored procedure
For Example
mytable :

  I have table for items, some of the Items codes are including text codes.
When I try to use
Select From **** Where **** like '****'
I don't get the correct record until I put the Upper case or lower case text