Search - Joel Lipman .Com

21. SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issue: / SQL Server Integration Services /; ... Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages and VS2010 for database solutions running against SQL Server 2008 R2. We can use VS2012 for both but this requires upgrading all the packages ...; Created on 09 June 2014
22. Client Services: Website Development Agreement: / Static Items /; ... suggest and query against this. Here is an outline agreement between joellipman.com and you: Once I have the domain names, I will configure my server to receive requests for those domains ...; Created on 15 November 2013
23. Compare two databases using T-SQL: / Transact-SQL /; ... here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases ...; Created on 24 September 2013
24. Country Lookup by IP address CSV: / MySQL /; ... Run the SQL script against a test database, Modify the table name to use if necessary. Uncomment the drop statement if running for the second time. Modify the PHP file to use database login ...; Created on 17 March 2013
25. Convert Decimal (Person Days) to Time in Excel: / Excel /; What? We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, ...; Created on 13 February 2013
26. Search a database for a value and count matching rows: / Databases /; ... from the BEGIN to the END (exclusive) - allows you to run ** ** this against any table only changing the parameter column. ** ** ...; Created on 05 November 2012
27. Search a database with SOUNDEX: / Databases /; ... example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel: CREATE ...; Created on 11 October 2012
28. Migrate JComments from Joomla 1.5.x to Joomla 2.5.x: / Joomla /; ... to match your setup Run the modified SQL script against your database. Note: It is not advisable to run this on a production website! -- -------------------------------------------------------------------------------- -- ...; Created on 07 June 2012
29. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... 1. Generate query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance ...; Created on 27 April 2012
30. Excel PivotTable Filter List Ordering: / Excel /; ... product Bang "Head" against wall. Bang "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so that the date returns in yyyy-mm-dd format (eg. 2012-03-04) Reverse ...; Created on 05 September 2011
31. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... the second solution will mean each dataset must at least join both tables that you are using the OR clause against. There must be a solution that executes a query at report execution time and populates/assigns ...; Created on 19 July 2011
32. Code Troubleshooting Checklist: / Web-Development /; ... environment, have you? Commented out lines that you suspect might be the problem? Able to run the SQL queries directly against the database? Matched the datatypes received/returned by functions, ...; Created on 03 June 2011
33. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... will appear as a row but have no slots booked against it. [Test2 Room] will both appear as a row and have 3 slots taken up (if you left the above to 30 minute slots). Tweaks Separate the field ...; Created on 23 March 2011
34. MySQL: Find records in one table that are not in another.: / MySQL /; ... and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and back-end. It's MediaWiki CMS used by Wikipedia.org and the ...; Created on 25 February 2011
35. Upgrading a Joomla 1.5 module to Joomla 2.5: / Joomla /; What? So this is a note to myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I ...; Created on 11 February 2011
36. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... It does not contain usernames or passwords but has the real database names and all website content, so do not redistribute without taking security measures. Run the SQL against your new database Open ...; Created on 30 January 2011
37. K2 Items disappear: / Joomla /; ... The Quick Fix I managed to fix this with this SQL command . Note: you need to be able to run SQL commands against your database. My client had phpMyAdmin installed so I ...; Created on 27 August 2010
38. Forum Rules: / Static Items /; ... defend themselves against any accusations made to them, but may not make any additional accusations to the flamer (which also counts as flaming). No Profanity or Obscene Content - Such content does ...; Created on 31 May 2009
39. Licence GNU/GPL: / Static Items /; ... operation or modification of the work as a means of enforcing, against the work's users, your or third parties' legal rights to forbid circumvention of technological measures. 4. Conveying Verbatim ...; Created on 03 April 2009