Assuming added is required, the following 114 results were found.
-
exists in another XML with an identifier called @+id/hangar_aircraft_photo. The following is a full example of what can be added to a Main Activity Java file and will display an AlertDialog with the 3 options to "take a photo", "choose from existing",...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source and to populate a database table...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Properties' Add a condition to the WHERE clause Specify that the field name in the series fields is not blank So I've added the AND line to the above statement yielding: SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name]...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Problem #1: More of an aesthetic problem than functional but when the room didn't contain equipment (or the admins had not added the equipment info on the system), it just showed the heading "Equipment". Iteration in T-SQL? Unlike good old MySQL where...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
image if file does not exist We 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
record as well as an audit table. The Problem The last report will execute the stored procedure without any problems. I added a second dataset on this report to select the updated data that this stored procedure commits but unfortunately SSRS process...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
decided to do a database level 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
statements. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Ignore Prepare=true; The option was added in Connector/NET version 5.0.3 and Connector/NET version 1.0.9. Specifying port Use this one to specify what port to use for...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
adding this as a single command similar to how we add the "Command prompt from here" option (now built-in to Windows 7). I added this option for him in Windows 7 Ultimate using the system registry (see "How: for Windows 7" below). -- yield...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once you've added your parameters (date/time type): Right-click on the DataSet. Select 'DataSet Properties. Find your parameters in the Query. Check...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
the "fx" button to enter the below expression: Delete Order Column: Ok the expression and BIDS will add the parent group we added just before. You can now right-click on the top of the [Order] column (grey square -like excel- to select the column)....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
results SELECT * FROM #myScrambledTable; END GO -- Usage: -- EXECUTE dbo.usp_MakeTableTemp 'mySchema.myTable'; Post-Notes Added a dummy index to track row numbers. Copies structure (column_name, data_type, character_maximum_length) Copies data (should...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
+ rm.[Zone] + ', ' + CONVERT(VARCHAR(4), rm.[Capacity]) + ', ' + rm.[Type] + ', ' + rm.[DeptId])) AS RoomDetails // success! added CONVERT(VARCHAR(4) to the room capacity which was of datatype int.
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
c.value('local-name(.)', 'nvarchar(50)') FROM Event_XML.nodes('/*/*[contains(local-name(.),"SURNAME")][1]') AS r(c) -- added [1] to only get 1 result returned ) AS Node_Surname FROM [dbo].[XML_EVENTS] Search if Node or value contains string: -- exist()...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
-- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS ADDED TO REGEXP (eg. apostrophe) WHILE (@i 0 BEGIN -- get the delimited word SET @CaseLen = CHARINDEX(',', @CaseExceptions, @i+1) - @i...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Report Type (for just a table with a heading row at the top, select "Tabular") > Next Click on "Details" until everything is added. > Next I'm boring and old-school so my table style will be "Generic". > Next FINISH That's all folks! Hopefully this will...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Resource to Row and PersonDays to Values Tick a field that will be the parameter/filter/criteria (it will be automatically added to row or column), then click on it and select "Move to Report Filter". Shout in Gordon Ramsey-style: Done! Better than......
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
should put this at the beginning of the article as it is what you should do before running a DELETE FROM statement but I've added it here as I use it quite often: SELECT s.sessionId, ssf.sessionId, sst.sessionId FROM `Session` s LEFT OUTER JOIN...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *