Assuming microsoft is required, the following 79 results were found.
-
to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
if no parameter Name := ( Name="New Tab - Windows Internet Explorer" ) ? "about:Tabs" : RegExReplace( Name, " - (Windows|Microsoft) Internet Explorer" ) For pwb in ComObjCreate( "Shell.Application" ).Windows If ( pwb.LocationName = Name ) && InStr(...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
to: Microsoft Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
to: Apple iOS 7 Apple iTunes 11.1.3.8 Microsoft Windows 7 Professional What? Just so many articles out there that did not help me. This article is how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
are not blank/null. Browsing the net, I found this is sometimes also used for inserting blank rows to act as dividers. Microsoft Certified Responses: "In the Excel connection you cannot skip Nth rows." "It is not possible." I am shocked at how responses...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
image. Solution #1: Image does not appear within SSRS Configure the Unattended Execution Account: According to Microsoft and Stack Overflow, your reporting server needs to have the "unattended execution account" configured. Some sources are specific...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Manufacturer: Microsoft Bridging to MySQL OLEDB This is just one connection string sample for the wrapping OleDbConnection class that calls the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
AS Rownum LIMIT from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS Rownum Source(s): MSDN Microsoft Library (DATEPART (Transact-SQL)) MSDN Microsoft Library (DATENAME (Transact-SQL)) MySQL Documentation - String Functions MySQL...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
yyyy HH:mm:ss") =Format(now(), "dd/MM/yyyy") The reserved expression letters used are on the MSDN website at http://msdn.microsoft.com/en-us/library/ms146084.aspx NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products. Why? I googled and...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
this is how I connected to a MySQL database from within the Business Intelligence Development Studio (BIDS) IDE from Microsoft. Required: Windows XP (ODBC Data Source Administrator) MS Business Intelligence Development Studio 2008 Test/Sample MySQL...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
255); /* RGBa with 0.6 opacity */ background: rgba(255, 255, 255, 0.6); /* For IE 5.5 - 7*/ filter:progid:DXImageTransform.Microsoft.gradient(startColorstr=#ff000000, endColorstr=#ff000000); /* For IE 8*/ -ms-filter:...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
to SITS:Vision v8.7.0 Uniface v9.6.03 Microsoft Windows 7 Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 What? "Quick" may not be the right word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors and...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The excel...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
we'll skip Windows 8 and wait for Windows 9, but in the meantime we need something that flows as smooth as any other Microsoft product with Windows 7 as its Operating System: Proposed for January 2013 (5 suppliers) Processor Intel Core i3 3220 Dual Core...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
server that requires it. Let your report server administrators do this: On the server, open the XML file: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RsReportServer.config Set the recycle time to 0: 0 Restart...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to: Microsoft Windows XP How? I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
to: Microsoft Windows 7 Enterprise AutoHotkey (see code for AHK version) What? Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better and have it calculate to the nearest second. I call this latest app...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *