normansolutions

IF OBJECT_ID( 'tempdb..#TempBMI'
            )IS NOT NULL
    BEGIN
        DROP TABLE #tempbmi;
    END; 

WITH cte
    AS ( SELECT txtschoolid , 
                txtbmidate , 
                intweight , 

normansolutions

<?xml version="1.0" encoding="UTF-8"?>
<database name="YourDBName" friendlyName="iSAMS Tutorial Groups">
   <querySets>
      <!-- ## tutorial groups relationships ## -->
      <querySet guidPrefix="Tutorial">
         <!-- Return a list of groups for the specified member guid -->
         <groupLists>
            <groupList namePrefix="Tutorial Group ">
               <query>
			   

normansolutions

// Add this snippet to the ProcessForm() function in the reportingServicesReportSelection.asp
// located in "iSAMS\iSAMS.Framework\modules\StudentManagement\current"

//Get userName
function getCookie(cname) {
    var name = cname + "=";
    var ca = document.cookie.split(';');
    for (var i = 0; i < ca.length; i++) {
        var c = ca[i];
        while (c.charAt(0) == ' ') c = c.substring(1);

normansolutions

<!--Add this line to the form with id="form1" in the reportingServicesReportSelection.asp
    located in "iSAMS\iSAMS.Framework\modules\StudentManagement\current" -->
    
<input type="hidden" name="userName" id="userName" value="" />

normansolutions

#################################################
$smtpServer="Your SMTP Server"
$from = "Your From Email Address"
$emailaddress = "Your Send To Email Addressk"
$subject = "The reportingServicesReportSelection.asp file has changed"
$body = "The reportingServicesReportSelection.asp file has changed, you need to re-add the script"
$strReference = "Your Path To An Original Copy Of The File"
$strDifference = "Your Path To a Deployed Copy Of The File"
#################################################

normansolutions

<!--Place the below code snippet just before the closing body tag
in the 'YourFFInstallation\Templates\YourTemplateFolder\defaul.xsl' file.-->

<!--Load Velocity.js - either from CDN (as below) or your preferred location (local etc).-->
<script src="//cdnjs.cloudflare.com/ajax/libs/velocity/1.1.0/velocity.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/velocity/1.1.0/velocity.ui.min.js"></script>
<script>
    $(window).load(function () {
        var images = $(".STMmenuBar a img ");
        images.velocity("transition.flipYIn ", {

normansolutions

<style>
    .STMmenuBar {
        min-height: 64px;
        display: inline-block;
    }

        .STMmenuBar img {
            display: none;
            padding: 3px;
            border: 1px solid black;

normansolutions

// How many hours to summarize
var hours = 1400;
// User to summarize
var user = "Ipad";
var users = db.user.find({
    "hostname": new RegExp(user)
});

for (var j = 0; j < users.length(); j++) {
    var user = users[j];

normansolutions

DECLARE @FormName VARCHAR( 100 );

SET @FormName = 'Your Form Name';

DECLARE @Xmldata XML = (SELECT txtschoolid
   FROM   tblpupilmanagementpupils
   WHERE  intsystemstatus = '1'
          AND txtform = @FormName
   FOR xml path( '' ));

normansolutions

$loop  = '';
$print = '';

for ($loop = 0; $loop -le 100; $loop++)

{
    $print += [string]$loop + '%@';
}

$print