Search - Joel Lipman .Com

1. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; What? An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- ...; Created on 18 August 2014
2. SITS: Export field code and name: / Extensible Markup Language /; Applies to: Microsoft Windows 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the ...; Created on 12 August 2014
3. SITS: XET format for Export not available: / Extensible Markup Language /; What? Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard ...; Created on 08 August 2014
4. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... pretend the info we want is rather simple: SELECT [sequenceID], [student_reference], [student_title_code], [student_name], [student_gender_code], ...; Created on 05 August 2014
5. T-SQL: Parse an XML value: / Transact-SQL /; ... Looping -- From resultset of $i ,assigning it to variable $j using let clause, -- Getting top two employees by using where & order by clause. SELECT Event_XML.query('for $i in /STAFF/student let ...; Created on 27 March 2014
6. Regular Expressions in SQL: / Databases /; ... I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows: SELECT * FROM STUDENTS WHERE ...; Created on 09 January 2014
7. Delete related records from multiple tables: / MySQL /; ... s, ssf, sst FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId LEFT OUTER JOIN `SessionStudent` sst ON sst.sessionId=s.sessionId WHERE s.dateTime >= '2013-02-01 00:00:00' -- ...; Created on 11 January 2013
8. DataScramble - Randomizing data rows: / Transact-SQL /; ... these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before: StudentID StudentName DateOfBirth ...; Created on 07 December 2012
9. Generate Academic Calendar using MySQL: / MySQL /; What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article ...; Created on 27 November 2012
10. Search a database with SOUNDEX: / Databases /; ... spaces are not obvious in the results, the Value may look the same but if you get your search result twice, this may be why. Performance Average - Run against a database of circa 30'000 students ...; Created on 11 October 2012
11. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; ... the default values which we found we could do with the built-in SOUNDEX function. How? Lets assume the following, we have a table containing: StudentID StudentDetail Soundex ----------------- ...; Created on 10 October 2012
12. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; What? This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original ...; Created on 22 August 2012
13. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... not tested the performance and database load. Before: StudentID StudentName DateOfBirth ----------- -------------------- ------------- 1 ...; Created on 01 August 2012
14. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; Why? We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return ...; Created on 24 January 2012
15. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the student ID number Agenda Outline Note: ...; Created on 19 January 2012
16. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; ... capability to run standard PL/SQL commands... unless they're run from within a stored procedure. Our aim is to run a small query first to return the ID of the student, and then to use this number in a ...; Created on 16 January 2012
17. Basic Oracle Function Structure: / Oracle PL/SQL /; ... I need to submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as ...; Created on 15 January 2012
18. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; What? We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is ...; Created on 04 November 2011
19. SSRS External Images don't displa: / SQL Server Reporting Services /; ... does not exist We don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. ...; Created on 19 September 2011
20. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID ...; Created on 02 September 2011