Search results for query: *

I have stmtvar to have the selct statement in my procedure. stmtvar= 'select * from A,B,C ....lots of logoc in there.....' I wanted to execute and insert the data to a temp table called DATA. and again I need two more temp tables from Above temp table DATA. One is to contain A specific data...

I created a derived table calling a pipelined funtion and trying to pass multi value prompt value as parameter to the funtion. But it is not letting me to do it... throwing an error 'Right Paranthesis Missing'. param is a single value prompt. param1 and param2 are set to allow multi vlaues. If...

I have a function with a parameter. I need to pass multiple values to single parameter. example parameter value 'A,B,C' in sql it has to be IN ('A','B','C'). Can any one please provide me the solution FUNCTION MTO_ENG104_PIPELINED (str VARCHAR2) RETURN WBS_TAB PIPELINED IS...

I need to place the select statement into a variable. I have some thing like this SELECTSTMT VARCHAR2 (2500) := 'TO_CHAR (Date_Col, 'MM/DD/RRRR'),' +'col_nm1,' +'" DECODE ('col_nm2,''0', 'Active Part',' DECODE (col_nm2,''1', 'Obsolete...

I have a package with pipelined function in it. using the below stmt to execute the function. select * FROM table(Test_PKG.Test_PIPELINED ('A','--N/A--','1/1/2010','1/1/2011')); Throwing an error: invalid month error. Can any one please let me know where I am doing wrong. CREATE TYPE WBS_ROW...

I have a package with a pipelined function with 3 parameters. Based on Val parameter I need to get the table name. for example if user select A then the table name that I should use is p_A, if user selects R the table name should be p_R. I am thinking of creating a variable and set the...

Is it possible to hide prompt in webi Reports. I need to create 5 reports from 1 universe. universe is using a pacakge with a stored procedure. I wanted to pass report name to the stored procedure to differentiate between the report's sql and based on report name parameter I wanted to take...

I need to generate Dynamic SQL for cascading Parameters. Here is the scenario. Parameters: Department ---- Values: A-Department, B-Department Category ---- A1, A2, A3, B1, B2 Product --- A1P1, A1P2, A2P1, B1P1, B2P1, B2P2, B2P3 If user selects A-Department the SQL Should use Dept_A table and...

I need to generate Dynamic SQL Based on Parameter selection. Here is the scenario. Parameters: Department ---- Values: A-Department, B-Department, C-Department If user selects A-Department the SQL Should use Dept_A, Product_A and Sales_A Tables If user selects B-Department the SQL Should use...

I have two tables, lets say Table 1 and Table 2 as below Table 1: Col1 Col2 Col3 1 _A 11 2 _B 12 3 _C 12 4 _A 11 Table 2: ID Val _A A _B B _C C 11 AA 12 BB 13 CC I need an output From Table1 and Table 2 as below 1 A AA 2 B BB 3 C BB 4 A AA I am very new to SQL Server. Can you please...

We have a page with list web part on it. How to open the list item in a new window when we click on list item title (linked to edit menu) instead of popup window. It should happen only on that page. not on the original list. Can any one please provide me the solution? Thank you in advance.

I have a table with the below values ID COL1 COL2 COL3 1 AAA P1 50 2 AAA P1 50 3 AAA P1 50 4 BBB P1 150 5 BBB P1 150 I need output as below with another column 'Sum' as sum of distict values of COL3 grouped by COL1 and COL2, in this case 50+150 ID COL1 COL2 COL3 Sum 1 AAA...

Can we have validations on a custom form in sharepoint 2010?

I have a column called users with value Smith;Alex in listA. (users column is a list box, can have any number of users selected). I need to create two records (based on users caloumn in listA) in listB. one for Smith and one for Alex. (No. of users slected in listA = no. of records/rows to be...

I have crystal report with 2 groups country and State. And it is a drill down report. Can we get the value of country at state level drilldown? Example: lets say we have 2 countries USA and UK For USA, states are CA, IL, TX when we double click on CA/IL/TX.... is there any way we get get USA...

my stored procedure returns a field value of length more than 65 characters. when I have that field on the crystal report... it is returning 50 characters only. Is there any limitaion on the numbers of chars in crystal reports? Can any one please help me in resolving this issue

I have a data set Num RCode Date Code MaxCode 12 'R1' '12/1/2010' 9 10 12 NULL '12/1/2010' 10 10 13 'R8' '12/1/2010' 11 11 13 NULL '12/1/2010' 8 11 14 'S1' '10/1/2010' 11 12 14 'S2' '10/1/2010' 12 12 15 'A1' '5/1/2011' 10 13 15 'A1' '5/1/2011' 10 13 16 'P1' '4/1/2011' 8 13 16 'NULL '4/1/2011' 8...

I have a data set some thing like this Num Code_1 Code_2 1 1230 A12 1 1230 C13 1 1230 B14 2 1230 R115 3 1234 A12 3 1234 A13 4 1124 NULL 5 1234 D1 I need to conacatenete code_2 data in the report group by Num as below. Num Code_1 Code_2 1 1230 A12,C13,B14 2 1230 R115 3 1234 A12,A13 4...

I have a dataset ID Num Type 1 123 C1 2 123 NULL 3 123 A3 4 123 A1 5 123 NULL I need to have previous ID's Type, If maximum ID Type is NULL. That is ID Num Type 1 123 A1 2 123 A1 3 123 A1 4 123 A1 5 123 A1 as output in the report. Can any one please help me. Thank you in advance.

User want to have a sort by paramter selction by a name aor date. I came up with a formula If {?@SortOrder} = 1 Then {Report;1.Applicant} -- String Else CStr({@Date}) @Date is a formula. When user select date, the data is not getting sorted by date properly. Can anyone help me. Thank you...