Assuming using is required, the following 323 results were found.
-
Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
was using this for a password security-level checker: Source: www.wikipedia.org
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
Tim Minchin - 1984https://joellipman.com/articles/_other-misc/tim-minchin-1984.html
brilliant Tim Minchin using my favourite book as a response to "the Big Fat Quiz of the Year" show hosted by Jimmy Carr. {youtube}CZ7U3Cu4Mr4{/youtube} https://www.youtube.com/watch?v=CZ7U3Cu4Mr4
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
you open other similar files in the same environment? Is a colleague experiencing the same issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been installed on your workstation...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM (SELECT XMLTYPE ( '' || REPLACE (...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
04/10/2011 Another Office 09:00 17:00 Notes Row Seperator This follows on from my T-SQL Record Separator article. If you are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you won't need to use the database level solution...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I know to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function). How? $total_time =intval(intval($total_seconds)/ 3600).":";...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using T-SQL: DECLARE @myStringToParse VARCHAR(max), @myXML XML; SET @myStringToParse = 'Title,Forenames,Surname'; SELECT @myXml =...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Install this plugin using your Joomla Admin Panel Go to Extension Manager > Search for "Joes Youtube Player". Enable and Save. Screenshots Looking forward to your feedback!
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Trim in T-SQL and SSIShttps://joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html
-- or split for clarity TRIM( LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
MS-DOS batch programs is a lot easier and colleagues trust these more than my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- the...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
link at the bottom of the left menu Click on the “All People” link at the top of the left menu Find yourself in the list by using the iccle arrow next to the 0-100 (top right) Click on your own name or picture to see your profile page Click the “Edit...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
with the credentials stored, here are the details to our report As developers, we connect to the datasource directly using our Windows Credentials. For the SSRS server holding our report, we do NOT have an unattended service account. The report uses a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
color instead: Right-click on the cell you want to put the image in. Insert > Rectangle Set the Rectangle Fill color (I'm using an expression based on the status) to output: Green (for Success), Red (for Fail), Orange (for Unknown). Right-click on the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 of it. Why? To test the XET I created, I want to see what the resulting XML will...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
A reference to what size an image background should be set to for various screen sizes. Why? A background image I was using was unedited at 1600x2133 (364kb) and was not displaying on smaller devices. Configuring drawables for each layout seemed to be...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
A quick article on how to set a password using the database tools for super users. Why? It happens to us all, especially me. I like to use different passwords for every site but this came up as a client had lost their super user password. How? This...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Using a DJI Phantom FC40 to film a part of Angeles City, Pampanga, Philippines. {youtube}B9afOeBUqpg{/youtube}
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF