Assuming where is required, the following 228 results were found.
-
of greater than 1: Almost! A problem not covered by many sites was happening to me when I had blank rows in a flat file, where it appeared to add the special carriage return or line feed characters to the next viable row, see my original data file here...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
"C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents" /Y REM Returning to directory where this BAT is held. CD "C:\Temp" ECHO Done. Deployment Method #?: As a setup.exe Package the visual studio project by adding a "setup wizard" project....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product with an example. As my work was for a Personnel/HR project,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we could use the HTML...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
+ e.TimeProcessing + e.TimeRendering AS TotalTime FROM [ExecutionLog] e INNER JOIN [Catalog] c ON c.ItemID=e.ReportID WHERE c.Name='My Amazing Report' -- just change the value here to the name of your report ORDER BY e.TimeStart DESC Deploy the report...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
run and email the report can access the datasource (ask a DBA if you're unsure). Parameter-Driven DataSource In the folder where you put your Data Sources, click on the button "New Data Source" Specify the details, especially the connection string...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
do this in the name of the column heading, the answer is a much simpler one, in your SQL statement, simply place your cursor where you want the carriage return and press Return/Enter. This has to be a label to the name of the column enclosed between...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
is on the page http://www.hardwareanalysis.com/content/topic/46202/. The chap went to www.apacer.com which is just where I’ve been trawling through and I have found a utility that actually works on my pen!!! It said “repaired USB pen” and when I go to...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
TimeRendering, ByteCount, [RowCount] FROM Catalog INNER JOIN ExecutionLog ON Catalog.ItemID = ExecutionLog.ReportID WHERE ExecutionLog.TimeStart BETWEEN @DateFrom AND @DateTo AND Type = 2 ) AS RE GROUP BY Name ORDER BY COUNT(Name) DESC , Name
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
INSERT INTO @OutputTable ( StringValue ) VALUES ( @StringValue ) END RETURN END And one more time for a more common purpose where it converts a string of words delimited by commas to a table: CREATE FUNCTION [dbo].[ufn_CommaStringToTable] (...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
( c_test out sys_refcursor, p_STUDENT_ADNAME in varchar2 ) IS BEGIN OPEN c_test FOR SELECT * FROM student_accounts WHERE student_username = p_STUDENT_ADNAME; END; View the results? Oracle PL/SQL is a bit of a bugger as you need to do a few other things...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
AS WeekNumber, @thisDate:=DATE_ADD("2012-07-09 00:00:00", INTERVAL (@count*1) WEEK) as StartDate FROM WeekStructure WHERE @count
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
t SET t.`myColumn`=REPLACE(t.`myColumn`, 'ż', 'z'); Retrieve records with foreign characters: SELECT * FROM `myTable` WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional My Joomla website needed the following code to display the above...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
contact details) Rates (usually £9/hour for non-e-commerce sites or £15/hour for e-commerce) Similar looking websites where layouts/colour schemes can be adapted Explain accessibility and usability industry standards. (includes iPhone compatibility and...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
"belt-and-suspenders" Just like the UK's idiom "belt-and-braces", ‘Belt-and-suspenders’ describes an approach to web design where provision has been made for more than one method of achieving a satisfactory outcome. typosquatter A typosquatter is a...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
the javascript file '//assets.pinterest.com/js/pinit.js' once in the page Customize your feed and Copy & Paste the code where you want it to appear // example: replace myPinterestAccount with your account
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
these. Fine on screen but this is obviously for when it comes to printing. Why? I needed to create a template in HTML where the first page is a cover page (background image filling the page with a logo floating at the centre) and the next page has a...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
This is an article I hope to refine one day where given a set of breadcrumb hyperlinks, when I hover the mouse over the links, the text changes and the transition between the two is controlled smoothly. Why? At time of print, I couldn't find any clear...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
I'm going to make our system recognize SWF files (by default these are disallowed): Firstly: Add the following line to somewhere in the LocalSettings.php file in the web root folder where your MediaWiki is installed: $wgFileExtensions[] = 'swf'; or if...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
is the offset and means when this function is used for several tables, the Needlemarker tells the function to start from where it last found a table and to find the next: ExtractText( Haystack, Needle1a, Needle1b, Needle2a, NeedleMarker ){ Needle1 :=...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB