Assuming select is required, the following 241 results were found.
-
We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
The aim of this article is to document how you can display a Creator report to the user, that they can select (tickbox) multiple records in that report, and then have a button that loops through all the selected (ticked) records. The example below...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
to see your datasheet (has a MS Access icon in the top left to remind you what you're getting yourself into) Go to Settings Select Create View Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
set. Something like: The DataSet This should work on your reporting server as well. I'm using the database "ReportServer". select * from ( SELECT TOP 1 c.[Name] AS [ReportName] , e.[ReportID] AS [ReportID] , e.[TimeStart] AS [TimeStamp] , e.[Parameters]...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ', YEAR(t2.Date)) Month, SUM(IF(t2.VisitorType='Staff', 1, 0)) Staff,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
a stored procedure that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)] FROM DUAL; option1 can be: RANDOM VALUE STRING option2 can be: U (for Uppercase) L (for...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
memory, report layouts and a few days worth of other solutions dotted about the web but the biggest improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference =...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
/ Add New Connection Click on the "Zoho OAuth" icon Enter a Connection name (for this example I will call it "CRM API v2") Select the appropriate scope(s): ZohoCRM.coql.READ Required! ZohoCRM.modules.{module_name}.{operation_type} or ZohoCRM.modules.all...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
sent to a compressed folder. the Import process Simply login to ZohoCRM > Go to Setup/Settings > Under Data Administration, select "Import" > Select Zoho CRM Now upload all the files needed for your import: this will be the Attachments.csv,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
| Mirror 1 Right-click on the AppleBcUpdate.exe file and select "Show more options" > Hover over 7-Zip > Select Extract to AppleBcUpdate > Browse to this folder > Browse to "ApplePrecisionTrackpadBluetooth" Right-click on...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again you need permission to create this function. Don't forget to GRANT permission to...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND within a function CREATE VIEW vwRandom AS SELECT RAND() as RandomValue; GO The Function -- Drop the function if it already exists IF OBJECT_ID ('ufn_DataScramble', 'FN') IS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
-- I want "String4" from Haystack SET @Delimiter = '.'; PRINT @Haystack; -- yields "String1.String2.String3.String4" SELECT REVERSE( @Haystack ); -- yields "4gnirtS.3gnirtS.2gnirtS.1gnirtS" SELECT CHARINDEX(@Delimiter, REVERSE( @Haystack )) -- yields...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
query to get just your articles from your MediaWiki CMS: -- to get articles from MediaWiki CMS: Let's call it STATEMENT1 SELECT wikimedia_page.page_id AS PageID, CONVERT(wikimedia_page.page_title USING latin1) AS PageTitle,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
the CRM integration, the Survey will already be associated with an email address. If not, then see the 2nd snippet of code. SELECT concat('REF-', left_pad(to_integer(substring(r2."ID", 8)), 6, '0')) AS "Attempt ID", s."Title" AS "Survey", r2."End Date"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
title, comment, ip, date, isgood, ispoor, published, subscribe, source, source_id, checked_out, checked_out_time, editor ) SELECT id, parent, CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))='' THEN 0 ELSE SUBSTRING(path, LOCATE(',',...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
up on the MSDN page for the closest solution but it still didn't work for me. But the idea of inserting a NULL entry to select sounded good. Aim / Objective The plan will be to replace the default "" with a custom null entry and the end-user will be...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
website. Reboot if necessary Navigate to http://browsers.evolt.org Scroll down to "Internet Explorer - Microsoft" Select Win32 > standalone > ie6eolas_nt.zip Download the ZIP file Scan for threats Decompress/Extract to a folder (by default it will...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Data into the temp table IF @WhereClause IS NULL SET @WhereClause = ' 1 = 1' SET @SqlStatement = ' INSERT INTO #Scramble SELECT NULL,' + @ColumnName + ',NULL FROM ' + @TableName + ' WHERE ' + @WhereClause INSERT INTO #Scramble EXECUTE (@SqlStatement) --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
very similar with different column names. I also don't want the data to produce double the number of columns. My Solution SELECT title, intro FROM ( SELECT `title`, `introtext` intro FROM `jos_content` a WHERE a.state=1 UNION ALL SELECT `name` AS title,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB