Posted in Uncategorized

This query checks if one account is located inside a group container to determine if…

Continue Reading SQL

SQL

Posted in Uncategorized

This code displays the usage of the nvl() and the coalesce() functions. Both are used…

Continue Reading SQL

SQL

Posted in Uncategorized

This query will show changes made to a vehicle Recall. The returned values of 0,…

Continue Reading SQL

SQL

Posted in Uncategorized

This query will track all changes made to a vehicle’s appraisal while displaying it’s active…

Continue Reading SQL

SQL

Posted in Uncategorized

This query will track the changes made to the OEM Cash available on a vehicle….

Continue Reading SQL

SQL

Posted in Uncategorized

These queries will find which software/company is importing the vehicle appraisal information, another query to…

Continue Reading SQL

SQL

Posted in Uncategorized

This query will track changes to the account that controls which website host it will…

Continue Reading SQL

SQL

Posted in Uncategorized

This query will track changes if the user manually removed a vehicle from their export….

Continue Reading SQL

SQL

Posted in Uncategorized

The vAuto program is used by car dealers and the Provision module will create competitive…

Continue Reading UI/UX

UI/UX

Posted in Uncategorized

This query will find the creator of a custom report based on the email of…

Continue Reading SQL

SQL