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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy