Assuming specify is required, the following 98 results were found.
-
NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
returns typed XML SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER') FROM [dbo].[XML_EVENTS] -- value() returns single value, specify data type as second parameter SELECT Event_XML.value('(/STAFF/EMPLOYEE_NUMBER/@name)[1]','varchar(20)') FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
BEGIN -- declare 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...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
of working with dates which made this need to be changed. The following function now requires a second parameter where you specify the data type: CREATE OR REPLACE FUNCTION UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype IN...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Next Click on the "Query Builder" button Right-click on any empty space in the first frame > Select "Add Table..." Add and specify the query as you would with any SQL query. (to create the dataset) Select the Report Type (for just a table with a heading...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say specify the table you will NOT be adding these rows to... SET @count:=0; SELECT '2012/2013' AS SetID, (@count:=@count+1) AS WeekNumber,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
2007 > New > "Blank" Connect to data source: > Data tab > From Other Sources > From Microsoft Query > select Data Source Specify SQL Query: > Add Tables (not really just "close" this) > click on SQL button > Type/Paste your SQL Query > OK > Click on...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
as shown in the following picture: And I want the clouds as another layer ontop aligned to the top right: Tried and failed: Specifying the width of the div layer the same as the image and positioning the div. This causes a scrollbar at the bottom. Tried...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
How? You could do loads of code hacks which is what I tested but all for nothing because you always end up needing to specify a third of the width. Our template was 900 pixels in width. I tracked down some code that was simply calculating with 33% as...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
start of the extract (1a), a second string (1b) to refine the starting position of the extract, and a third string (2a) to specify the closing position of the extract. NeedleMarker is the offset and means when this function is used for several tables,...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
$api_url); // where to send the variables to curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml')); // specify content type of what we're sending curl_setopt($ch, CURLOPT_HEADER, 0); // hide header info !!SECURITY WARNING!!...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
URL from the HTML file launching this function (not from the if external JS)) // add parameters to this function to specify rows based on a criteria var my_array = populate_array_from_csv(this_file_url); // eg. var my_array =...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
where -- SUBSTRING(img_timestamp, 1, 8)>=20110922 ORDER BY img_timestamp DESC Note that I've commented out the lines which specify images modified since the 22nd of September 2011. I've left it in there for my own benefit as it's unlikely I'm asked for...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
for a particular week. When I open the report, each drilldown row is collapsed (as opposed to expanded). The user can specify the date as it's a report parameter. What we want The user will select a date. We want the report to open with the specified...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 select the column that has just been...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Red (for Fail), Orange (for Unknown). Right-click on the rectangle and select Insert > Image Edit the Image Properties to specify the image to use. The image can be an expression as well (I embed these and then refer to them in the expression by name)....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
(Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB