Assuming create is required, the following 218 results were found.
-
recommend seeing if you can't check at the database level first. I will in future. Debug Method Fallback to debug methods; create a textbox that will be visible on the executed report (obviously replace the field name with the name of your field...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
it. Problem #1 If zero rows are returned from the search, then there is no REPORTSTARTTIME. There are two options here: Create another dataset (would have to be the first dataset to load so you would need delete your current datasets then add them in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from webpage Subscriptions cannot be created because the credentials...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
doesn't want to change their desktop background wallpaper? Using Windows 7, who doesn't want it to be a slideshow as well? Create a folder in your “My Pictures” folder in your home drive (check that this is the one on the homedrive and preferably not...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
every day in the range SELECT DATEADD(DAY, 1, [Date]) FROM Dates WHERE Date...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
record activated similarly to the following: SET RECSEP WRAPPED SET RECSEPCHAR "-" Stage #1: Duplicate the table and create a separator marker Granted this will slow the query down a touch and only adds a check column which marks rows (identifying when...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
useful... but the qualification reference has to be unique. We're going to add the ROW_NUMBER() to the employee number to create a unique identifier. Try this: SELECT q.Employee AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS VARCHAR), 3) + RIGHT( '00'...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
a non-alpha letter. The remainder of it is to deal with exceptions to the rule, words that you want in a specific case. CREATE FUNCTION ufn_ProperCase(@Text AS VARCHAR(8000)) RETURNS VARCHAR(8000) AS BEGIN -- declare some variables DECLARE @Reset BIT;...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
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 VARCHAR2, p_original_range_1...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Click on "Environment Variables" Under "System Variables" modify the variable "ORACLE_HOME" (without the quotes). Or create NEW if it doesn't exist. Give it the value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
2 2012-07-23 419 2012/2013 3 2012-07-30... 467 2012/2013 51 2013-07-01 468 2012/2013 52 2013-07-08 I'll use this table to create the calendar. Query #1: Works from command-line but may generate "Empty Query 1065" SELECT calendar.WeekNumber AS...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to your database under the SQL Development section. Export/Import happens under the Server Administration section: Let's create a Server Instance, I'm going to specify the Take Parameters from Existing Database Connection option (note that I have...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
ab c Subexpression You can use the subexpression operator to group characters that you want to find as a string or to create a complex expression. For example, to find the optional string 'abc', followed by 'def', use the following regular expression:...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
to not overlap 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...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window with no glass) and for all the flashy stuff, to only appear within the...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
query Display the value of column1 and CountOrder The old code would have been: echo '# | Search Term | Count' . "\n"; # create an array of search terms with their frequency count $search_table_results=mysql_query("SELECT DISTINCT column1 FROM table1");...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *