mikaelweave

IF OBJECT_ID('dbo.Scores', 'U') IS NOT NULL DROP TABLE dbo.Scores; 

mikaelweave

Libraries

• jQuery - The de-facto library for the modern age. It makes things like HTML document traversal and manipulation, event handling, animation, and Ajax much simpler with an easy-to-use API that works across a multitude of browsers.
• Backbone - Backbone.js gives structure to web applications by providing models with key-value binding and custom events, collections with a rich API of enumerable functions, views with declarative event handling, and connects it all to your existing API over a RESTful JSON interface.
• AngularJS - Conventions based MVC framework for HTML5 apps.
• Underscore - Underscore is a utility-belt library for JavaScript that provides a lot of the functional programming support that you would expect in Prototype.js (or Ruby), but without extending any of the built-in JavaScript objects.
• lawnchair - Key/value store adapter for indexdb, localStorage

mikaelweave

 (select stuff(
         (
            select distinct ', ' + rtrim(pak_value) 
            from e_pstor 
            where e_pstor.ptype_id = '{55266899-ca35-4690-afaa-9af9b3b98ab2}' /* Code: Pharmacy Supplemental Clinical Rationale */
               and e_pstor.source_id = e_note.ct_id
               and e_pstor.pak_value > ''
            order by ', ' + rtrim(pak_value)
            for xml path(''),type).value('.','varchar(max)'),1,1,'')
   ) AS Pharmacy_Supplemental_Clinical_Rationale_value

mikaelweave

Write-Host ""
Write-Host "Starting App Pool Recycle...." -ForegroundColor Magenta
 
& $env:windir\system32\inetsrv\appcmd list apppools /state:Started /xml | & $env:windir\system32\inetsrv\appcmd recycle apppools /in
 
Write-Host "Recycle Complete" -ForegroundColor Magenta
Write-Host ""

mikaelweave

SELECT 
  FORMAT(GETDATE(), 'g'),
	CONVERT(VARCHAR(32), CAST(GETDATE() AS DATE), 101) AS d,
	REPLACE(REPLACE(RIGHT(CAST(GETDATE() AS DATETIME), 7), 'AM', ' AM'), 'PM', ' PM') AS t

mikaelweave

IF OBJECT_ID('tempdb..#TEMP') IS NOT NULL DROP TABLE #TEMP

--This will work since each delete is done as a single row
SELECT RowNum = ROW_NUMBER() OVER(ORDER BY ct_id), ct_id 
INTO #TEMP
FROM ct_note where ntype_id IN('{d94f685c-84ec-49b2-8e0f-ebaf9f6e609f}', '{afbf6d79-6d77-41e6-8790-9505e9b9ed82}', '{6cad622d-c3b7-4907-b62a-a882902ee4e4}')


DECLARE @MaxRownum INT
SET @MaxRownum = (SELECT MAX(RowNum) FROM #TEMP)

mikaelweave

IF OBJECT_ID('MySproc', 'P') IS NOT NULL
DROP PROC MySproc
GO

CREATE PROC MySproc
AS
BEGIN
	[CODE HERE]
END

mikaelweave

SELECT
	name
FROM
	ices.sys.tables
 WHERE
	name LIKE '%Line%'
	AND is_ms_shipped = 0;

mikaelweave

IF EXISTS(SELECT * FROM sys.views WHERE name = 'e_note' AND schema_id = SCHEMA_ID('dbo'))
  DROP VIEW dbo.e_note
GO

mikaelweave

FROM - http://stackoverflow.com/questions/325933/determine-whether-two-date-ranges-overlap
Let ConditionA Mean DateRange A Completely After DateRange B
(True if StartA > EndB)

Let ConditionB Mean DateRange A Completely Before DateRange B
(True if EndA < StartB)

Then Overlap exists if Neither A Nor B is true
( If one range is neither completely after the other,
nor completely before the other, then they must overlap)