karoltheguy

SELECT 
		CONVERT(varchar(19), t.completed AT TIME ZONE 'UTC' AT TIME ZONE 'US Eastern Standard Time') AS 'Completed'
		,m.n.value('./@value', 'varchar(100)') AS One_Bill_Account_Number
		,p.n.value('./@value', 'varchar(100)') AS Suspension_Start_Date
		,o.n.value('./@value', 'varchat(100)') AS Suspension_End_Date
  FROM (SELECT status, completed, queueident, loaded, CAST(data AS xml) AS data FROM BPAWorkQueueItem)t
  CROSS APPLY t.data.nodes('/collection/row/field[./@name="One Bill Account Number"]')m(n)
  CROSS APPLY t.data.nodes('/collection/row/field[./@name="Suspension Start Date"]')p(n)
  CROSS APPLY t.data.nodes('/collection/row/field[./@name="Suspension End Date"]')o(n)

karoltheguy

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'xp_cmdshell',1;
RECONFIGURE
GO

CREATE TABLE TempProcessStore ([RowNo] [smallint] identity (1, 1)
								,[name]		nvarchar(128)

karoltheguy

@for /F "tokens=1,2,3 skip=1 delims=," %%A in (test.txt) do (
@echo I am at %%A using login %%B:%%C
)

karoltheguy

CREATE FUNCTION dbo.CreateHTMLTable(@SelectForXmlRawElementsXsinil XML)
RETURNS XML
AS
BEGIN

RETURN
(
    SELECT  
    @SelectForXmlRawElementsXsinil.query('let $first:=/row[1]
                return 

karoltheguy

CREATE FUNCTION [dbo].[SplitString]
    (
        @List NVARCHAR(MAX),
        @Delim VARCHAR(255)
    )
    RETURNS TABLE
    AS
        RETURN ( SELECT [Value] FROM 
          ( 
            SELECT 

karoltheguy

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	Carol Ouellet
-- Create date: 2017-04-21
-- Description:	Determine if given date is within DST clock shift
-- =============================================
CREATE FUNCTION IsDaylightSavingTime 

karoltheguy

public class ObservableDictionary<TKey, TValue> : IDictionary<TKey, TValue>, INotifyCollectionChanged, INotifyPropertyChanged
    {
        private const string CountString = "Count";
        private const string IndexerName = "Item[]";
        private const string KeysName = "Keys";
        private const string ValuesName = "Values";

        private IDictionary<TKey, TValue> _Dictionary;
        protected IDictionary<TKey, TValue> Dictionary
        {

karoltheguy

(dir -exclude *.g.cs,*.i.cs,*.designer.cs,assemblyinfo.cs,app.* -include *.cs,*.xaml -recurse | select-string .).Count
//Missing exclusion of empty lines and comments(?)

karoltheguy

using System;
using System.Threading;
using WFICALib;

    class Program
    {
        public static AutoResetEvent onLogonResetEvent = null;

        /// This program demo's the basic of launching and ICO session from within an application.
        static void Main(string[] args)

karoltheguy

Sub SendReply(Item As Outlook.MailItem)
  
Dim strRecip As String
Dim Recipient As Outlook.Recipient
Dim objMsg As MailItem
'Save a template with a the content you want to reply and the CC addresses if needed, nothing else.
Set objMsg = Application.CreateItemFromTemplate("path of template .oft")


'Add sender of original email