Assuming having is required, the following 66 results were found.
-
phone prompts you to set it up but you could do the below again at anytime (as I discovered). The steps below apply after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID). Ensure your old...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
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. TWO DAYS!!! I hope this helps you! If you know of other ways to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
"No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix which kinda defeats the purpose of having anything there. I want my end-users to have faith in my report. The report just returning blank can also mean "I don't know". I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 ROLLUP is interesting, think I'm looking in the wrong place. Using Aggregate Functions? What follows is...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
doesn't even mention them anywhere in the resulting report. One Issue The report will always load when opened defaulting to having all parameters set to the dummy value. For me it just opens an empty report with the charts saying "No Data Available" but...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having read-only access (in this example "adventureworksro"). Select Properties. Select User Mapping. Map the login to the database they...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Data Not Yet Available Which isn't at all what we set out to achieve other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products. Why? I googled and binged and all I could find were people selling third party products......
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
it will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS. How? You can search my site for how to do this in VB or C#. This...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
for either an upgrade or a different host. If your website has been LIVE for a while and it's returning this error despite having little installed, then check your logs to see if anyone has been trying to hack your website. There are a number of...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Harmless you might say. Works fine on a small page but I have discovered limitations with the majority of browsers when having to spread gradient backgrounds across a long page. It would appear to be fool proof because of the "background:#f7f7f7"...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
Why? If you're developing in SITS, and you use the client, the first time(s) you do this, the task is rather daunting. Having done it 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...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
tender. Fluff with a fork and gently stir in sun-dried tomatoes, onions, basil and some extra virgin olive oil. 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...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
when refreshing data and preferred the end result with this change. Note on "row height": We did not want the customer having to format the report after they've already gone through the hassle of clicking on the big fat refresh button... Keeping It...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
for that’s the email id you need to send files to for those to show up on your Kindle. Getting your email ID approved Just having your Kindle email address won’t suffice unless you have got your own personal email address (any email address from which...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
button and the image to respond to the ENTER key after you typed something (this is for a search feature) in addition to having a button if the user would rather click then press the ENTER key. Then create the mouseover and mouseout effects afterwards....
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html
Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to disable user registration in Joomla! CMS version 1.5.x without using the Joomla! CMS back-end panel. Why? Because we're having some corruption issues and simply using the Joomla! administrator panel to navigate to global configuration, does not work!...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB