gdoddsy

BEGIN TRAN
DECLARE @SourceExtension INT = 2443
        ,@DestinationExtension INT = 2544
        ,@WhatToCopy VARCHAR(255) = 'Console Buttons' --Console Buttons,Contact Favourites,Extension Favourites,Queue Favourites,Shortcuts



--DON'T CHANGE ANYTHING BELOW HERE!!!

gdoddsy

	<Window.TaskbarItemInfo>
		<TaskbarItemInfo ProgressValue="{Binding StepsProcessed}" ProgressState="{Binding ProgressState}" />
	</Window.TaskbarItemInfo>

gdoddsy

private void GenerateToast(string title, string message)
{
	var template = ToastTemplateType.ToastImageAndText02;
	var toastXML = ToastNotificationManager.GetTemplateContent(template);
	var images = toastXML.GetElementsByTagName("image");
	images[0].Attributes[1].NodeValue = @"file://**FilePath**\**FileName.png";

	var textNodes = toastXML.GetElementsByTagName("text");
	textNodes[0].AppendChild(toastXML.CreateTextNode(title));
	textNodes[1].AppendChild(toastXML.CreateTextNode(message));

gdoddsy

SELECT		Posts.Title,acceptedAnswer.CreationDate
FROM		dbo.Posts
LEFT JOIN	dbo.Posts AS acceptedAnswer
	   ON	acceptedAnswer.Id = Posts.AcceptedAnswerId
WHERE 		Posts.PostTypeId = 1

gdoddsy

SELECT		Posts.Title, acceptedAnswer.CreationDate, Users.DisplayName
FROM		dbo.Posts
LEFT JOIN	dbo.Posts AS acceptedAnswer
	   ON	acceptedAnswer.Id = Posts.AcceptedAnswerId

INNER JOIN	dbo.Users
		ON	acceptedAnswer.LastEditorUserId = Users.Id
WHERE		Posts.PostTypeId = 1

gdoddsy

--Use a Where Clause
SELECT		Posts.Title
			,acceptedAnswer.CreationDate
			,Users.DisplayName
FROM		dbo.Posts
LEFT JOIN	dbo.Posts AS acceptedAnswer
	   ON	acceptedAnswer.Id = Posts.AcceptedAnswerId

LEFT JOIN	dbo.Users
		ON	acceptedAnswer.LastEditorUserId = Users.Id

gdoddsy

use tempdb
GO

CREATE TABLE dbo.Test1
(
	Col1 VARCHAR(6) NOT NULL PRIMARY KEY
)

GO

gdoddsy

DBCC TRACEON(460)

gdoddsy

CREATE TABLE AggregateTest
(
	ID				  INT		   IDENTITY(1, 1) PRIMARY KEY NOT NULL
	,Gate			  VARCHAR(5)   NULL
	,LastUsedDateTime DATETIME2(7) NULL
)

gdoddsy

INSERT INTO 	AggregateTest (Gate, LastUsedDateTime)
SELECT		Gate
		MAX(RecordedTime)
FROM		SFOGateInfo
GROUP BY	Gate