What datatype are your columns?  You are either using char() or you are using varchar()

and the application is inserting the trailing spaces.  Either way, use trim to display them...

Yes, I did make an incorrect statement.  My bad....I was thinking about the SUM function when I made my post.  You are correct, MAX treats NULLs as unknowns as it...

You need new hardware, plain and simple.  A single processor desktop class machine with 1GB of memory will not get you very far as an application database server.  If your...

What files does it say are missing or not registered?  Have you checked to see if they are missing?  If they are not missing, try re-registering them.  I am curious...

Hi Rick.  I'm not 100% clear on what you need here.  Can you clarify by posting some sample data from the weekno column and also post an example of what...

Well, I was hoping that your stored procedure would be a little easier to get a handle on.  I suggest that you try to re-write your main code to not...

This will give you the create date for all SPs.  If someone does an ALTER PROCEDURE, this does not affect the create date, but if you require a DROP/CREATE PROCEDURE...

Stack dumps happen when SQL Server has an error that it cannot handle.  The dumps are designed to be used as a debugging tool for Microsoft.  They can sometimes clue you...

Any ideas??  Yes, this can be rewritten without a cursor.  Can you post the code for usp_ReplyAVMCalculationtabledetails?

"I mean where there is no max value because there are no records in the table. "

Are you talking about an OUTER JOIN then?  How do you know how many non-existant...

MAX treats null values as zero so there is no need to use ISNULL.  The MAX(bunch_of_nulls) + 1 is equal to 1.  I think the problem here is that you...

The clustered index has an IndID of 1 in sysindexes.  Here is a script that should give you everything you need:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1590

Yep, I'd say you got it.  In your case, the Query Optimizer Manager determined that it is more efficient to apply the filter prior to the JOIN.  This may not...

The JOIN is usually done before filtering on the WHERE clause.  Look at the execution plan and follow the arrows to look at the order.  Move your mouse pointer over...

Can you post your table DDL for both tables as well as some sample data from the CategoriesStaging table.

By the way, did you know that the foreign key constraint that...