Viewing 15 posts - 2,686 through 2,700 (of 3,232 total)
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...
August 3, 2006 at 7:06 am
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...
August 2, 2006 at 4:16 pm
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...
August 2, 2006 at 4:08 pm
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...
August 2, 2006 at 4:01 pm
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...
August 2, 2006 at 2:05 pm
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...
August 2, 2006 at 1:37 pm
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...
August 2, 2006 at 12:20 pm
Any ideas?? Yes, this can be rewritten without a cursor. Can you post the code for usp_ReplyAVMCalculationtabledetails?
August 2, 2006 at 12:06 pm
"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...
August 2, 2006 at 9:50 am
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...
August 2, 2006 at 9:38 am
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
August 2, 2006 at 9:18 am
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...
August 2, 2006 at 8:48 am
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...
August 1, 2006 at 4:15 pm
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...
August 1, 2006 at 3:45 pm
Make sure you grant permissions on your function first.
declare @SQLBuild nvarchar(20)
set @SQLBuild = dbo.fnGetSQLBuild()
print @SQLBuild
August 1, 2006 at 3:36 pm
Viewing 15 posts - 2,686 through 2,700 (of 3,232 total)