I currently have information stored on two different SQL
servers. I need to run a query that qeurys both at the
same time making comparisions. I would like to be able to
do this in on select statement. Both machines are on a

Is there any function that truncates a decimal numeric without rounding, if
i use cast it rounds the figure but can i  don't want that i.e i want  it to
be as follows:
23.1238  turns to 23.123 and not 23.124  so it keeps only three decimals as

I've Emp table with empno, name, dept.  The data for the
dept are A,B,C
I want to update that table Edu for A, Sport for B,....
using self join in single statement.

Appreciated it if someone could help me with regards to
the abovesaid problem.
I don't know how to append data using SQL Query Analyzer
from table a to table b because it will create duplicate

I am trying to join two tables on a date field.  My
problem is the hour/minute section.  I want to match
07/26/04 on both tables, regardless of the
hour/minute/second piece of the number.  I am used to

I have  a SQL statement like the below listed inside a
stored procedure.
-------------------------------
declare @cnt int

i am new in mssql7.before i am using sybase and
some of the tables having field type time.after
convert to mssql7 i changed that field type as timestamp.
i want to store time in that feild.For select and update

I am new to SQL but have experiene in access. I would like
to convert the following from access SQL to proper SQL.
Can anyone help. How should this be done in SQL??
[new_field_name]: iif([fieldname]="Help","HELP",

I have two columns I want to compare, both varchar, and
would be in this format
Subject | Instructor
----------------------

My EQ model dispalys a normal table when you ask a question such as;
show me the amount of goods solds for last 5 years.
it shows the amount grouped in to 5 years.
It would be nice if I can show it in a graph rather than the data.

Is there a way to convert a field to Currency format with
a comma as a seperator.
ie
50000 would be $50,000

G'Day folks,
My question is related to deleting an existing db in sql.
The reason why I need to delete the existing db in sql is
to update the db from my log file.

This was the script for access:
oRS.Open "Select * from AlertHistory Where Date
=#"&DateValue(LogTimeStamp)&"#;",oConn
does anyone know the equivalent for sql server?

I have a project underway and am having a couple
technical difficulties. My duty is to run my access
database with sql server.
My fist problem is for table jobs.

Select statement is running 3 time slower than before
after I installed sp3 in SQL 2000.(before is sp1).
Do anyone know why and how to fix it?
Thanks all reply.