Assuming result is required, the following 61 results were found.
-
FROM [ROOMS] rms WHERE rms.SiteId=@siteId AND rms.SetId=@setId ) You should be able to provide this statement with a result set similar to the following (if you include a tooltip with loads of info then just picture it at the end of these fields): Time...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically. How? So there are...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
about 10 minutes without the possibility to cancel (link not working!?) and eventually would display circa 3000 matching results. If I attempted to check this in "preview" mode using Business Intelligence Development Studio (BIDS / VS2008), the IDE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A lot of articles out there on the net are offering solutions that do the exact opposite. Basically, I want the opposite result of "Fixed headers while scrolling". How? Once I figured out why I had a scrolling issue, the reverse was easier to work out:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the website to open a program on your computer (opens Outlook). Confirm the prompt your Outlook instance generates as a result. You now have a new calendar under Other Calendars, you can open another calendar alongside and now copy events over by...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
'nchar', 'varchar', 'nvarchar', 'text', 'ntext') ** ** AND TABLE_SCHEMA='dbo' ** ** ** ** - For performance, return results based on string length which is 1 greater or lesser than the original ** ** string value: ** ** Automatic: ** ** @minStringLength...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
the time of the event e.EventDate, --event details to display e.Note --CTEs defined above are used as the queries for the results FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS DATETIME) = d.[Date] --Set the maximum...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
'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() returns 1 or 0 if a node...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty result set. Furthermore I am using this stored procedure in a SQL Server Reporting Services (SSRS) environment and don't want to...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
data but the same length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The equivalent functions have to be written up all in the...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
character list are returned as a match. For example, to exclude the characters 'a', 'b', and 'c' from your search results, use the following regular expression: [^abc] This expression matches characters 'd' and 'g' in the following strings: abcdef ghi...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
occurrence of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by Split+Count took : 0.44112181663513 Seconds Count by Preg_Match+Count took : 0.46423101425171 Seconds...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result by prefixing with leading zeros (for sorting purposes - eg. so 10 is not before 2) Store both the formatted count and the...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
from the a sample table: $db =& JFactory::getDBO(); $sql_utf8 = "set names 'utf8'"; $db->setQuery( $sql_utf8 ); $temp_result = $db->query(); $sql = 'SELECT '.$modulescancontentsql.' FROM #__content WHERE state=1'; $db->setQuery( $sql ); $rows =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
EOT and TOT Your target database table should now be populated... » Read the below "Testing" steps if you aren't getting a result :) Testing: Manual export of XET Run the relevant screen (in our demo this is Application Clearance Decision (ACD)) Go to...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
line), but our customers were complaining it became too convoluted and cramped when refreshing data and preferred the end result with this change. Note on "row height": We did not want the customer having to format the report after they've already gone...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
it kept showing the certificate for last year. Chatted to GoDaddy who said use incognito mode and clear cached files - same result Downloaded the ZIP file from GoDaddy for the 7th time and extracted the 3 files Opened CPanel and went to the SSL/TLS...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
are using images, then you will get problems with the image repeating... so use moveDraw which redraws the app. This will result in flickering but it's better than if it isn't redrawing.
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
in with the page background color. Why? I want an image to display per row as a status marker for 3 different types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I want the first column to display an...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
of misplacing our millions due to some possible error we must ensure that both queries are executed with the expected result before committing any changes to the data. This where transactions are useful. We can run the queries, then check if some...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB