This is not my 1st post related with performance. I am experiencing serious
performance problems with a VB6 application running over a SQL Server 2000
database. I have already used SQL Analyser, SQL Profiler and Performance
Monitor to collect data that might help resolve this ...

I have a table that has two fields, pkg_num, which is a number, and
del_date_time, which is a date-time.  The table can contain duplicate pkg_num
values, as long as the del_date_time values are different for any given
number.  I need a query that will return the most recent ...

Here is a very interesting SQL which I failed to solve.
I have two tables called Main and Notes.Table notes has id field which is
primary key of the Main table and foreign key in notes table. Notes table has
an identity column called NotesId.

I can not get this query to work right it returns the records for the dates
03/19/2005 and 03/20/2005 but not 03/21/2005. Could this have any thing to do
with my SQL Server collation set? My collation set is
SQL_Latin1_General_CP850_CI_AS.

I have a query that returns a detailed resultset but I need to create a
summary of it as follows:
ResultSet of Detail:
--------------------

I have the following syntax
Sum([SalesQty1]+[SalesQty2]+[SalesQty3]+[SalesQty4]+[SalesQty5]+[SalesQty6]+[SalesQty7]+[SalesQty8]+[SalesQty9]+[SalesQty10]+[SalesQty11]+[SalesQty12])
AS YrSales
This works fine if none of the fields are NULL

How to get last (maximum) date of a month through sql
query.
ex: if 31st is the last date of a month then i should get
31(dd) or 31/03/2005(dd/mm/yyyy) format or 20050331

Is it possible to do this all in one stored procedure?
I have 3 separate queries which returns all the correct records with
Stockcode being the field to join
Q1 is my main query from which I want to return all the records.

Hi Gurus,
Is there any automated way to compare the contents of TWO rows in the same
table of  SQL Server ?
Thanks in advance.

I want to return records based on a linetype and classtype
Here is what I have so far
Where (LineType = '1' OR LineType = '7')
or (LineType = '5'AND ClassType NOT LIKE '[_]%')

I have a question that I haven't been able to find an answer to in either the
help files or Technet/MSDN searches. First a little background. I have a
number of SPs that pull the same basic data but manipulate it in different
ways (e.g. some add address information for targeted ...

I know the sql is incorrect on this but was wondering if something like this
was possible:
select * from
(

I am trying to create a record number.  Don't ask why LOL.  Below are the
items I need in my record number.  Here is the format I'm looking for.  I am
also having problems trying to get it to display zeros before numbers such as
1.  Ex. 1 should be 01.  This would be stored in a ...

I need to run a query that does the following:
A table exists as such:
ID (Number)
Letter (VarChar)

I am using SQL Server 2000 on Windows 2000 server. Here is my problem:
@String = 'word1word2word3word4word5' - This value is passed to Stored
Procedure from the script.
Column1 in a table1 has many rows with "words" . One row in this column1