jerfowler

USE [ImageRight]
GO

WITH Source as (
	SELECT FT.[filetypeid]
		,FT.[itemid]
		,FT.[parentid]
		,FT.[single]
		,FT.[objecttypeid]
		,CASE O.[classid] WHEN -3 THEN 'File' WHEN -2 THEN 'Folder' WHEN -1 THEN 'Document' END as [type]

jerfowler

INSERT INTO [CIS].[dbo].[DocumentQuery] ([Name] ,[SQL] ,[ActiveFlag])
VALUES
('GL_Detail_Custom'
,'SELECT GL.[Code]
 ,GL.[CodeDescription]
 ,GL.[DateAdded]
 ,GL.[DateDropped]
 ,GL.[Sales] as [Exposure]
 ,GL.[FlagDropped]
 ,GL.[FlagRackleyRated]

jerfowler

USE [CIS]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[dvReportActivityDump]

jerfowler

@ECHO OFF
C:\WINDOWS\system32\wscript.exe unprotect.vbs

jerfowler

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
USE CIS
GO

-- =============================================
-- Author:  	Jeremy Fowler
-- Create date: 3/25/2013

jerfowler

DECLARE
  @Date DateTime,
  @FirstDay DateTime,
  @LastDay DateTime,
  @PriorFirstDay DateTime,
  @PriorLastDay DateTime

SET @Date='2/15/2013'

SELECT @FirstDay = CAST(MONTH(@Date) as varchar(2))+'/1/'+CAST(YEAR(@Date) as varchar(4))