Assuming point is required, the following 34 results were found.
-
click Yes. Restoring in SSMS, Right-click on the database Select Tasks > Restore... > Database Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish Date" is the one you want. OK...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
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, LEN(@Haystack) -...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
horizontally and vertically in a screen/viewport in pure CSS (no JavaScript allowed). This CSS centers it by its center point rather than the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
with regular expressions is shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if they do not:...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
have seen this all over the Internet as the accepted solution... Doesn't work for me because I'm using cURL but it's a first point of reference. This will work if the received XML is a string. // setting XML value $string = ' 2/13/2013 10:37:24 PM...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
as this is from within a web application, there are no extra options or dialogs to select. The export had to work from this point on. I can't take any credit for the below as it was copied from http://hosteddocs.ittoolbox.com/ST030504.pdf. A "Crystal...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
39.81111111 116.7083333 Note that negative numbers should be supported. I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ). Merging the lot If B1 contains the coordinates and there...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
for example ‘to pay for shipping’. The cheque will clear into your bank account, only to be refused weeks later. At this point, the bank/building society will take the full cheque amount back out of your account. This would then leave you out of pocket...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
Source: http://www.reddit.com/r/IAmA/comments/9usm7/iama_local_tech_repair_man_i_run_my_own_business/ I love the last point. Down talk as opposed to hype and then produce. Even with most services this nearly always guarantees a happy customer. "So this...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
// yields 30 And if working with money/currencies, a one liner to maintain the decimal point v_SalesAmount = "Total : £ 5.00"; v_SalesAmount = v_SalesAmount.replaceAll("[^0-9.]",""); // yields 5.00
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to be an Integer UINT Forces the value to be an absolute number (-4.2 becomes 4.2) FLOAT Forces the value to be a floating point value BOOL Forces the value to be true or false WORD Strips anything that is not letters (including numbers) ALNUM Forces...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
the word -incognito (including the hyphen/dash) to the end of the Target value Ok that and see if it works Note that if in point 4, if there are any spaces in that value, you should add a double-quote character to the beginning and end of the location...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
future-proof and as everlasting as human error. More? "By [undoing] repeatedly, you can gradually work your way back to a point before your mistake. This is convenient if you've made a mistake four or five commands back. It is marginally useful if...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *