Viewing 15 posts - 61 through 75 (of 186 total)
Sorry guys, I flew right past the part about specifying the fields for the insert into part...thought I just needed the Deleted fields.
April 7, 2011 at 8:10 am
This is the exact script that I ran:
Set Identity_Insert Archive..CorrespondenceReference On
Delete
FromIARTS..CorrespondenceReference
OutputDeleted.CorrespondenceReferenceID,
Deleted.CorrespondenceLogID,
Deleted.CorrespondenceReferenceTypeID,
Deleted.CorrespondenceReferenceValue,
Deleted.CreatedBy,
Deleted.CreatedDate
IntoArchive..CorrespondenceReference
WhereCorrespondenceReferenceID In
(
Selectcr.CorrespondenceReferenceID
FromIARTS..CorrespondenceReference cr
Inner Join Archive..CorrespondenceLog cl On cl.CorrespondenceLogID = cr.CorrespondenceLogID
Left Outer Join Archive..CorrespondenceReference acr On acr.CorrespondenceReferenceID = cr.CorrespondenceReferenceID
Whereacr.CorrespondenceReferenceID IS NULL
)
Set@ReferenceCount...
April 7, 2011 at 7:38 am
Yep, even adding the Identity_Insert stuff it still throws the error "cannot insert unless specifying Indentity_isnert....."
April 7, 2011 at 6:20 am
Great! Thanks for the help on this. Sorry about the brain-fart on the 'value' thing, I was out all last week sick with vertigo so that's my excuse. 😀
February 28, 2011 at 2:44 pm
CirquedeSQLeil (2/28/2011)
gregory.anderson (2/28/2011)
CirquedeSQLeil (2/28/2011)
gregory.anderson (2/28/2011)
UMG Developer (2/28/2011)
gregory.anderson (2/28/2011)
February 28, 2011 at 11:58 am
CirquedeSQLeil (2/28/2011)
gregory.anderson (2/28/2011)
UMG Developer (2/28/2011)
gregory.anderson (2/28/2011)
February 28, 2011 at 11:35 am
UMG Developer (2/28/2011)
gregory.anderson (2/28/2011)
February 28, 2011 at 11:14 am
I have implemented this script but am getting the error "Invalid column name 'Value'" when running it. Is there something special that I need to do in order for Mgmt...
February 28, 2011 at 9:05 am
Jeff Moden (2/21/2011)
gregory.anderson (2/18/2011)
Been searching on how to concatenate rows into a single field and I found a link to a recursive CTE for unknown number of rows to concatenate,...
...
February 28, 2011 at 7:36 am
Been searching on how to concatenate rows into a single field and I found a link to a recursive CTE for unknown number of rows to concatenate, I incorporated that...
February 18, 2011 at 2:41 pm
Here's the output how it works now:
Row 1: CustomerNumber 111111, CustomerCredentialID 111123, LicenseRestrictionID 12341234, NCR1 Hi, NCR2 How, NCR3 Are, NCR4 You
Row 2: CustomerNumber 111111, CustomerCredentialID 111123, LicenseRestrictionID 12341235, NCR1...
February 18, 2011 at 9:39 am
Hey guys, I'm back! You all did such a wonderful job helping me with this one, that I have a new one that I'm working on and am close to...
February 18, 2011 at 9:33 am
Rabia Cinar Yuksel (11/9/2010)
November 9, 2010 at 8:34 am
TheSQLGuru (11/2/2010)
I hope you understand that if your job takes > 20 minutes to complete you will skip any 'overlapped' executions of the job.
Yep.
Right now, it's averaging about 12 minutes...
November 2, 2010 at 8:58 am
Ok, now it's doing it every 20 minutes from the start time like I wanted it to...I'm confused.
November 1, 2010 at 7:32 am
Viewing 15 posts - 61 through 75 (of 186 total)