Search results for query: *

Good morning, I am trying to add a List of Dates to be used as Parameters in an SSRS 2005 Report. The reason for this is that the Report is quite resource heavy and I only want the end user to use a weeks worth of data only at any one time. I created a dataset (script at end of post) and used...

Hello, I have created a report that has four datasets all looking at the same stored procedure using the StoredProcedure Command type. All are parameterised by a single date. The difference between the four is a static integer parameter that I have manually set in the Parameter tab for each...

Hi, I am trying to find a way of evaluating whether the elements of a given string are either numeric or alpha characters In T/SQL I would simply do the following:- SELECT * FROM Table WHERE UPPER(Field) LIKE('[A-Z][0-9][0-9][0-9][A-Z][A-Z]') Can't seem to find a simple way to replcate this...

Hi, I have writen a function that will return a specific field from a table. I want to be able to re-populate one of the parameters in the function as it executes, depending on what the user has entered as the parameter using the following, but simple cant find where in the function to add the...

Hello, I am a TSQL Developer and am new to PL/SQL and PL/SQL Developer. I would like to know whether it is possible to run two queries at the same time in one window. In SQL Server Query Analyser you could do the following for example:- select top 1 * from table1 go select top 1 * from table2...

Good morning, I have created a formula field that contains an email address and hyperlink and am trying to bolt it on to the end of some text in another formula field, the problem is however that when I do this, the email part loses it's hyperlink capability. The reason I need to do this is...