Assuming select is required, the following 239 results were found.
-
= LEN(@p_SearchString) + 1; -- Populate Cursor1 (used to generate final SQL query to run) DECLARE Cursor1 CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column_value, ''' + TABLE_SCHEMA + '.' + TABLE_NAME + '.' +...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid table names) DECLARE Cursor1 CURSOR FOR SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = @p_Column ORDER...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
So how do we do it? In the above example, Joel Lipman has two qualification records. So let's start with a simple query: SELECT RIGHT('000' + CAST(e.ID AS VARCHAR), 3) AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS VARCHAR), 3) + '01' AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
some variables DECLARE @Reset BIT; DECLARE @Ret VARCHAR(8000); DECLARE @i INT; DECLARE @c VARCHAR(2); -- specify reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM Table1 WHERE DATE(registerDate)=DATE(NOW()); -- BEFORE: count yesterdays total SELECT COUNT(id) FROM Table1 WHERE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to a number only retrieves...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for example, but everytime we refresh the data in the Excel spreadsheet, all the rows...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
down to SSL Certificates and click on the "Manage" button alongside the domain you want to install the SSL certificate for Select the Server Type and then click on "Download Zip File" button Decompress the ZIP and find the CRT file Return to your...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
under Finding your Kindle email address. However, click on Preferences this time, instead of Devices. Scroll down and select the Personal Document Settings Scroll down again and select the Approved Personal Document E-mail List. This is the list...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
so why should their documentation include it? Workaround (applies for any dll) You right-click on the "references" folder, Select "Add Reference..." Click on "Browse..." Navigate to C:\Windows\assembly Select the TxScript one in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
level solution and can follow these quick steps: Right-click the grey header of the tablix row (left-most grey part) Select "Add Group" then "Parent Group..." Specify the "Group by" (in my case "Day"), the grey part will display a grouping icon Now...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
MySQL Oracle equivalentshttps://joellipman.com/articles/else/database/mysql-oracle-equivalents.html
list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle - See if a table exists SHOW TABLES Select table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10 SELECT * FROM table1 WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
A very quick article on how to push a multi-select picklist from CRM to Creator. Why? We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to delimit...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
stopped providing, or just because it's easier for me. This program can be downloaded by visiting www.joellipman.com and selecting "Features", then "Downloads", then "Standalone programs" (or click here). There is no charge, you just need your own...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
should only enable thumbnail refreshes at the time of install. Also note, this module will NOT generate thumbnails if you select "Public" as the authorized service group. I know it's the default option but you need to select an user group with higher...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Attached Files in CRM Setup a workflow that when SO Ref changes, the tick box is unticked Form Workflows > New Workflow Select your form Run when Created or Edited When to trigger: User input of a field Choose Field: ZohoBooks Sales Order Ref Name it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
mapping, it needs the CRM Invoice module as well. Step by step fix: Login to ZohoCRM, go to Setup Under "Customization", select "Modules and Fields" Click on "Organize Modules" Enable "Invoices" (by ticking the box and clicking on "Save") Hover the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
(Original) I want to run some deluge (snippets below) every time the form loads, so I Go to Workflows > Form Workflows > Select your form Click on New Workflow Choose form (the one your radio tabs group exists on) (Record Event) Run when a record is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
customer who's boss). Now click on the pencil icon of the cloned template Right-click on the text box causing the issue and select "Inspect" (if you don't have this see alternative steps below on "Inspect page Elements in Chrome"). In the Developer...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *