Viewing 15 posts - 691 through 705 (of 3,232 total)
Well, it looks to me like you have not taken into account your requirement for the Month-1 logic. To produce the results you've shown with your sample data, it...
January 20, 2010 at 2:40 pm
So what would you expect the results to be with your sample data? Which rows do you want the query to return?
January 20, 2010 at 2:34 pm
Like Gail said, you'll have to wait it out.
Gail,
I too was wondering if the instance was already restarted, but not sure if recovery was being confused with ROLLBACK status...
January 20, 2010 at 2:18 pm
So given the sample data you've provided, what would your expected result set look like?
January 20, 2010 at 2:15 pm
What data type are your tables using for ref_date? Is it integer as shown (bad practice) or datetime?
January 20, 2010 at 2:11 pm
The only way to stop it from continuing is to shut down SQL Server. I would strongly advise against this. The recovery is performing the necessary steps to...
January 20, 2010 at 2:07 pm
Permissions for anyone accessing these files directly for modification would be handled at the file system level. There is no audit. The system security plan should document the...
January 20, 2010 at 2:04 pm
It is a little unclear what you are asking for. I see you are new to SSC as well. Please read through the article in my signature line....
January 20, 2010 at 1:53 pm
I assume then that you have your send mail task set up in the OnError event handler? That would work as well.
January 20, 2010 at 1:50 pm
Well, I would typically use a JOIN for this, but it's realy hard to give you any advice when we have no idea how these tables are related.
Can...
January 20, 2010 at 1:49 pm
What data type is User::RUN_STATUS?
January 20, 2010 at 1:34 pm
From BOL:
Requires INSERT and ADMINISTER BULK OPERATIONS permissions. Additionally, ALTER TABLE permission is required if one or more of the following is true:
Constraints exist and the CHECK_CONSTRAINTS option is not...
January 20, 2010 at 1:31 pm
Your code works fine for me. That is, if I change the DB names to be actual names in my SQL instance and fix the typo in your second...
January 20, 2010 at 1:24 pm
Instead using a script task prior to your For Each Loop Container, here's what I'd do:
1. Create a package level variable called FileCount (type int).
2. Add a step...
January 20, 2010 at 1:16 pm
SELECT SUM(CASE WHEN RequiredCompletionDays - NumberOfDays < 0 THEN 1 ELSE 0 END) as NegativeVarianceCount
FROM ........
January 20, 2010 at 12:03 pm
Viewing 15 posts - 691 through 705 (of 3,232 total)