Search results for query: *

Works Great Dave. I gave you a Star!!

Thanks RiverGuy, Do you have any examples of table variables?

No, this is new code.

I am trying to create a Stored Procedure that the columns can be accessed in SSIS and processed. Here is an example of the code that I am trying to produce: MS SQL 2005 and Visual Studios 2005. CREATE PROCEDURE AIMS_sp_BuildReport04_Barcode_No_Match AS SET NOCOUNT ON CREATE TABLE...

George thanks so much!

Hi All, I would like to produce a field definition list so that I can export it to excel. Does any know how I would do this?

Thanks for the Quick Reply Mufasa, What I am looking for is an example of a working Stored Procedure where they join more than 2 files together and use temp tables. Thanks, Rick

I would like to create a stored procedure that contains the following logic: Create myproc with out parameters TempCPT4F Create tempA1 table Create tempA2 table Create tempB1 table Create tempB2 table Create tempC1 table Create tempC2 table Create TempCPT4F table...

Hi Turkbear thanks for your response. Using Business Objects XI R2 SP4 Business View Manager XI R2 SP4 Crystal Reports XI R2 SP4 Oracle 10g Report is built using Business View Manager. My Problem is I can not pass the UserName to a Stored Procedure because I am using One UserName as my Data...

Hi All, Is it possible to create a custom function that queries an Oracle Table and brings back the results?? I have a Table in the Main (Relationship=1-1) and another Table (Relationship=1-Many) which has nothing to do with my report except I need to know if the userid exists against the...

I think I might have gotten past the syntax problem, but I am not getting any results here is my code. I can see the results for @EvalTechnician but not @EvaluateWhereExists . Any Suggestions????? @EvaluateWhereExists I am using this code as a suppress formula because I can not use it...

Hi All, I need to evaluate the following and I think my syntax is wrong. Please help!! IF ({Q.SAMPLENO} = {Q.MASTERSAMPLENO} OR ISNULL({Q.MASTERSAMPLENO})) OR {Q.ISTIMEWEIGHTED} <> -1) AND {Q.APPROVED} = -1 AND ***** This replaced the Oracle Function ***** (IF...

Hi Ido, I think you are talking about the DataLink Viewer. Can you intergrate the DataLink Viewer with Business Objects XI R2 InfoView? Thx Rick

I know how to use shared values. How can I get the CurrentCEUserName passed from a subreport to the main report and have it populate a UserName parameter on the main report? We are on Crystal Reports XI R2 SP4.8

I know I can create a blank main report and add my detail to a subreport and pass the CurrentCEUserName from the Main Blank Report to the subreport and this will prevent the subreport from prompting a parameter that is referenced in a stored procedure. I would like to know is there anyways to...

When used in a Stored Procedure it is used as wh := ' FROM MV_IHSAMPLE WHERE ' || Function_AthruZ('',''); The Function_AthruZ returns the results as '1 = 0' or '1 = 1' So I could say Select a, b, c From ABCClub Where Function_AthruZ ( 'p_ccn', 'p_type') = '1 = 1' is that right?

It is not working in Where Clause

I want to use a function in the Where clause. I was trying to use it like this Select a, b, c From ABCClub Where (Select Function_AthruZ ( 'p_ccn', 'p_type') as MyResults from dual) Function_AthruZ is the Function I am calling and it has 2 Parameters and it is returning a VarChar2 field...

How would I call a Function within an Oracle View?

Problem Solved What I did was I to the Original Oracle View and added the SurveyProduct to the Select statement as a Left Outer Join and then I added the ProductID to the Select. In Crystal instead of using a detail line I am using a Group on SurveyID so that I get unique SurveyID's. Since...