Assuming still is required, the following 94 results were found.
-
Stored Procedure Success or ErrorLevel EXECUTE MY_PRETEND_STORED_PROCEDURE('value1','value2','value3',:errorcode,:errormsg) Still discussing this stage... Not proceeding with this as there may be a better way. In addition, SSRS was complaining about...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Blank" and "Allow NULL". How? This is the tough part. I was reading up on the MSDN page for the closest solution but it still didn't work for me. But the idea of inserting a NULL entry to select sounded good. Aim / Objective The plan will be to replace...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to the server. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; CharSet=UTF8; Note that resultsets still are returned in the character set of the data returned. Specifying shared memory name Use this one to specify the shared...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
for me. I recently changed job and no longer have all my test machines at work. Instead I only have the one workstation :eek Still I've been asked to test some web applications (???) so I had to find a solution to suit me. I'd done this before IE7 (so a...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
their local workstation. As IT staff we have elevated privileges but not absolute rights to configuring our computer. And we still need to re-login for every change. About a zillion group policies control our every deviation from the standard staff...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
the registry editor, then restart the computer. Notes: Guest account will not see the drive in Windows Explorer but can still access it using the command prompt. All users can access the drive using the command prompt. To hide from specific users, you...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
the spacebar and not the Alt Gr often found on the right of the spacebar) then press the numbers in the numeric pad (while still holding down the ALT key), then let go of the ALT key. Remember: This will not work with the numbers at the top of your...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Try switching the trackpad on and off and pair it up again but bear in mind to give it a few seconds to reconnect. If it still doesn't work, I had to repeat the preivous step of installing the driver and wait a few seconds for the settings page to show...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
now right-click on the top of the [Order] column (grey square -like excel- to select the column). Select "delete columns". Still deleting: Make sure you select "delete columns and associated groups": Overview: So the following screenshot is how your...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
of this little trick for my managers, I explained it as displayed in the following image (apologies for the image but it's still clear as mud in my head): Oracle SQL*Plus Only for display/print but SQL*Plus has a nifty separator record activated...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Not quite right, as we got the last occurrence counting from the beginning rather than the end, so we still need to work out the starting point: SELECT LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) -- yields "23" SELECT SUBSTRING(@Haystack,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
There! So we're using the ROW_NUMBER() functionality with an ORDER BY which seems to work somewhat. But using the code above still produces an error which can only be seen when using more records and more employees. PARTITION BY So a sort of "group"...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
the problem after all. The first query was erroring despite the stored procedure compiling successfully. An empty dataset is still an error it would seem. -- Error I was getting ORA-20001: 1234567:$:ORA-01403: no data found ORA-06512: at...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
to reconcile with the requirement example. Note that we have two events on the Thursday. A few things we have to deal with still: We have lost the rows with days that have no events. We need to group by days so that each day only outputs one row (see...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
changes and support (response times) Critical - nothing works! Major - something important is broken Minor - less urgent but still broken Request - nice to have Support structure / maintenance rates agreed on (same as development - per hour)...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
for you. I just need you to restart your computer now and tell me when that's done.". "I've done what you said but it's still not working". "From my logs, you haven't restarted this machine in a while.". "No I definitely log off every evening and then...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
listing though I could access the folders if I browsed the existing folders by entering it in the remote directory field. Still no files or folders would show. There's a good bit of information from the source link listed below but the settings didn't...
- Type: Article
- Author: Joel Lipman
- Category: File Transfer Protocol
- Language: *
-
curl_setopt($ch, CURLOPT_CERTINFO, TRUE); curl_setopt($ch, CURL_SSLVERSION_SSLv3, TRUE); Future Considerations The data still hasn't been properly decoded from UTF-16 and encoded to UTF-8 Test writing to a file, re-encoding the file then reading from...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165
of flour from around the edge of the bowl as you do so. Next gradually add small quantities of the milk and water mixture, still whisking (don't worry about any lumps as they will eventually disappear as you whisk). When all the liquid has been added,...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
- they'll spread out when they bake. Step 4: Bake Bake your cookies about 8-10 minutes, until they're golden brown, but still soft in the centers. Let them cool on the pan for a minute, and then move them to a cooling rack. This recipe makes about 4...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *