Assuming again is required, the following 95 results were found.
-
------------------ ----------------- ------------------- Report 001 5 2 Report 002 11 47 Report 003 7 61 Multiple Datasets? Again NO that's what I have at the moment. There must be a way. Or is time always on that dimension? HAVING is pointless, WITH...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
says either "Stored Procedure was successful" or "No sorry you're going to have to go back to the beginning and try that again."... This isn't a solution that sounded good enough for our customers. The Workaround we actually went with Our Stored...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
You can opt to untick the checkbox next to Synchronize with an Internet time server to prevent it finding the wrong time (again) Check the clock has updated in your taskbar and close the window by clicking on OK Leave your computer for a few hours and...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
You can opt to untick the checkbox next to Synchronize with an Internet time server to prevent it finding the wrong time (again) Check the clock has updated in your taskbar and close the window by clicking on OK
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
7 and my day-job machines tend to be windows xp. I found this solution on a windows xp machine so if the error happens again, I'll try fixing it on my windows 7 setup and update this article. I found someone else on the Internet who doesn’t use the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
want to look at one, click and hold its window and shake it! All the other windows will minimize, simply shake the window again and all the other windows will restore. Aero Snap: One of the most useful features I use in Windows 7, If you click and drag...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
-- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again you need permission to create this function. Don't forget to GRANT permission to execute this function for whatever user/system...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Running the second based on the first will error this procedure. One Issue I just kept getting this error over and over again: ORA-00936: missing expression 00936. 00000 - "missing expression" The solution was to enclose the subquery with an opening and...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION ALL clause. Scenario:...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
@stringtoFind, @stringtoReplaceWith) WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') Run the first query again and no rows should be returned. Quick Joomla One I use this reluctantly but often necessarily. SET @stringtoFind=' '; SET...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Saturday -- 2013-12-08 Sunday Brilliant! We have the first two columns of what we want to do. Now we need the same again but this time we want the morning slots SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) AS ThisDate, DAYNAME(...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
"From my logs, you haven't restarted this machine in a while.". "No I definitely log off every evening and then back on again". "You mean you log back on in the morning?" "No it takes so long in the morning, this is quicker". Explained how logoff is not...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be redirected to the new...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
note in case I spend as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content section. I...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
contents of the hidden slide with contents of the displayed slide. Hide currently displayed slide to expose the first slide again (restores the starting position of "next slide"). The Gist Strategy This may not be a great idea, I'm just trying something...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
What? A quick article to stop me running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it in PHP with the function simplexml_load_string()....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
a few times and run through a few, I thought I'd note this down to remind me if I ever work for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165
make the rest. To serve, spinkle each pancake with freshly squeezed lemon juice and caster sugar, fold in half, then in half again to form triangles, or else simply roll them up. Serve sprinkled with a little more sugar and lemon juice and extra...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
If I'm having it cold, I tend to add some balsamic vinegar. Season to taste with salt and freshly ground black pepper. Fluff again with a fork and serve hot or at room temperature. Source: http://homecooking.about.com/od/pastarecipes/r/blpasta17.htm
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *