Assuming even is required, the following 87 results were found.
-
date-of-birth based on the student ID number Agenda Outline Note: As simple as this sounds, this is not a five-minute job. Even with all your SQL scripts with backups of your datasets, each of these will need tweaking. Create your stored procedure in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
was successfully synchronized... 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...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
else have any problems with Aero effects when they first installed Windows 7? What’s your favourite Aero feature or do you even use them? Let us know by leaving a comment.
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
will be stored in the folder that you asked to list. Instead of C:\windows\system32\cmd.exe, I could have used %Comspec% or even %windir%\system32\cmd.exe but with some group policies, you will get an "access denied" message. If you don't have a...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well. Why? For every DBA this is a doddle and...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
31 THEN 'st' WHEN 2 THEN 'nd' WHEN 22 THEN 'nd' WHEN 3 THEN 'rd' WHEN 23 THEN 'rd' ELSE 'th' END AS Ordinal, All very posh. Even Microsoft don't have helpful documentation on using SWITCH in an MDX query. Chances are they can't get it working either:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Friday */ This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our end customers are not even computer literate so the SQL query had to do the bulk of the work. The SQL query we send to the database has to insert separator...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
cursors. I'm told I need to use this for SQL Server Reporting Services (SSRS) which is why I'm going down this route. For an even simpler stored procedure, I'd imagine you just get rid of the cursor. Why A standalone query is faster in the eyes of SSRS,...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
the web for a solution, most suggest using NVL() but this only replaces a NULL value with a string of your choice; and even if you NVL all returned fields, no rows are returned, and not a row of NULL/blank/empty values. Sounds confusing? That's just me,...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
(despite being already logged in, this is the same user but re-prompted for credentials) Cannot run System Registry (not even DOS REG Query!!!) All oracle utilities and connections working on my computer (except for TNSPING). TNS_ADMIN is another...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
check your logs to see if anyone has been trying to hack your website. There are a number of components I have found that even with captcha features, still get hacked with viagra emails and what have you (eg. JoomlaBook). If you don't want to go through...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
then to import it into another database. Why? If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
will go to when they type your domain name. Important: You only need the domain name and no additional packages (not even email as our servers handle that). UK Domain Registration Services (for .co.uk, org.uk, .net.uk, etc): http://www.123-reg.co.uk/...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
a semi-transparent layer that overlapped it half-way. I managed to fix this by including a div push layer which clears both (even though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
and modify the height of the iframe then click on 'Run'. The iframe is always centered even if the top is off screen.
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165
Now make a well in the centre of the flour and break the eggs into it. Then begin whisking the eggs - any sort of whisk or even a fork will do - incorporating any bits of flour from around the edge of the bowl as you do so. Next gradually add small...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
aligned and the same width as their respective column heading. Remove any ruler gridlines that don't truly serve a process (even if they're just for margin purposes)
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie....
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
"₱", "") Which leaves the value as a literal string... Now the tricky part, how to copy into a column just the number? Even if I tell it to multiply by 1, Microsoft Excel gets confused and reports an error?!?!?!? The answer on the Microsoft website is...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB