I want to loop through a table (tblrelmanager) and merge the results with a

I'm creating a vb.net web form that connects to an access database. I just
need clarification on a SQL statement.
Basically, I do a record update like so:
UPDATE TClaimTrak

Using SQL 2000.  I need to select rows based on a date range.  Both the
beginning date and ending date of the range will be entered in the
mm/dd/yy format.  There are 2 columns in the table called MonthOfEval
and YearOfEval, both varchar(9) and both with data like "August" and

    I am working on Web Application which deals with history data for
reports and keeping track of changes.
Current Solution :
1)     For each Entity I am having a column TID (Tracking ID) which

Is there an easy way to construct a query that would calculate year to date
totals?
My original table is as follows:
Category   Month   Class   Amount

select no_dossier from dbo.membre where date_MAJ = GETDATE()
select no_dossier from dbo.membre where date_MAJ = '2005-07-21'
Both should give me the same result, yes or no?
thanks

In Access, if I want to update one table with information from another,
all I need to do is to create an Update query with the two tables, link
the primary keys and reference the source table(s)/column(s) with the
destination table(s)/column(s).  How do I achieve the same thing in ...

Messages to the reporting services group get no attention, and I
haven't been able to find anything on MS support so I am going to try
here. We have a prticular report, that when exported to Excel through
Reporting services exports fine, but has an additional Excel sheet

I have a flat file table that describes crash data in SQL Server.
It contains vehicle information.
I would like to know if anyone knows a SQL statement that could go from
this

I upgraded my server from 2 processors to 4 processors. Is there any tuning
or adjustements in SQL that need to be done in order to take advantage of
the new hardware? It is SQL 2000 SP4 Enterprise Edition. Any help would be
appreciated and thank you in advance.

Wath type of SQL Data Type should I use to store this file ?
You'll notice that there's some problem with the Ascii #13 and Ascii #0
How can I do this ?
Thanks

my sql server is too slow, like an example - if i want to open an
table or like if i want to open any section of sql server or like i
i want to go to stored procedure section, any where i want to go, i
taking time to open

Lets say I have a table with these fields: Date, Category, Prod_Name
The
first few rows look like this:
1/04 CatA ProdA

I am running distributed transactions via linked servers. All the SQL servers
involved are on SQL Server 2000 and on Window 2000 professional.
I am receiving distributed transaction failure error messages when trying to
run distributed queries. The error message is

How do I run Multiple Likes in one query? Do I need to run each Like
seperately?
Thanks for any help.