Click here to Skip to main content
14,974,357 members
Home / Discussions / Database
   

Database

 
GeneralRe: Cannot start MSSQLSERVER Pin
jschell18-Aug-11 12:56
Memberjschell18-Aug-11 12:56 
AnswerRe: Cannot start MSSQLSERVER Pin
Corporal Agarn18-Aug-11 2:02
professionalCorporal Agarn18-Aug-11 2:02 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 3:59
professionalBlikkies18-Aug-11 3:59 
AnswerRe: Cannot start MSSQLSERVER Pin
Wendelius18-Aug-11 6:26
mveWendelius18-Aug-11 6:26 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 21:38
professionalBlikkies18-Aug-11 21:38 
QuestionOracle Collection Objects Pin
lionelcyril17-Aug-11 21:22
Memberlionelcyril17-Aug-11 21:22 
AnswerRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:10
mveWendelius18-Aug-11 8:10 
GeneralRe: Oracle Collection Objects Pin
lionelcyril18-Aug-11 8:21
Memberlionelcyril18-Aug-11 8:21 
Hi,
I am using a SSRS report and the report is generated by executing a stored procedure.

The procedure gets 4 input values a,b,c,d where values c and d is a string containing multiple values.
I am executing a complex SQL statement.
For this i am using nested loop:

A as INPUT
B as INPUT
C as INPUT (String input seperated by ,)
D as input (String input seperated by ,)

Cursor Cur as OUTPUT

Loop for c
Loop for d
.
.
execute the above SQL Statement(select query)
.
.
END loop
END Loop

problem:
Now the results of the SQL statement has to be saved temporarily somewhere I am not allowed to use permanent/temporary tables as they require definition at schema level and modificaton of schema is not allowed.
I need to save the value in the cursor at each runs, but in that case the previous results get overwritten.
So i wanted to know collection objects and wanted to know if that too requires definition at schema level.
AnswerRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:32
mveWendelius18-Aug-11 8:32 
GeneralRe: Oracle Collection Objects Pin
lionelcyril18-Aug-11 8:37
Memberlionelcyril18-Aug-11 8:37 
GeneralRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:56
mveWendelius18-Aug-11 8:56 
QuestionMax. number of concurrent user in PostGre database Pin
Navin Pandit17-Aug-11 18:55
MemberNavin Pandit17-Aug-11 18:55 
AnswerRe: Max. number of concurrent user in PostGre database Pin
Wendelius17-Aug-11 19:00
mveWendelius17-Aug-11 19:00 
GeneralRe: Max. number of concurrent user in PostGre database Pin
Navin Pandit17-Aug-11 19:10
MemberNavin Pandit17-Aug-11 19:10 
GeneralRe: Max. number of concurrent user in PostGre database Pin
Wendelius17-Aug-11 19:35
mveWendelius17-Aug-11 19:35 
GeneralRe: Max. number of concurrent user in PostGre database Pin
jschell18-Aug-11 13:02
Memberjschell18-Aug-11 13:02 
GeneralRe: Max. number of concurrent user in PostGre database Pin
Navin Pandit18-Aug-11 18:33
MemberNavin Pandit18-Aug-11 18:33 
GeneralRe: Max. number of concurrent user in PostGre database Pin
jschell19-Aug-11 7:34
Memberjschell19-Aug-11 7:34 
QuestionSearching with optional parameters [modified] Pin
Pascal Ganaye16-Aug-11 1:36
MemberPascal Ganaye16-Aug-11 1:36 
AnswerRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 3:23
professionalPIEBALDconsult16-Aug-11 3:23 
GeneralRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 4:16
MemberPascal Ganaye16-Aug-11 4:16 
AnswerRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 4:21
MemberPascal Ganaye16-Aug-11 4:21 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 17:56
professionalPIEBALDconsult16-Aug-11 17:56 
GeneralRe: Searching with optional parameters Pin
Mycroft Holmes16-Aug-11 18:06
professionalMycroft Holmes16-Aug-11 18:06 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult17-Aug-11 2:48
professionalPIEBALDconsult17-Aug-11 2:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.