Viewing 15 posts - 1 through 15 (of 34 total)
CREATE PROCEDURE ArchiveCampaignData
@CampaignId INT,
@DeleteBatchOf INT
AS
BEGIN
DELETE TOP (@DeleteBatchOf)FROM dbo.u_activity
OUTPUT DELETED.* INTO u_activity_archive
WHERE campaignId...
July 3, 2017 at 9:12 am
July 3, 2017 at 9:08 am
For cases when I have the Inner Join the Output will be no good ? as I'm unable to Join back
Unless there is a different way about going...
June 28, 2017 at 1:47 am
June 27, 2017 at 8:11 am
But the Output would only be good for returning errors ?
June 27, 2017 at 7:22 am
February 24, 2017 at 8:44 am
CREATE TABLE...
February 24, 2017 at 8:40 am
I have taken a look at the Lead and Lag function they look useful but I'm having a issue to try an implement this is my situation
The problem...
February 24, 2017 at 8:19 am
January 27, 2017 at 5:32 am
January 27, 2017 at 5:14 am
January 27, 2017 at 4:53 am
no foreign keys are being used
October 31, 2016 at 8:30 am
odid has a non clustered index on it..
October 28, 2016 at 9:26 am
indicies ? do you mean indexes ?
October 28, 2016 at 9:03 am
Viewing 15 posts - 1 through 15 (of 34 total)