Assuming final is required, the following 33 results were found.
-
second select statement (to list all the rooms) has to have the same number of fields as the first statement. This is the final script for the events table (DO NOT USE THE BELOW: this works for me and the timetabling system I have, you need to adjust...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
if zero rows were returned because Sum(Fields!Counter.Value, "Equipment") should come back as zero. MDX Expression: One final and a little confusing tweak to make it all work! Where "Equipment" is the name of the dataset. Bring up the tablix properties...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
performance is always rubbish anyway. Here's a breakdown of the MDX expressions and how I tweaked each one to return the final result: -- to get just the time value =( CDate(Last(Fields!REPORTENDTIME.Value, "Dataset2")) -...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @TableToProcess END CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SELECT * FROM #CountRecordsPerTablePerCol; END Issues Consider adding a drop of the temporary table to the...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
reported these default values sometimes list twice, especially when the case is different, eg. "Data not yet available". The final system (qlikview) was case-sensitive despite our server collation being case-insensitive. Furthermore, we now have the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @ColToProcess END CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SET @SqlToExecute = ' SELECT DISTINCT myValue COLLATE ' + @p_UseCollation + ' AS myValue, myColumn,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
NULL OR t2.TABLE_CATALOG IS NULL ) -- NOTE: This does not list if a column has been moved to another table Method #4 And a final enhancement to epitomize my laziness (replace [myDB1] with name of database 1 and [myDB2] with name of database 2): -- Joins...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
morning, I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days activities into the morning and afternoon slots. All days...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
incomplete! Will post a final solution but here are the basics What? This article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
are setting the charset to UTF-8 Add the charset attribute to posting HTML forms: accept-charset="utf-8" Conclusion: The final fix in my case was due to me not specifying some extra parameters on the htmlentities or htmlspecialchars PHP functions. My...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
enclosed by double chevrons Enter the same field to monitor under "New field/Value" enclosed by double chevrons The final statement will be something like != Use the Operand "OR" or "AND" to add further fields, in our demo we want all the key fields:...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
deprecated XMLHttpRequest to get file contents - Loops through each row and splits by commas (not within quotes) - Sorts the final array by a object label function populate_array_from_csv(this_file){ // using deprecated XMLHttpRequest to read file //...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
the practical setup often involves moving back and forth between Zoho People and Zoho Analytics. This document records the final design and a repeatable process that can be followed and adapted for future clients with similar requirements. Configure...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *