Assuming from is required, the following 419 results were found.
-
T-SQL DateTimestampshttps://www.joellipman.com/articles/database/t-sql/t-sql-datetimestamps.html
14 ?? ?????? 1432 06:00:00:000AM CONVERT(CHAR(25), CURRENT_TIMESTAMP, 131) 14/11/1432 06:00:00:000AM I originally got a list from databases.aspfaq.com but the convert numbers didn't correspond to the output formats. This is my list created within my...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
an article intended for IT Support. It is a list of the system tools available in the Microsoft Windows OS that can be run from the "Start > Run" option. How? To Access… Run Command Accessibility Controls access.cpl Accessibility Wizard accwiz Add...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html
for copying this from another source but with lots of OpenSource developers disappearing and reappearing, the content is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, table2 WHERE table1.studentID = capd_table2.studentID AND ( table1.studentID = :StudentReference OR...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
this program adds NOTHING to the network traffic, and therefore is a much better measure of what data is being received/sent from your workstation. Download Available for download for FREE as OpenSource. Portable so no installation/setup (can run off...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html
so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just get rounded up without the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Development Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my connection will drop and my computer will say that it could not connect to either the TFS or my...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
on an object). The following is a method of adding this as a single command similar to how we add the "Command prompt from here" option (now built-in to Windows 7). I added this option for him in Windows 7 Ultimate using the system registry (see "How:...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
The Mermaidhttps://www.joellipman.com/articles/_other-misc/the-mermaid.html
a Friday morn when we set sail And our ship not far from land, We there did espy a fair pretty maid, With a comb and a glass in her hand, Her hand, her hand, With a comb and a glass in her hand. While the raging seas do roar, And the stormy winds do...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
window.addEvent('domready', function() { $('myForm').addEvent('submit', function(e) { // Prevents the default submit event from loading a new page. e.stop(); // Set the options of the form's Request handler. // ("this" refers to the $('myForm')...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
This is to describe how to change the value of a field of a form from it's default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value in the below field. Now click on it and it disappears, allowing...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
to be a paying member to access these and I tend to piggyback on my client's subscriptions. This information does not come from Yootheme forums. I am too lazy to answer/update my solutions in 3rd-party forums.
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
their system escape apostrophes (') and double-quotes ("). But who can honestly build a system that thinks of everything from day one? How? Check all required values to escape have been escaped. In all my cases this has been the percent sign (%) but I'm...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
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 image and so we spend more time on "how do you make it like it was in XP?" situations. How? Who doesn't want...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
the Operating System (in this case Microsoft Windows 7 Pro 32-bit) nor the chassis as we merely transferred the license from our previous machines.
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
If Null IFNULL(column_name,value_if_null) ISNULL(column_name,value_if_null) Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS Rownum Source(s): MSDN Microsoft Library (DATEPART...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
I found the process rather straightforward anyway so let's begin: Download the JDBC Driver for MySQL (Connector/J) connector from http://www.mysql.com/products/connector/ [Optional Step] Uncompress the download, then copy or move the JAR file (at time...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
)) as OldFind, REPLACE(`content_column`, @stringtoFind, @stringtoReplaceWith) AS newText, `content_column` as oldText FROM `MYTABLE_content` WHERE `content_column` LIKE CONCAT('%',@stringtoFind,'%') -- yields id title OldFoundInOld NewFoundInOld...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF