Search - Joel Lipman .Com

21. Excel: Find values in one column that are not in another: / Excel /; ... down, it may automatically modify the range. So the formula in the first row will be =COUNTIF(A2:A100, B2) but the formula in the second row will be =COUNTIF(A3:A101, B3): =COUNTIF(A2:A100, B2) -- ...; Created on 06 March 2014
22. Search a database for a string (MySQL, T-SQL): / Databases /; What? I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone ...; Created on 08 October 2012
23. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... equivalent functions have to be written up all in the name of "seamless integration"... How? Previously I had tried to write a smart function which could determine the datatype automatically but ...; Created on 22 August 2012
24. T-SQL Record Separator: / Transact-SQL /; I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on ...; Created on 11 October 2011
25. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... Report > OK Design Table: Drag StaffName to Columns, Resource to Row and PersonDays to Values Tick a field that will be the parameter/filter/criteria (it will be automatically added to row or column), ...; Created on 24 August 2011
26. SSRS Redirect after a report is run: / SQL Server Reporting Services /; ... or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically. How? So there are various solutions out there, here' ...; Created on 12 August 2011
27. Inserting incremental weeks in MySQL: / MySQL /; ... 52 2012-07-09 00:00:00 Joe you're an idiot! You might say to me why not run the CMIS Facility application and add a new set, it will put these dates in automatically. ...; Created on 15 April 2011
28. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... because this will automatically group the rows by room (you need to do this anyway otherwise it will look a bit like a staircase of bricks). 4. Design the Matrix: In other words, put where ...; Created on 23 March 2011
29. URL passed settings in Reporting Services: / SQL Server Reporting Services /; ... we instruct all users viewing the reports to do this? When does this report automatically expire? Reminder on Paper Sizes A4 = 8.27in (width) × 11.69in (height) Letter = 8.5in (width) x 11in (height) ...; Created on 11 February 2011
30. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... help ME migrate Joomla 1.5 sites to Joomla 1.6 automatically. I have also been using this happily for Joomla 2.5.x websites and more recently for an experimental Joomla 3.0.x website. I do not work ...; Created on 30 January 2011
31. Passwords: Did-you-know: / IT Support /; ... needing only a few seconds to connect to your computer and to automatically download all the passwords. (source: NirSoft Recovery Tools 01/2008) 4 main techniques used in getting your password: Steal ...; Created on 15 November 2010
32. Change the login link in MediaWiki: / MediaWiki /; ... Some articles are available for public, some are restricted to staff and different localgroups. When users click on the 'Login' link, we want the system to automatically prompt them for their username/password. ...; Created on 22 September 2010
33. Windows 7 Aero Features: / Windows OS /; ... drag a window up to the top of the screen it will automatically maximise itself. If you have two windows open, and want to view them side by side. Click and drag one to the right edge of the screen and ...; Created on 27 April 2010
34. Remove write-protect from USB pen in Windows: / Windows OS /; ... another) as well as the common USB disk storage format tools for Windows. Note that any data on the USB pen is automatically lost, and that if you use rescue programs, you may corrupt the pen in such ...; Created on 13 April 2010
35. Embed an FLV file into a web page: / Hypertext Markup Language /; ... Additional: Stop AutoPlay Thank you to Anna Moors for writing in and asking "how to stop the movie from playing automatically on page load?". Anna has since confirmed that ...; Created on 09 March 2010
36. Change default order of weblinks: / Joomla /; It took a few google searches until I could find out how to change the default weblinks order. A lot of websites showed how to do this via the admin back-end panel in the advanced configuration... I ...; Created on 15 November 2009
37. Keyboard and mouse shortcuts in Google Chrome: / Google /; ... As you move your mouse, the page automatically scrolls according to the direction of the mouse. Ctrl+F5 or Shift+F5 Reloads your current page, ignoring cached ...; Created on 23 September 2009
38. Privacy Policy: / Static Items /; ... other than the data you choose to share with us. You can choose to accept or decline cookies. Most web browsers automatically accept cookies, but you can usually modify your browser setting to decline ...; Created on 30 May 2009
39. Licence GNU/GPL: / Static Items /; ... or control flow between those subprograms and other parts of the work. The Corresponding Source need not include anything that users can regenerate automatically from other parts of the Corresponding ...; Created on 03 April 2009