Search - Joel Lipman .Com

41. Proposed Budget i3 PC under £200: / IT Support /; ... of our developer's equipment and the verdict is that our workstations need upgrading (it always is). So on a budget (ie. as cheap as possible), we'll skip Windows 8 and wait for Windows 9, but in the meantime ...; Created on 26 January 2013
42. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; What? Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the ...; Created on 26 October 2012
43. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it ...; Created on 01 August 2012
44. MySQL day of week ending on Friday: / MySQL /; ... Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The solution below is for the ...; Created on 26 April 2012
45. SSRS Zero Padding: / SQL Server Reporting Services /; Quick Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We ...; Created on 10 November 2011
46. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... the Stored Procedure and the SELECT at the same time; this meant the report would say the process failed but when I check the logs, it successfully ran the stored procedure (updating both tables). ...; Created on 04 November 2011
47. Stop Excel Row Height Self-Adjust on Refresh: / Excel /; ... and production, means that anyone with access to the Excel spreadsheet can go and view the connections and see the username/password details (granted read-only access). One of the requirements was that ...; Created on 30 September 2011
48. SSRS External Images don't displa: / SQL Server Reporting Services /; ... on the status of a student in any case. This meant that I could use the same Oracle PL/SQL query they used to determine whether to display an image or not. Bit of a cop-out I know but after two weeks ...; Created on 19 September 2011
49. Person: Created on 08 October 2015