Assuming part is required, the following 58 results were found.
-
Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using Business Intelligence Development Studio v2008 (BIDS) SQL Server Reporting Services v2008...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
like a thousand separator, and lose the decimal ".00". I need the size of the report but the value has to be returned as part of the aggregate query. I want the SQL to return just numbers and let the MDX query add the thousand separator. My answer for...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
= DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) --First day to display on calendar SET @StartDate = DATEADD(DAY,-DATEPART(WEEKDAY,@StartDate)+1,@StartDate) --Last day of month SET @EndDate = DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Monday Monday Monday Tuesday Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday */ This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our end customers are not even computer literate so the SQL query had...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy a given table into a temporary table all the while maintaining the structure and data. Thinking...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last part of this, ie "String4". So I need to delimit based on the dot/period (.) and use substring in a sort of reversed form. For...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
be converting long paragraphs of English text. Instead 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...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
others but this one's got that "kiwi" approach) A few terms I wanted to list up: "above the fold" or "before-the-scroll" The part of a webpage that is visible in the web browser window when the page first loads is described as being ‘above-the-fold’....
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
overflow:hidden; } #slide_01{ position:relative; float:left; } #slide_02{ position:relative; float:left; } The JS/Mootools Part Apologies for the mess as the solution I'm working on is far more complex and I need to keep extracting the basic mechanisms...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
= curl_exec($ch); // close connection curl_close($ch); Things I stumbled upon regarding SSL and cURL Posted data for third-party apps is often required via SSL so this may come in handy curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch,...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
-- yields: A colleague of mine found this ABLANK solution. It took two of us the best part of two days to come up with the SRL syntax... Our XSLT can then do the following: -- for *LookupFailed* both code and name will be blank. -- possibly use...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
the symbol omitted using the formula: =SUBSTITUTE(B3, "₱", "") Which leaves the value as a literal string... Now the tricky part, how to copy into a column just the number? Even if I tell it to multiply by 1, Microsoft Excel gets confused and reports an...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
$150 for “forensic data recovery” with “no guarantees” – while recovering from the backup I’d made silently. I guess it’s part of the “underpromise/overdeliver” thing… but several customers were intensely relieved when I was able to “work my magic” and...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
email address. That’s assuming you are not aware of yours. However, if you know your Kindle email ID, you can skip this part. Else, here is what you need to do. Go to the official Amazon home page that applies to your region. Sign in with your Amazon...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
been created with just one item with no title and positioned at the bottom of another menu; this would look like it was all part of one menu). toubkal wrote: This cannot be done by joomla administration but can be done by template code, you can have a...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which you need for the below). The image link (src) will be as below but then...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
a DJI Phantom FC40 to film a part of Angeles City, Pampanga, Philippines. {youtube}B9afOeBUqpg{/youtube}
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *