Assuming unique is required, the following 32 results were found.
-
??? - ??? More Info: - ******************************************************************************* */ // v_CountUnique = 0; v_CountTotal = 0; v_CountDeleted = 0; // // pagination v_PerPage = 500; // // loop through pages to fetch as many as possible...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
sudo npm install -g zoho-extension-toolkit (this also updates existing install) sudo zet init select Zoho CRM enter a unique Project Name cd to the new project name To give permissions to write sudo chmod -R 777 . open the newly created widget.html file...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
pay special attention to the date you select. Datacleansing / Tidy Up There's a strong chance of duplicate transactions; unique from the automatic feed, and some from your manual import (workaround while feed was down). You will need to delete the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
use but also the database name - by this step, "my_new_database" should have been renamed). Save the SQL file, this is now unique to your website and this process. It does not contain usernames or passwords but has the real database names and all...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
define('DB_PASSWORD', 'my_database_password'); /** MySQL hostname */ define('DB_HOST', 'localhost'); /** * Authentication Unique Keys and Salts. */ define('AUTH_KEY', 'my_auth_key'); define('SECURE_AUTH_KEY', 'my_secure_auth_key');...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
that sounded good enough for our customers. The Workaround we actually went with Our Stored Procedure would check if the unique identifying number (in our case StudentID) matches a record in the database table and that the request number was...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Drop If Object Existshttps://joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html
(CLR) DML trigger TF = SQL table-valued-function TR = SQL DML trigger TT = Table type U = Table (user-defined) UQ = UNIQUE constraint V = View X = Extended stored procedure
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
(DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
seem a bit complicated in that not many might be aware Amazon allots an email address to every Kindle owner, and that it is unique for every Kindle device. Finding your Kindle email address. That’s assuming you are not aware of yours. However, if you...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
make a duplicate of the report that you want to use as a template. Rename the copy (suffix with template?) Remove objects unique to the report and leave elements for all reports. File > Save selected item as... For SSRS 2008: Save in the folder:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB