/* 
 * Including this file will modify the existing jquery.unique method
 * to use the sourceIndex property of an element, if it exists.  If it
 * doesn't exist, this file does nothing.
 *
 * Use this file if your users are using a browser that supports
 * the sourceIndex property because it makes element comparison
 * much faster than the new, refactored, approaches in Sizzle.
 */
(function ($) {

///
///validate args
///
if (args.Length > 3)
{
    string msg = "You can use a maximum of 3 arguements.";
    ShowHelp(msg);
    throw new Exception(msg);
}
else if (args.Length == 3)

using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
 
namespace DictionaryKeyPerf
{
    #region dictionary keys
    internal enum EnumKey
    {

SELECT r.callDate + r.CallTime 
     ,r.Ticker 
     ,r.CallType 
     COUNT('x') OVER(PARTITION BY r.CallTime) as Cnt 
FROM ccnsource.reports r (NOLOCK) 
WHERE r.callDate = dbo.fnc_datedate(getdate()) 
ORDER BY 4 DESC

The following extensions methods can help you in the situation below:
 
        public static TResult IfNotNull<TSource, TResult>(this TSource obj, Func<TSource, TResult> func)
        {
            return IfNotNull(obj, func, default(TResult));
        }
        public static TResult IfNotNull<TSource, TResult>(this TSource obj, Func<TSource, TResult> func, TResult defaultIfNull)
        {
            return obj == null ? defaultIfNull : func(obj);
        }

DECLARE #resendEvents TABLE (NCEId INT PRIMARY KEY IDENTITY)
 
INSERT #resendEvents (NCEId)
SELECT NCEId
FROM ccnsource.newcompleteevents nce (NOLOCK)
WHERE nce.DateTimeStamp BETWEEN '2009-09-10 05:15' AND GetDate()
    AND nce.CompletionStatus & 128 = 128
 
-- MARK FOR RESEND
UPDATE nce