Assuming examples is required, the following 33 results were found.
-
Ok it needs a lot more work in terms of design but the functionality is there. Adding Events Again I've put two rooms as examples in the above script. The "Events" table needs as a minimum the 4 fields "Room", "EventStart", "EventFinish", and "Status"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008 R2. The following examples assume today's date is Wednesday 03 August 2011 @ 11:46: This Week: -- Start Date (US format - mm/dd/yyyy) =DateAdd("d",...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using Business Intelligence Development Studio v2008...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
just need a table returned with the "EventDate" and the "Note" variables from the other database. If I use the hard-coded examples above, I would want a results table similar to the following: EventDate Note...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
it's of some use. If it's wrong then just post a comment at the bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
function. ** ** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** ** Usage Examples: ** ** EXEC usp_ScrambleMultivalue 'dbo.TableA', 'ColumnNameA'; ** ** ** ** EXEC usp_ScrambleMultivalue 'dbo.TableA',...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example todays,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
$sum_hours = number_format(((strtotime($this_time_from_sql)-strtotime($this_time_from_sql))/60)/60, 2); // Using the examples above this is doing the following: 2011-03-04 12:00:00 - 2011-03-04 10:00:00 = 2.00 2011-03-08 00:30:00 - 2011-03-08 23:30:00 =...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
this value into an array separated by the delimiter character "" -- join this array back replacing any spaces with nothing Examples: -- If field is "Joes Just Joking!" yields "JoesJustJoking!" -- If field is " Space is a big place " yields...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if they do not: Surround string (apostrophes) with red styling Convert: this='a...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
vague. I thought I'd quickly write this article so I don't have to spend so much time on it again. Note that the below examples, demonstrate a script on a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some reason, I couldn't get...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime = v_CreatorTime.toString("yyyy-MM-dd'T'HH:mm:ss") +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *