I have a table that has the following three fields and values that I am
trying to build a query on;
Column name-FEDERAL, FICA1, FICA2
         Values- 1           ,  100  ,   200

Note: I am using this to create a report with SRS
I need to pull some data that could possibly be sitting in one of two
tables. Table1 is the "Current" table that holds Orders that have not shipped
yet. Once all of items on the Order have shipped the Order moves to Table2

I have a text column in a table and data stored in it contains formatted
text (with carriage returns, tabs, and spaces).  When I perform a select on
that column, data returned is non formatted.  How do get the formatted data?

I am trying to build a query that will return what quarter the data is in.  
How would I begin to build this logic?  In my table, all I have is a single
date of the transactions.  My date column looks like this;  "2014-02-01
00:00:00.000".

Im trying to figure out the best way and/or fastest way to Match some data
comming in....example below
the below is all the incomming information i recieve to match to a row in
our system, we do send out a TransactionId but reports comming

I have a Table with rows as below
A 1 10
B 1 15
A 2  3

I am writing a query in which I want to select a field and not have the
trailing blank spaces.  Here is my query:  select employid, lastname + ',' +
frstname as name from upr00100
The results look like this "West                 ,Paul" or "Mcbee            

We have a stored procedure that removes old data from a very large (millions
of rows) table and puts it into an archive table.  It grabs the top 5000 rows
and moves them.
B/C the database is in production and is heavily used, the job is run every

I have a table (we'll call it table A) with two fields in it; one is an ID,
and the other (named "State") currently only contains null values. I'd like
to update the "State" field with values from another table in the database
(table B). The two databases share the same ID field, ...