SHARE
TWEET

Knowledge Item Upload

a guest Jun 25th, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-01-01' AND '2019-01-31' AND Status = 'ENABLED') AS `January 2019`,
  3.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-02-01' AND '2019-02-31' AND Status = 'ENABLED') AS `February 2019`,
  4.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-03-01' AND '2019-03-31' AND Status = 'ENABLED') AS `March 2019`,
  5.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-04-01' AND '2019-04-31' AND Status = 'ENABLED') AS `April 2019`,
  6.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-05-01' AND '2019-05-31' AND Status = 'ENABLED') AS `May 2019`,
  7.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-06-01' AND '2019-06-31' AND Status = 'ENABLED') AS `June 2019`,
  8.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-07-01' AND '2019-07-31' AND Status = 'ENABLED') AS `July 2019`,
  9.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-08-01' AND '2019-08-31' AND Status = 'ENABLED') AS `August 2019`,
  10.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-09-01' AND '2019-09-31' AND Status = 'ENABLED') AS `September 2019`,
  11.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-10-01' AND '2019-10-31' AND Status = 'ENABLED') AS `October 2019`,
  12.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-11-01' AND '2019-11-31' AND Status = 'ENABLED') AS `November 2019`,
  13.     (SELECT COUNT(*) FROM tbl_KNOWLEDGE_Item AS `Item` WHERE `Item`.DateCreated BETWEEN '2019-12-01' AND '2019-12-31' AND Status = 'ENABLED') AS `December 2019`
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top