API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2018
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.17 KB | None | 0 0
raw download clone embed print report
  1. USE [master]
  2. GO
  3. /****** Object: Database [MarketingStrategy] Script Date: 2/22/2018 11:39:14 AM ******/
  4. CREATE DATABASE [MarketingStrategy]
  5. CONTAINMENT = NONE
  6. ON PRIMARY
  7. ( NAME = N'MarketingStrategy', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MarketingStrategy.mdf' , SIZE = 10240KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  8. LOG ON
  9. ( NAME = N'MarketingStrategy_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MarketingStrategy_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
  10. GO
  11. ALTER DATABASE [MarketingStrategy] SET COMPATIBILITY_LEVEL = 110
  12. GO
  13. IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
  14. begin
  15. EXEC [MarketingStrategy].[dbo].[sp_fulltext_database] @action = 'enable'
  16. end
  17. GO
  18. ALTER DATABASE [MarketingStrategy] SET ANSI_NULL_DEFAULT OFF
  19. GO
  20. ALTER DATABASE [MarketingStrategy] SET ANSI_NULLS OFF
  21. GO
  22. ALTER DATABASE [MarketingStrategy] SET ANSI_PADDING OFF
  23. GO
  24. ALTER DATABASE [MarketingStrategy] SET ANSI_WARNINGS OFF
  25. GO
  26. ALTER DATABASE [MarketingStrategy] SET ARITHABORT OFF
  27. GO
  28. ALTER DATABASE [MarketingStrategy] SET AUTO_CLOSE OFF
  29. GO
  30. ALTER DATABASE [MarketingStrategy] SET AUTO_CREATE_STATISTICS ON
  31. GO
  32. ALTER DATABASE [MarketingStrategy] SET AUTO_SHRINK OFF
  33. GO
  34. ALTER DATABASE [MarketingStrategy] SET AUTO_UPDATE_STATISTICS ON
  35. GO
  36. ALTER DATABASE [MarketingStrategy] SET CURSOR_CLOSE_ON_COMMIT OFF
  37. GO
  38. ALTER DATABASE [MarketingStrategy] SET CURSOR_DEFAULT GLOBAL
  39. GO
  40. ALTER DATABASE [MarketingStrategy] SET CONCAT_NULL_YIELDS_NULL OFF
  41. GO
  42. ALTER DATABASE [MarketingStrategy] SET NUMERIC_ROUNDABORT OFF
  43. GO
  44. ALTER DATABASE [MarketingStrategy] SET QUOTED_IDENTIFIER OFF
  45. GO
  46. ALTER DATABASE [MarketingStrategy] SET RECURSIVE_TRIGGERS OFF
  47. GO
  48. ALTER DATABASE [MarketingStrategy] SET DISABLE_BROKER
  49. GO
  50. ALTER DATABASE [MarketingStrategy] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
  51. GO
  52. ALTER DATABASE [MarketingStrategy] SET DATE_CORRELATION_OPTIMIZATION OFF
  53. GO
  54. ALTER DATABASE [MarketingStrategy] SET TRUSTWORTHY OFF
  55. GO
  56. ALTER DATABASE [MarketingStrategy] SET ALLOW_SNAPSHOT_ISOLATION OFF
  57. GO
  58. ALTER DATABASE [MarketingStrategy] SET PARAMETERIZATION SIMPLE
  59. GO
  60. ALTER DATABASE [MarketingStrategy] SET READ_COMMITTED_SNAPSHOT OFF
  61. GO
  62. ALTER DATABASE [MarketingStrategy] SET HONOR_BROKER_PRIORITY OFF
  63. GO
  64. ALTER DATABASE [MarketingStrategy] SET RECOVERY SIMPLE
  65. GO
  66. ALTER DATABASE [MarketingStrategy] SET MULTI_USER
  67. GO
  68. ALTER DATABASE [MarketingStrategy] SET PAGE_VERIFY CHECKSUM
  69. GO
  70. ALTER DATABASE [MarketingStrategy] SET DB_CHAINING OFF
  71. GO
  72. ALTER DATABASE [MarketingStrategy] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
  73. GO
  74. ALTER DATABASE [MarketingStrategy] SET TARGET_RECOVERY_TIME = 0 SECONDS
  75. GO
  76. USE [MarketingStrategy]
  77. GO
  78. /****** Object: Table [dbo].[tblBudget] Script Date: 2/22/2018 11:39:14 AM ******/
  79. SET ANSI_NULLS ON
  80. GO
  81. SET QUOTED_IDENTIFIER ON
  82. GO
  83. CREATE TABLE [dbo].[tblBudget](
  84. [ID] [int] NOT NULL,
  85. [BudgetFY] [nvarchar](255) NULL,
  86. [Category] [nvarchar](255) NULL,
  87. [SubCategory1] [nvarchar](255) NULL,
  88. [SubCategory2] [nvarchar](255) NULL,
  89. [SubCategory3] [nvarchar](255) NULL,
  90. [SubCategory4] [nvarchar](255) NULL,
  91. [FullName] [nvarchar](max) NULL,
  92. [ExpenseCategory] [int] NULL,
  93. [Responsible] [nvarchar](255) NULL,
  94. [BudgetOrigin] [nvarchar](255) NULL,
  95. [TotalAmount] [money] NULL
  96. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  97.  
  98. GO
  99. /****** Object: Table [dbo].[tblExpenseCategory] Script Date: 2/22/2018 11:39:14 AM ******/
  100. SET ANSI_NULLS ON
  101. GO
  102. SET QUOTED_IDENTIFIER ON
  103. GO
  104. CREATE TABLE [dbo].[tblExpenseCategory](
  105. [ID] [int] NOT NULL,
  106. [ExpenseCategory] [nvarchar](255) NULL,
  107. [GLAccount] [nvarchar](255) NULL
  108. ) ON [PRIMARY]
  109.  
  110. GO
  111. /****** Object: Table [dbo].[tblInvoices] Script Date: 2/22/2018 11:39:14 AM ******/
  112. SET ANSI_NULLS ON
  113. GO
  114. SET QUOTED_IDENTIFIER ON
  115. GO
  116. CREATE TABLE [dbo].[tblInvoices](
  117. [ID] [int] NOT NULL,
  118. [InvoiceDate] [datetime] NULL,
  119. [AcctPeriod] [datetime] NULL,
  120. [InvoiceNumber] [nvarchar](255) NULL,
  121. [InvoiceAmount] [money] NULL,
  122. [InvoiceStatus] [nvarchar](255) NULL,
  123. [PONumber] [nvarchar](255) NULL,
  124. [POTitle] [nvarchar](255) NULL,
  125. [POVendor] [nvarchar](255) NULL,
  126. [POFullName] [nvarchar](max) NULL,
  127. [InvoiceComments] [nvarchar](max) NULL,
  128. [InvoiceAttachments] [nvarchar](max) NULL
  129. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  130.  
  131. GO
  132. /****** Object: Table [dbo].[tblPeriods] Script Date: 2/22/2018 11:39:14 AM ******/
  133. SET ANSI_NULLS ON
  134. GO
  135. SET QUOTED_IDENTIFIER ON
  136. GO
  137. CREATE TABLE [dbo].[tblPeriods](
  138. [ID] [int] NOT NULL,
  139. [Period] [nvarchar](255) NULL,
  140. [Open] [bit] NOT NULL
  141. ) ON [PRIMARY]
  142.  
  143. GO
  144. /****** Object: Table [dbo].[tblPO] Script Date: 2/22/2018 11:39:14 AM ******/
  145. SET ANSI_NULLS ON
  146. GO
  147. SET QUOTED_IDENTIFIER ON
  148. GO
  149. CREATE TABLE [dbo].[tblPO](
  150. [ID] [int] NOT NULL,
  151. [DateCreated] [datetime] NULL,
  152. [PONumber] [nvarchar](255) NULL,
  153. [PRNumber] [nvarchar](255) NULL,
  154. [Title] [nvarchar](255) NULL,
  155. [TotalOrdered] [money] NULL,
  156. [Vendor] [nvarchar](255) NULL,
  157. [BudgetCategory] [int] NULL,
  158. [VP] [nvarchar](255) NULL,
  159. [Budget] [nvarchar](255) NULL,
  160. [ProjectStatus] [nvarchar](255) NULL,
  161. [POComments] [nvarchar](max) NULL,
  162. [POAttachments] [nvarchar](max) NULL
  163. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  164.  
  165. GO
  166. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (1, N'2018', N'Global Marketing Strategy', N'Bold Brand Activation', N'Corporate Brand Strategy', N'Employee Engagament Strategy', NULL, N'Bold Brand Activation - Employee Engagament Strategy', 5, NULL, N'GMS', 250000.0000)
  167. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (2, N'2018', N'Global Marketing Strategy', N'Bold Brand Activation', N'Global Brand Architecture Activation', N'Organizational Sub-brand Strategy Activation', NULL, N'Bold Brand Activation - Organizational Sub-brand Strategy Activation', 2, NULL, N'GMS', 300000.0000)
  168. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (3, N'2018', N'Global Marketing Strategy', N'Bold Brand Activation', N'Global Brand Architecture Activation', N'Naming System', NULL, N'Bold Brand Activation - Naming System', 7, NULL, N'GMS', 250000.0000)
  169. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (4, N'2018', N'Global Marketing Strategy', N'Bold Brand Activation', N'Global Brand Architecture Activation', N'Global Guidelines', NULL, N'Bold Brand Activation - Global Guidelines', 6, NULL, N'GMS', 175000.0000)
  170. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (5, N'2018', N'Global Marketing Strategy', N'Bold Brand Activation', N'Global Thought Leadership', N'US/Global B2B Platform Activation', NULL, N'Bold Brand Activation - US/Global B2B Platform Activation', NULL, NULL, N'GMS', 150000.0000)
  171. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (6, N'2018', N'Global Marketing Strategy', N'Bold Brand Activation', N'Global Thought Leadership', N'Asia Regional Platform Development/Activation', NULL, N'Bold Brand Activation - Asia Regional Platform Development/Activation', NULL, NULL, N'GMS', 150000.0000)
  172. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (7, N'2018', N'Global Marketing Strategy', N'Bold Brand Activation', N'Localized Brand Strategy', N'Playbook and Strategy Toolkit', NULL, N'Bold Brand Activation - Playbook and Strategy Toolkit', NULL, NULL, N'GMS', 115000.0000)
  173. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (8, N'2018', N'Global Marketing Strategy', N'Bold Brand Activation', N'Localized Brand Strategy', N'Facilitation of Localized Strategy Activation', NULL, N'Bold Brand Activation - Facilitation of Localized Strategy Activation', NULL, NULL, N'GMS', 115000.0000)
  174. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (9, N'2018', N'Global Marketing Strategy', N'Bold Brand Activation', N'Localized Brand Strategy', N'Integration of Local Plans into Global Framework', NULL, N'Bold Brand Activation - Integration of Local Plans into Global Framework', NULL, NULL, N'GMS', 45000.0000)
  175. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (10, N'2018', N'Global Marketing Strategy', N'Scaling GTM Strategies', N'CVP Development', N'EMEA Banca: Segment Insights, Concept Development, Testing', NULL, N'Scaling GTM Strategies - EMEA Banca: Segment Insights, Concept Development, Testing', NULL, NULL, N'GMS', 165000.0000)
  176. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (11, N'2018', N'Global Marketing Strategy', N'Scaling GTM Strategies', N'CVP Development', N'MIM: Segment Insights', NULL, N'Scaling GTM Strategies - MIM: Segment Insights', NULL, NULL, N'GMS', 55000.0000)
  177. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (12, N'2018', N'Global Marketing Strategy', N'Scaling GTM Strategies', N'CVP Activation', N'Pilot Design, Activation, Measurement', NULL, N'Scaling GTM Strategies - Pilot Design, Activation, Measurement', NULL, NULL, N'GMS', 470000.0000)
  178. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (13, N'2018', N'Global Marketing Strategy', N'Scaling GTM Strategies', N'CVP Activation', N'Move Concept Research and Development', NULL, N'Scaling GTM Strategies - Move Concept Research and Development', NULL, NULL, N'GMS', 155000.0000)
  179. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (14, N'2018', N'Global Marketing Strategy', N'Scaling GTM Strategies', N'CVP Activation', N'Scaled Implementation', NULL, N'Scaling GTM Strategies - Scaled Implementation', NULL, NULL, N'GMS', 125000.0000)
  180. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (15, N'2018', N'Global Marketing Strategy', N'Scaling GTM Strategies', N'Asia Health', N'Insights, Concept Development, Roadmap, Business Case', NULL, N'Scaling GTM Strategies - Insights, Concept Development, Roadmap, Business Case', NULL, NULL, N'GMS', 0.0000)
  181. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (16, N'2018', N'Global Marketing Strategy', N'Scaling GTM Strategies', N'US Financial Wellness', N'US Financial Wellness: Segment insights', NULL, N'Scaling GTM Strategies - US Financial Wellness: Segment insights', NULL, NULL, N'GMS', 100000.0000)
  182. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (17, N'2018', N'Global Marketing Strategy', N'Scaling GTM Strategies', N'Next Generation Distribution', N'Global/Regional Segmentation: Framework Design', NULL, N'Scaling GTM Strategies - Global/Regional Segmentation: Framework Design', NULL, NULL, N'GMS', 100000.0000)
  183. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (18, N'2018', N'Global Marketing Strategy', N'Scaling GTM Strategies', N'Next Generation Distribution', N'Concept Development: Testing', NULL, N'Scaling GTM Strategies - Concept Development: Testing', NULL, NULL, N'GMS', 200000.0000)
  184. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (19, N'2018', N'Global Marketing Strategy', N'Product Development Optimization', N'Global Products', N'Global Product Proposition and Positioning', NULL, N'Product Development Optimization - Global Product Proposition and Positioning', NULL, NULL, N'GMS', 100000.0000)
  185. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (20, N'2018', N'Global Marketing Strategy', N'Product Development Optimization', N'Global Products', N'Roadmap and Playbook for Localized Commercialization', NULL, N'Product Development Optimization - Roadmap and Playbook for Localized Commercialization', NULL, NULL, N'GMS', 50000.0000)
  186. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (21, N'2018', N'Global Marketing Strategy', N'Product Development Optimization', N'Category Management Strategy', N'Category Portfolio Structure/Naming', NULL, N'Product Development Optimization - Category Portfolio Structure/Naming', NULL, NULL, N'GMS', 100000.0000)
  187. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (23, N'2018', N'Global Marketing Strategy', N'Product Development Optimization', N'Category Management Strategy', N'(Re-) design Key Marketing and Sales Assets', NULL, N'Product Development Optimization - (Re-) design Key Marketing and Sales Assets', NULL, NULL, N'GMS', 100000.0000)
  188. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (24, N'2018', N'Global Marketing Strategy', N'Product Development Optimization', N'Global Value Added Services (VAS)', N'Opportunity Prioritization by Goes/Segments', NULL, N'Product Development Optimization - Opportunity Prioritization by Goes/Segments', NULL, NULL, N'GMS', 100000.0000)
  189. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (25, N'2018', N'Global Marketing Strategy', N'Customer Relationship', N'CLM Framework', N'Strategic Framework for B2B/B2C Models', NULL, N'Customer Relationship - Strategic Framework for B2B/B2C Models', NULL, NULL, N'GMS', 250000.0000)
  190. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (26, N'2018', N'Global Marketing Strategy', N'Demand Management', N'Full Funnel Marketing Toolkits', N'ADA Playbooks', NULL, N'Demand Management - ADA Playbooks', NULL, NULL, N'GMS', 250000.0000)
  191. INSERT [dbo].[tblBudget] ([ID], [BudgetFY], [Category], [SubCategory1], [SubCategory2], [SubCategory3], [SubCategory4], [FullName], [ExpenseCategory], [Responsible], [BudgetOrigin], [TotalAmount]) VALUES (27, NULL, NULL, NULL, NULL, NULL, NULL, N' - ', NULL, NULL, NULL, NULL)
  192. INSERT [dbo].[tblExpenseCategory] ([ID], [ExpenseCategory], [GLAccount]) VALUES (2, N'Customer Value Proposition Development', N'6441000400')
  193. INSERT [dbo].[tblExpenseCategory] ([ID], [ExpenseCategory], [GLAccount]) VALUES (3, N'Brand Strategy', N'6441000400')
  194. INSERT [dbo].[tblExpenseCategory] ([ID], [ExpenseCategory], [GLAccount]) VALUES (4, N'Digital Marketing Strategy', N'6441000400')
  195. INSERT [dbo].[tblExpenseCategory] ([ID], [ExpenseCategory], [GLAccount]) VALUES (5, N'Customer Experience Strategy', N'6441000400')
  196. INSERT [dbo].[tblExpenseCategory] ([ID], [ExpenseCategory], [GLAccount]) VALUES (6, N'Product, Pricing, and Portfolio Management', N'6441000400')
  197. INSERT [dbo].[tblExpenseCategory] ([ID], [ExpenseCategory], [GLAccount]) VALUES (7, N'Other', N'6441000400')
  198. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (1, N'201801', 1)
  199. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (2, N'201802', 1)
  200. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (3, N'201803', 1)
  201. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (4, N'201804', 1)
  202. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (5, N'201805', 1)
  203. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (6, N'201806', 1)
  204. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (7, N'201807', 1)
  205. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (8, N'201808', 1)
  206. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (9, N'201809', 1)
  207. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (10, N'201810', 1)
  208. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (11, N'201811', 0)
  209. INSERT [dbo].[tblPeriods] ([ID], [Period], [Open]) VALUES (12, N'201812', 0)
  210. INSERT [dbo].[tblPO] ([ID], [DateCreated], [PONumber], [PRNumber], [Title], [TotalOrdered], [Vendor], [BudgetCategory], [VP], [Budget], [ProjectStatus], [POComments], [POAttachments]) VALUES (2, CAST(N'2018-02-15 00:00:00.000' AS DateTime), N'11000-2001230644', N'PR316908', N'CG42: Corporate Brand Story Functional Frameworks', 125000.0000, N'CG42 LLC', 1, N'Colin Smyth', N'GMS', N'Started', NULL, N'MSS_cg42_CORPORATE BRAND STORY FUNCTIONAL FRAMEWORKS_SOW_20180122_SIGNED CKB.pdf;MSS_cg42_CORPORATE BRAND STORY FUNCTIONAL FRAMEWORKS_SOW_20180122_SIGNED.pdf;US CEAR Form_CORPORATE BRAND STORY FUNCTIONAL FRAMEWORKS_Signed 20180205.pdf')
  211. INSERT [dbo].[tblPO] ([ID], [DateCreated], [PONumber], [PRNumber], [Title], [TotalOrdered], [Vendor], [BudgetCategory], [VP], [Budget], [ProjectStatus], [POComments], [POAttachments]) VALUES (3, CAST(N'2018-02-15 00:00:00.000' AS DateTime), N'11000-2001230647', N'PR316883', N'Prophet Brand Strategies: Brand Architecture Category Activation', 292936.0000, N'PROPHET BRAND STRATEGY INC', 8, N'Sameer Agarwal', N'GMS', N'Started', NULL, N'MSS_PROPHET_BA_BRAND ARCHITECTURE CATEGORY ACTIVATION 20180502_ SIGNED CKB.pdf;MSS_PROPHET_BA_BRAND ARCHITECTURE CATEGORY ACTIVATION 20180502_ SIGNED.pdf')
  212. INSERT [dbo].[tblPO] ([ID], [DateCreated], [PONumber], [PRNumber], [Title], [TotalOrdered], [Vendor], [BudgetCategory], [VP], [Budget], [ProjectStatus], [POComments], [POAttachments]) VALUES (4, CAST(N'2018-02-20 00:00:00.000' AS DateTime), N'11000-2001231255', N'PR316875', N'Prophet Brand Strategies: Brand Architecture Product Naming Guidelines', 192500.0000, N'PROPHET BRAND STRATEGY INC', 3, N'Sameer Agarwal', N'GMS', N'Started', NULL, N'MSS_PROPHET_BA_BRAND ARCHITECTURE PRODUCT NAMING GUIDELINE 20180502_SIGNED CKB.pdf;MSS_PROPHET_BA_BRAND ARCHITECTURE PRODUCT NAMING GUIDELINE 20180502_SIGNED.pdf')
  213. INSERT [dbo].[tblPO] ([ID], [DateCreated], [PONumber], [PRNumber], [Title], [TotalOrdered], [Vendor], [BudgetCategory], [VP], [Budget], [ProjectStatus], [POComments], [POAttachments]) VALUES (5, CAST(N'2018-02-15 00:00:00.000' AS DateTime), N'11000-2001230643', N'PR316896', N'CG42: Employee Value Proposition', 150000.0000, N'CG42 LLC', 1, N'Colin Smyth', N'GMS', N'Started', NULL, N'MSS_cg42_EMPLOYEE VALUE PROPOSITION_SOW_20180123_SIGNED CKB.pdf;MSS_cg42_EMPLOYEE VALUE PROPOSITION_SOW_20180123_SIGNED.pdf;US CEAR Form_EMPLOYEE VALUE PROPOSITION_Signed 20180205.pdf')
  214. INSERT [dbo].[tblPO] ([ID], [DateCreated], [PONumber], [PRNumber], [Title], [TotalOrdered], [Vendor], [BudgetCategory], [VP], [Budget], [ProjectStatus], [POComments], [POAttachments]) VALUES (6, NULL, NULL, NULL, N'Prophet Brand Strategies: MetLife Foundation Strategy', 220000.0000, N'PROPHET BRAND STRATEGY INC', 2, N'Anne Park', N'GMS', N'Started', NULL, N'MSS_PROPHET_METLIFE_FOUNDATION_STRATEGY_20180220_ SIGNED CKB.pdf;MSS_PROPHET_METLIFE_FOUNDATION_STRATEGY_20180220_ SIGNED.pdf')
  215. INSERT [dbo].[tblPO] ([ID], [DateCreated], [PONumber], [PRNumber], [Title], [TotalOrdered], [Vendor], [BudgetCategory], [VP], [Budget], [ProjectStatus], [POComments], [POAttachments]) VALUES (7, NULL, NULL, N'PR320252', N'CG42: MetLife Investment Management Positioning Phase 1', 100000.0000, N'CG42 LLC', 11, N'Sameer Agarwal', N'GMS', N'Started', NULL, N'MSS_cg42_METLIFE INVESTMENT MANAGEMENT POSITIONING PHASE 1 20180215 CKB.pdf;MSS_cg42_METLIFE INVESTMENT MANAGEMENT POSITIONING PHASE 1 20180215.pdf;US CEAR Form_METLIFE INVESTMENT MANAGEMENT POSITIONING PHASE 1_Signed.pdf')
  216. INSERT [dbo].[tblPO] ([ID], [DateCreated], [PONumber], [PRNumber], [Title], [TotalOrdered], [Vendor], [BudgetCategory], [VP], [Budget], [ProjectStatus], [POComments], [POAttachments]) VALUES (1, CAST(N'2018-02-15 00:00:00.000' AS DateTime), N'11000-2001230642', N'PR316888', N'CG42: Employee Focus Group Research', 100000.0000, N'CG42 LLC', 1, N'Colin Smyth', N'GMS', N'Started', NULL, N'MSS_cg42_EMPLOYEE FOCUS GROUP RESEARCH_20180202_SIGNED CKB.pdf;MSS_cg42_EMPLOYEE FOCUS GROUP RESEARCH_20180202_SIGNED.pdf')
  217. USE [master]
  218. GO
  219. ALTER DATABASE [MarketingStrategy] SET READ_WRITE
  220. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!