Assuming find is required, the following 162 results were found.
-
This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for transactions...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and this did the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is just a note for me as it took a while to find 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
asking if I can take over a project that has been abandoned by its developer. I've started writing this article because I find myself forgetting to ask something that could have saved an infinite number of man-hours (I exaggerate a little); but...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
three usb extension cables. The middle one wasn't connected to anything on either end. What not to say to IT "Hi could you find and tell them to unlock the record they are viewing". "Oh that person isn't at work today". "Well someone on that computer...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
auto-versioning) --- Version status (stable, RC, beta, alpha, etc) --- Parent Project Name --- Specify Download URL (or auto find?) --- Author / developer / team name (Free text / associated to uploader) --- Create Date / Modified Date / Expired Date...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
SSRS / MDX Date Querieshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html
I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the page after a certain time. Conclusion In the end, this came down to a design decision. Time spent on trying to find a solution was not considered to be warranted. My reports use a parameter for the connection string to specify which server and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
in descending order, I would recommend you return it in SQL date format (yyyy-mm-dd) and then do "Sort Z to A". You may find that the field needs to be unlinked and relinked each time further dates get added which is why you should leave it in ascending...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
query they used to determine whether to display an image or not. Bit of a cop-out I know but after two weeks of trying to find a solution, I would definitely recommend seeing if you can't check at the database level first. I will in future. Debug Method...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
these in SSRS and then resorted to my old methods of debugging. For those of you who don't know what a cursor is, you can find this info on another site as this article focuses on getting an Oracle stored procedure to work with SSRS. Main Example: My...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
but with some group policies, you will get an "access denied" message. If you don't have a C:\windows folder, then find your "cmd.exe" program and change the path in the above instructions accordingly.
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me find all the articles that need this change: SET @stringtoFind=' '; SET @stringtoReplaceWith=' '; SELECT `id` , `title` , IF(LOCATE(...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
function is used for several tables, the Needlemarker tells the function to start from where it last found a table and to find the next: ExtractText( Haystack, Needle1a, Needle1b, Needle2a, NeedleMarker ){ Needle1 := InStr( Haystack, Needle1a, false,...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
provided with SQL Server and without having to download any third-party products. Why? I googled and binged and all I could find were people selling third party products... they don't get it. If you are reading this, it's likely you've paid for a...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
(or £10/mo). This includes keeping the servers up-to-date and running with the latest technologies. You are welcome to find and use your own website hosts with their own support plans and I can help you configure these for the source files (as per my...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
on a non-object in /public_html/index.php How? Not really a solution here because this is indicating that the system can't find the core framework files. Yes the bad news is you have lost your site. The good news is that it's only the core files and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
OR @GivenForenames'' OR @GivenSurname'' OR @GivenDOB'') -- The TOP 100 is what improved our performance. -- If you can't find the person in your database in the top 100 of your search -- then you must be limited on what you know about this person......
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF