This is a tough one.  What you really have is unmanaged information.  The relationship between the items whether it's col1 and col2 or col2 and col1 should be controlled before...

At first blush change the following

CREATE PROCEDURE sp_StoreCt

DECLARE @CurFYPeriod DateTime

SET @CurFYPeriod =  (Select FiscalMonth From FiscalCalendarDaily Where CalendarDate = convert(datetime,convert(char(12), getdate())))

AS

and move the set command after the AS keyword

CREATE PROCEDURE...

If the milestones are individual records a computed column will not work.  If they are separate fields on the same record a computed column would work fine.  The only way...

UPDATE tblSiteReview

set tblSiteReview.blnNonCompliant = 1

from tblSite inner join tblSiteReview on tblSite.tblSitePK = tblSiteReview.tblSiteFK

where (((tblSite.intStatus)=2) AND ((tblSiteReview.dtmReviewDate)>[tblSiteReview].[dtmExpDate]))

I would suggest creating a view that contains the needed tables using the with(nolock) clause then use that view as your data source in crystal.  I would also strongly suggest...

select db_name()

By counting * you are counting all occurences.  Count a field from the DD00100 table and that should fix your problem.

Is there a time the value of Parameters!SubmittedDate.Value is null?  That would cause the entire value to be null which might cause the problem.

Is this in SQL Reporting Services?  If so, look at the hidden property for the object you want to hide and have that property be defined by the value of...

Are you defining a specific separator?  If not try defining it as a comma and you should get a comma delimited attachment that should be easy to open with spreadsheets...

This is often a problem...can you show me what isn't there?

Anyway, if you change your having clause to <> classname you'll get a...

Are you sure the field in your table is not defined as an integer?  DTS is usually pretty good at importing correctly. 

Have you tried to set a variable equalt to @@scope_identity function within your dynamic SQL?  The variable should be available after the dynamic sql is performed?

Remember, it is best to avoid...

What indexes do you have and is there a clustered index on the fields you are changing?

Also, are you doing this while other users are accessing the data?

I have learned...

I have to agree with Jonathan in that it is very difficult to suggest anything without seeing execution plan (which is obviously not an option here).

I vaguely remember an article...