Stuff About Dynamics CRM

https://stackoverflow.com/questions/9211173/sql-top-parent-record-in-hierarchy

SELECT  spid,         sp.[status],         loginame [Login],         hostname,         blocked BlkBy,         sd.name DBName,         ...

select  crmuserid  --reference to the SystemUserId in CRM ,suo.userid  --reference to the SystemUserAuthentication table ,AuthInfo ,do...

Select DateAdd(minute, DateDiff(minute, 0, ModifiedOn), 0) AS [DAY_MINUTE], Count(*) AS [TOTAL_MINUTE] , Count(*) / 60.0 AS [TOTAL_SECOND...

select LastRunTime, CASE OperationType        WHEN 14 THEN 'DeletionService'        WHEN 15 THEN 'IndexManagement'   ...

SET NOCOUNT ON SELECT Convert(varchar(20),SERVERPROPERTY('ServerName')) AS ServerName, j.name AS job_name, CASE j.enabled WHEN 1 ...

declare @dt datetime select @dt = getdate()-4 --select @dt  IF OBJECT_ID('tempdb..#audit') IS NOT NULL DROP TABLE #audit;  IF ...