Assuming following is required, the following 283 results were found.
-
has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
the Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following screenshot): In this screen, I've opted for Do not use Remote Management as I only want to export/import my database:...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Please note: the following article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Statistics (awstats) but this was so that you could have your own country lookup script. The Download Should contain the following: create_countriesipranges_table.sql: SQL to create a pre-populated table into a MySQL database....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday). How? See the following screenshot and note the dates for Monday, Tuesday, Wednesday, and Thursday: Note how amusingly Microsoft thinks Wednesdays...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Use the Replace(String, "\r", "") and Replace(String, "\n", ""). Feedback This solution took me two days to solve despite following an innumerable number of sites advising but none of them having my issue of rows after blank ones being out of alignment....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
int" then read on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable ------------------------------------------- ID Name EmpType CodeType 1 Joe Manager 0011 2...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
/error/?v=404 ErrorDocument 500 /error/?v=500 Additional Notes If you do apply the above to your site, bear in mind the following is also true: http://www.mysite.com/blog/pretty_much_anything_i_want_to_type_here.html --yields...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
tool to compare the outputs. Method #2 Enhancing the above which does a little more of the work, requires in the following query for you to replace the terms "myDB1" with the first database name and "myDB2" with the name of the second database to...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
view the Options of the component, and click on "Save"... despite the fact that I don't change anything. How? Add the following line to the XML installation file: script.php Now create a script.php file in the root folder of your component (ie. same as...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
article modal with clear button for Joomla article selection. How? We have to create a custom form field type. In the following example, I'm going to create a dropdown which selects all projects associated with a particular user. Method #1: Important!...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from webpage Subscriptions cannot be created because the credentials used to run the report are not stored, or if a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
which the project manager and his/her team can use to experiment and test. Once the production website is finalised, the following need to be agreed: Parallel running with legacy systems – testing and confirmation that both systems are operational, data...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
this article is not addressing your issue. This is a red herring. If the number returned is greater than 1 then run the following query: UPDATE #__assets SET parent_id=1 WHERE parent_id=0 AND id1 AND title'Root Asset' -- where #_ is the Database Tables...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
type a query on the database and get the same result, but this script was more fun. Simply create a text file with the following code and upload it to the root of your Joomla website. Access the page from a browser and you should get all your users...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
after this one: Open the Start Menu, then type regedit in the search box and press Enter. In regedit, expand to the following key HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer In the right pane of Explorer, right click on...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
the reverse was easier to work out: Open the Report in Design mode. Check that advanced mode is switched on as per the following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error):...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
second. I call this latest app "byeBU" and this is version 0.4 Beta (unofficial app). Why? Something to do... How? The following code is using AutoHotkey (AutoIt) and is the source code as compiling it wouldn't be much use to anyone else unless they...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
process (in other words, you don't have a boss): Method #1 (cowboy fix - not recommended): I would not recommend the following but I found this on the MySQL Forums. Someone solved their issue by resetting (or re-issuing) their password which implies...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
but as you can see we have a few fields that need decoding (suffixed by "_code"). Run as it is, yields something like the following: sequenceID student_reference student_title_code student_name student_gender_code student_country_birth_code...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF