dcs619

var member = function(){
  var name = 'David';
  var age = '24';
  var status = 'married';
  function createMember(){
    // [...]
  }
  function getMemberDetails(){
    // [...]
  }

dcs619

select concat('or ', column_name, ' like ''%KidSpring%''')
from information_schema.columns
where table_name = 'exp_channel_data'
and column_name like 'field%'

select entry_id
from exp_channel_data
where channel_id = 35
and (
field_id_4 like '%KidSpring%'

dcs619

lblInfo.Text = string.Format( "Device IP: {0} {1} Name: {2}", ipAddress, Environment.NewLine, hostName );
var localaddr = Request.ServerVariables["LOCAL_ADDR"];
lblInfo.Text += "<br> local" + localaddr;
var remoteHost = Request.ServerVariables["REMOTE_HOST"];
lblInfo.Text += "<br> remote" + remoteHost;
var getclient = GetClientIPAddress();
lblInfo.Text += "<br> getclient" + getclient;
var remoteaddr = Request.ServerVariables["REMOTE_ADDR"];
lblInfo.Text += "<br> remote" + remoteaddr;
//(Request.ServerVariables["HTTP_X_FORWARDED_FOR"]) ? Request.ServerVariables["REMOTE_ADDR"]).Split(',')[0].Trim();

dcs619

 DECLARE @Today datetime = GETDATE()

 DECLARE @CampusId int
 SELECT @CampusId = 2
 DECLARE @CampusGuid uniqueidentifier
 SELECT @CampusGuid = '6246DDEF-8AC9-4C25-B011-430CEE590F0F'

SELECT COUNT(DISTINCT PersonAliasId)
FROM Attendance A
INNER JOIN (

dcs619

-- Get a list of Member Id's and their schedules 
SELECT EntityId, r.value('.', 'varchar(255)') AS Schedule
FROM (
	-- create valid xml path
	SELECT EntityId, CAST('<n>' + REPLACE(Value, ',', '</n><n>') + '</n>' AS XML) AS 'Schedules' 
	FROM AttributeValue
	WHERE Id = 1257002
) AS baseXML 
-- parse the xml into a table
CROSS APPLY Schedules.nodes('n') AS parse(r)

dcs619

--select '
--PRINT ''Updating ' + [name] + '''
--UPDATE STATISTICS [dbo].[' + [name] + ']
--'
--from sysobjects where type = 'U'
--and name <> '__MigrationHistory'
--order by [name]

PRINT 'Updating _org_sparkdevnetwork_Documentation_Book'
UPDATE STATISTICS [dbo].[_org_sparkdevnetwork_Documentation_Book]

dcs619

/*
-- See below for moving a non-clustered file index.  Moving a clustered index is the same
-- as moving the data, as each row lives as a leaf somewhere in the index tree.

-- Current syntax for moving a CLUSTERED file index:
PRINT 'Moving PK_dbo.Group index'
CREATE UNIQUE CLUSTERED INDEX 
	[PK_dbo.Group]
ON 
    [Group] ( [Id] )

dcs619

<div class="form-group date-range-picker ">
    <label class="control-label" for="ctl00_main_ctl23_ctl01_ctl06_gfTransactions_drpDates">Date Range</label>
    <div id="ctl00_main_ctl23_ctl01_ctl06_gfTransactions_drpDates">
        <div class="form-control-group">
            <div class="input-group input-width-md date input-group-lower input-width-md js-date-picker date">
                <input name="drpDates_lower" type="text" id="drpDates_lower" class="form-control" value="{{ PageParameter.StartDate }}" />
                <span class="input-group-addon">
                    <i class="fa fa-calendar"></i>
                </span>
            </div>

dcs619

$('input:checkbox').prop('checked', true);

dcs619

# Copyright (c) Microsoft Corporation.  All rights reserved.

$InitialDatabase = '0'

$knownExceptions = @(
    'System.Data.Entity.Migrations.Infrastructure.MigrationsException',
    'System.Data.Entity.Migrations.Infrastructure.AutomaticMigrationsDisabledException',
    'System.Data.Entity.Migrations.Infrastructure.AutomaticDataLossException',
    'System.Data.Entity.Migrations.Infrastructure.MigrationsPendingException',
    'System.Data.Entity.Migrations.ProjectTypeNotSupportedException'