Search - Joel Lipman .Com

1. What can MAGA’s do to stop Biden from cheating again?: / Jokes /; ... guy says, "167." The robot proceeds to chat with him about subatomic physics, black holes, and game theory. Curious, the guy comes back a second night. "What'll you have?" says the robot and the guy ...; Created on 28 August 2024
2. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... Quote". Within your function you can use the following as a reference. In theory, you could loop through each submitted quote but I do a call at the beginning of each iteration of the loo ...; Created on 06 December 2020
3. Split a row into multiple rows based on a column value: / Transact-SQL /; ... is but it doesn't seem to affect the functionality of the above and you could always hardcode a 1.00 if its confusing. In theory, if you know the shift patterns of an employee, you could enhance ...; Created on 23 August 2013
4. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; What? A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then ...; Created on 04 April 2013
5. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; ... - CHARINDEX(@Delimiter, REVERSE(@Haystack)) + 2, LEN(@Haystack)) -- yields "String4" Yay!!! Done! Untested but in theory: SELECT REVERSE( SUBSTRING( REVERSE( @Haystack ), 1, CHARINDEX( ...; Created on 28 January 2013
6. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... takes over an hour to process but in theory this should accommodate it. Problem #1 If zero rows are returned from the search, then there is no REPORTSTARTTIME. There are two options here: Creat ...; Created on 17 November 2011
7. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal. In Theory: SELECT ...; Created on 03 August 2011
8. Create Read-Only Database User in SQL Server: / Databases /; ... of the db_securityadmin fixed database role can modify role membership and manage permissions. Adding principals to this role could enable unintended privilege escalation. In theory, a user who ...; Created on 09 November 2010