Search - Joel Lipman .Com

21. Compare two databases using T-SQL: / Transact-SQL /; Applies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...; Created on 24 September 2013
22. Search a database for a string (MySQL, T-SQL): / Databases /; ... Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a single table name or multiple table name with comma seperated. If left blank , it will ...; Created on 08 October 2012
23. Basic Joomla 2.5 Mootools Form: / Joomla /; ... Note: UPDATE 2012 It is important to refer to the correct mootools scripts in order for this to work. Unfortunately, clients who sign up to template providers who disallow access to their support forums ...; Created on 20 August 2012
24. Migrate JComments from Joomla 1.5.x to Joomla 2.5.x: / Joomla /; ... or JoomlaTune (Jcomments) This script is provided as is without warranty If you do not understand what this script is doing, let someone who does run it instead INSTALL INSTRUCTIONS Install ...; Created on 07 June 2012
25. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... has to be listed in the "dataset properties" > "query parameter values" under "Parameter Name" and then the SSRS parameter value (eg. "[@my_ssrs_parameter]"). Internal .Net Framework Data Provider error ...; Created on 19 January 2012
26. SSRS External Images don't displa: / SQL Server Reporting Services /; ... and we only want one location to upload the photos. These images are provided via a website address (http) or network share (file). Before you ask, we have several MS Sharepoint sites but we didn' ...; Created on 19 September 2011
27. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... to do the following: We have our main report with a textbox that has the Action property: Go to Report / HouseKeepForm (our confirmation page) / With 2 parameters provided in the main report (note: ...; Created on 02 September 2011
28. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... AND clause where you state that the ID (DB.Table.StudentReference) can NOT be blank/null. End-users won't usually search based on the username (@StudentADAccount) if it wasn't provided to start with. Additionally, ...; Created on 19 July 2011
29. Joes Bug Tracker (JBT): / Product Documentation /; ... Conflicts with its built-in stylesheet and my RocketTheme template. RokDownloads by commercial Joomla! template and extension providers, RocketTheme. They don't use the standard Joomla! admin component ...; Created on 07 July 2011
30. Basic Webpage Controls with JavaScript / COM: / AutoHotkey /; ... of this tutorial is to teach the intermediate AHK user how to start using COM to control webpages. My goal is to provide methods for controlling webpages, similar to how the AHK Control Commands can control ...; Created on 05 July 2011
31. What's the problem? Amusing computer issue: / Web-Development /; ... The project leader was on IE7, while their designer was on an Apple Mac using Safari, and a third was using Mozilla Firefox. We told them to go back to the template providers and report the same problem ...; Created on 28 April 2011
32. Checklist for the local computer repairs: / IT Support /; ... Internet Provider OS disks Document Templates: Service Agreement Template Computer Repair Invoice Template Documents: Service Agreement Electronic Newsletter Business Cards ...; Created on 28 April 2011
33. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... 108) AS EventFinish, '' AS Status, '' AS Tooltip FROM [ROOMS] rms WHERE rms.SiteId=@siteId AND rms.SetId=@setId ) You should be able to provide this statement with a result set similar ...; Created on 23 March 2011
34. URL passed settings in Reporting Services: / SQL Server Reporting Services /; ... &rc:BookMarkID=1 Provide search criteria and find the first instance http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:FindString=foo Note: ...; Created on 11 February 2011
35. Connection Strings for SQL Server: / SQL Server /; ... one to instruct the provider to ignore any command prepare statements and prevent corruption issues with server side prepared statements. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Ignore ...; Created on 05 January 2011
36. Is it a scam? Gumtree.com's warning sign: / IT Support /; ... card details. You get an email that claims to be from «CompanyName» or another company and requests that you reply or follow a link to provide personal information. These are fake and are known as ‘spoof’ ...; Created on 12 October 2010
37. Webdeveloper-Speak: / Web-Development /; ... marketing An opt-in policy requires a potential customer to self-select the services they wish to subscribe to, and how any information they provide may be used. Also referred to as permission-based ...; Created on 13 July 2010
38. Joe's CSV Chart Generator (JCG: / Product Documentation /; ... my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can zoom ...; Created on 26 May 2010
39. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparison: / Joomla /; So this is a comparison chart (at least in my opinion) of 3 major joomla template/extension providers. When I'm less caught up in work I'll try adding to this article. But here's some lazy stats: ...; Created on 08 April 2010
40. Embed an FLV file into a web page: / Hypertext Markup Language /; This is if you have an FLV file and you don't want any fancy management system, you just want your FLV to play on your webpage. The following example is a demonstration of how to do this without installing ...; Created on 09 March 2010