Assuming work is required, the following 174 results were found.
-
them by simply hovering over the icon in the taskbar. Click on one of them and you will be taken to that window, this also works with tabs in Internet Explorer which is very handy, but unfortunately it doesn’t work in Firefox or Chrome as yet You can...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
with the action name (eg. "Print Directory Contents To File" - replace spaces with underscores if you are unsure this will work) Add a key to this one called "command" Under the "command" key, there should be a new string value called "(Default)". If...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
group policies at home. Why? We get problems with this because none of our staff are full administrators of their local workstation. As IT staff we have elevated privileges but not absolute rights to configuring our computer. And we still need to...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
to: - Microsoft Windows 7 Enterprise - User with Local Administrator Privileges (required for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 Ultimate (VS2010) and Business Intelligence Development Studio (BIDS),...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
in the 2nd column "App to Run" then OK to run it: Settings Page App to Run Settings Homepage ms-settings: Accounts Access work or school ms-settings:workplace Email & app accounts ms-settings:emailandaccounts Family & other people ms-settings:otherusers...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
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 keyboard unless you are on a laptop and can apply a function lock (fn) and the numbers on...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and this did the trick. English Ordinal Suffix in T-SQL for MDX Working in the UK my bosses like the English Ordinal Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
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 rows so ideally we would like: Day ---------------- Monday...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before: StudentID StudentName DateOfBirth ----------- -------------------- ------------- 1 John Smith 1990-03-21 2 Fred...
- 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
-
employee. 002 00204 003 00305 Almost 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....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the above which does a little more of the work, requires in the following query for you to replace the terms "myDB1" with the first database name and "myDB2" with the name...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
a username. No rows are returned for the first query and a zero isn't inserted. Note: Running just one of the queries will work as normal with the NVL function. Running the second based on the first will error this procedure. One Issue I just kept...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
if I tnsping any oracle database, I get something along the lines of: Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file for product=NETWORK, facility=TNSMessage 3513 n ot found; No message...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
and click on "Test Connection" Expand the data connection you just made and expand "Tables" just to see if the connection is working properly. Create the Data Source Still within Business Intelligence Development Studio (BIDS) Right-click on "Shared...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
was to separate both tables (activities and users) rather than trying to join these, and to let PHP do a bit more of the work: User Query $t_value = $the_team_id_that_i_want_to_look_at; $user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, '...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
I also need to use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved software for our work computers. We have SQL Server Management Studio (SSMS) as well for our SQL Server instances but it wasn't practical to link...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is nice but its search...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
that could have saved an infinite number of man-hours (I exaggerate a little); but seriously, I needed a checklist that works for me. Most Difficult? My hardest project was (still is) one created by a PhD student who graduated and left the institution....
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *