USE [dbBTFGrid30_Test_Core]
GO
/****** Object: StoredProcedure [dbo].[ntc_updatePublishDate] Script Date: 04/16/2013 10:14:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: quan.tran
-- Create date: 2013/04/11
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[ntc_updatePublishDate]
(
@pageId INT,
@createdDate DATETIME,
@startPublishDate DATETIME
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
UPDATE dbo.tblWorkContent SET Created=@createdDate,Saved=@createdDate,StartPublish=@startPublishDate WHERE fkContentID=@pageId
UPDATE dbo.tblContentLanguage SET Created=@createdDate,Saved=@createdDate,StartPublish=@startPublishDate WHERE fkContentID=@pageId
END
GO
/****** Object: StoredProcedure [dbo].[ntc_getAllPageDataByDateCreatedDate] Script Date: 04/16/2013 10:14:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: quan.tran
-- Create date: 2013/04/10
-- Description: Get all artcles by created date
-- =============================================
CREATE PROCEDURE [dbo].[ntc_getAllPageDataByDateCreatedDate]
(
@startDate datetime,
@endDate datetime
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT
c.pkID AS PageId,
wc.pkID AS WorkId,
wc.Name AS PageName,
wc.Created AS CreatedDate,
wc.Saved AS SavedDate,
wc.StartPublish AS StartPublishDate
FROM tblWorkContent wc
INNER JOIN tblContent c
ON wc.fkContentID = c.pkID
INNER JOIN tblContentType ct
ON c.fkContentTypeID = ct.pkID
WHERE ct.Name = 'ArticlePageData' AND wc.CommonDraft = 1
AND wc.Created >=@startDate AND wc.Created<=@endDate
ORDER BY wc.Created
END
GO
Loading...