I have got a SQL query that get information from different databases,
I have all the information that I need but now I want the last information
I have three columns they are the following
Number

I have two tables. One is an export from a different database and one is the
destination table.
The Export table looks something like this:
EmpID = the ID of an employee

I have 2 columns of data, one has an Agent code and the other has
information about the Agent.  There are duplicates of the Agent code in the
1st column, but different info in the second. For example:
Col 1          Col 2

I messed up and now we have two tables that have slightly different
information. What is a query that would allow me to look at the data
differences between the two tables?

What I have are two different tables that I am going to join.  Everything in
the first table should be pulled.  The second table should only pull the
information when the field ACTION equals the word "ORDERED".  Is there a way
to join two tables on just a literal

Can I write an if statement in T-SQL for MSSQL2K or do I have to do it in the
WHERE clause?
Would like to say:
IF field1 = e

What I am looking for is to read a file that has three columns to it and
return the lastest part number with the newest date.
part Number    Date       QTY
2534               100102  20

I have a table which stores the shift timing like this:
ShiftId    StartTime                   EndTime        WeekDay    Shift
1    6:00:00 AM    6:00:00 PM    7    Shift A
2    6:00:00 PM    6:00:00 AM    7    Shift B

  I have a list of data as show below ,
  Data1      Update Date
---------    ------------
    1          01-01-2004

I have to build a text file that has 80 character records.  I have a number
of fixed length fields in the file but need to add a 'filler' at the end of
the fields to get to 80. Do I have to create a dummy variable to do that and
if so, how?

I have to build a text file with a dollar amount that must be right
justified, left zero filled and no decimal.  The field I am extracting data
from is 'amount' and defined as decimal 9(15,2).

I have a field defined as (decimal 9(15,2)) and the recipient of a conversion
.txt file wants to see just the meaningful digits, no decimals, no zero fill
but does want to
see a trailing minus sign for negative numbers. So they want to see 550.45

I have to join two table based on the matching of two fields.  The bad part
is one field is numeric but defined as Character and the other field is
decmial.  This is my SQL.
FROM

I need to subtract two values in a table.  One of these values contains a
NULL entry.  Each time I use the (Pledge - Credit) as 'Difference' I get the
value of NULL.
How do I get T-SQL to replace the NULL with zero?