Assuming select is required, the following 239 results were found.
-
an employee who took 2 days off, we would want 2 rows for that date for the same employee in the new system. What we have: SELECT EmployeeNo , DaysOffSick , DateOfSickness FROM Employees_Attendance_Table -- yields EmployeeNo DaysOffSick DateOfSickness...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
...the one with users names... Teams...another lookup table for just the name value... The one query to rule them all SELECT CONCAT(s.LogID, ' ') AS ActivityID, t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, CASE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
top of the list print out each row with the number of times that particular data appeared in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
system and you should be presented with a cleared/new record Complete the form noting the name of your XET Code and then selecting the appropriate dictionary and entity; here we are using SRS as the dictionary and CAP as the entity. (If your change...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
from. The following is a MYSQL query that displays the structure of all the columns in all the databases of the localhost: SELECT * FROM information_schema.COLUMNS ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
A super quick article on how to pre-select the pipeline on deal creation within CRM based on the department specified on a user's profile. Why? A client asked that when staff create a deal/opportunity record in CRM, the pipeline is automatically...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Const WM_HSCROLL = $0114 Const WM_VSCROLL = $0115 Const WM_INITMENU = $0116 Const WM_INITMENUPOPUP = $0117 Const WM_MENUSELECT = $011F Const WM_MENUCHAR = $0120 Const WM_ENTERIDLE = $0121 Const WM_MENURBUTTONUP = $0122 Const WM_MENUDRAG = $0123 Const...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
; Subroutine: ButtonBrowse: Onclick allows user to select a folder to scan ButtonBrowse: FileSelectFolder, vSelectedFolder, 3, , Select a folder if vSelectedFolder = MsgBox, You didn't select a folder. else { vSelectedFolder :=...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
EU datacenter: https://api-console.zoho.eu/ If this is your first app, then click on "Get Started" and select "Server-based Applications" by clicking on "Create Now" on the appropriate box. If this is not your first app, just select "Server-based...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
then has to click on various settings and run the Mail Merge; then has to click on "execute function after merge" and select the function to run (this would initially attach the file to the CRM record). This wasn't working really as there are issues...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the following code which loops through some Creator records, then loops through one of the subforms in each record: // select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through these for each r_Record in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Save this and return to the list of functions Hover over the function you just created, click on the 3 dots/ellipsis and select "REST API" Switch on the API Key and copy the URL to clipboard or a text editor Click on "Save" Setup a Xero webhook: Login...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
join this to the contacts data table. So I'm going to make this first query and save it as "Contacts vs Campaigns Pivot": SELECT * FROM ( SELECT "Contact Id", "Contact Name", "Campaign Name", "Member Status" FROM "Campaign Members - Contacts" ) t1 PIVOT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
phpBB3 Administration Control Panel (ACP), which should be located at something like http://www.mysite.com/phpBB3/adm/. Select the "Styles" tab. You should see a row with "Affinity" at the bottom. Click on "Install", set as default and that's it.......
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Turquoise". Yootheme uses CSS files to do this so we'll need to modify the XML file and add some files that this will select. Modify \templates\\config.xml add the select option "Ambient Turquoise" to the end of the list: Grey Dots Tartan Lines Dark...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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 ItemName, DATEPART(dayofyear, ItemDate) as DayOfYear, DATEPART(year, ItemYear) AS YearRun, COUNT(ItemName) AS Counter FROM...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS ReportStartTime FROM... Then add another dataset (using the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
16-Jul-2014 17-Jul-2014 18-Jul-2014 2 21-Jul-2014 22-Jul-2014 23-Jul-2014 24-Jul-2014 25-Jul-2014... How? To do this in a select query resultset, you insert the special character references "CHAR(10)" [line feed] and "CHAR(13)" [carriage return] but to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
Show me the Name! A quick query to show the execution log with at least the report name for us human users: SELECT a.[InstanceName] ,b.[Name] ,a.[UserName] ,a.[RequestType] ,a.[Format] ,a.[Parameters] ,a.[TimeStart] ,a.[TimeEnd] ,a.[TimeDataRetrieval]...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB