Assuming part is required, the following 57 results were found.
-
= 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
-
on the net and even then it was confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in the row - unless there's a faster way) and instead of...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
$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: *
-
combined all 10 dataset queries into 1 mega dataset query, problem solved… Another workaround exists where if I added the OR part to all my datasets (so where each one says if studentreference is blank then compare to studentadaccount)… Both solutions...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html
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
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
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
-
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
-
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: *
-
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: *
-
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
-
Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so "IT Department" and "Director of IT". "O'REILLY" should become "O'Reilly" and not "O'reilly". "MCDONALDS" should become "McDonalds" but...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
we only needed the core files, a working system, and then we could proceed with a standard Joomla update. I suspected that part of an auto-update process had corrupted all the files. In our case, the problem was that the system tried to update Akeeba (a...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
This is an extract from a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin that comes with Joomla 2.5 install. How? Source: Joomla! •...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
page. The tool analyzes any input on-the-fly without sending or receiving data to a server. The page used to be a part of a Password Security System I wrote back in 2008 and I missed the analysis capability so I have restored it on my personal website....
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
a list of files containing strings. Each string should be in a separate line in the files. When any of the strings match any part of the absolute path of the file to be copied, that file will be excluded from being copied. For example, specifying a...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
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: *
-
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
-
-- 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: *
-
= 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
-
and forwards to Zoho rather than getting my client to do this. The aim is to take up as little time as possible of the third-parties involved, plus the documentation online was in parts and requires going to several pages across the Internet. Here I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF