Click here to Skip to main content
15,918,109 members
Home / Discussions / Database
   

Database

 
AnswerRe: HELP !! Pin
Eddy Vluggen10-Aug-11 11:04
professionalEddy Vluggen10-Aug-11 11:04 
QuestionLoop in a Stored procedure Pin
lionelcyril9-Aug-11 20:50
lionelcyril9-Aug-11 20:50 
AnswerRe: Loop in a Stored procedure Pin
Shameel9-Aug-11 22:20
professionalShameel9-Aug-11 22:20 
GeneralRe: Loop in a Stored procedure Pin
lionelcyril10-Aug-11 0:40
lionelcyril10-Aug-11 0:40 
GeneralRe: Loop in a Stored procedure Pin
Shameel10-Aug-11 8:42
professionalShameel10-Aug-11 8:42 
GeneralRe: Loop in a Stored procedure Pin
lionelcyril10-Aug-11 8:46
lionelcyril10-Aug-11 8:46 
GeneralRe: Loop in a Stored procedure Pin
S Douglas20-Aug-11 9:20
professionalS Douglas20-Aug-11 9:20 
AnswerRe: Loop in a Stored procedure Pin
jschell10-Aug-11 10:07
jschell10-Aug-11 10:07 
I doubt it is going to be efficient to try to incrementally retrieve values from Oracle and use them in sql server.

So you have two steps.
1. Retreive the data from Oracle, all of it, and put it into a suitable data structure.
2. Use it in SSRS.

First step would probably be generally achieved by
A. Create appropriate temp table(s)
B. Populate table(s) from Oracle.

The design of the temp tables depends specifically on business information based on the what you are doing in SSRS and how that relates to the data in Oracle. So if you cannot determine the structure of the tables yourself you are going to need to explain the problem in detail or provide a sample that has been reduced from those requirements.

Keep in mind that you do NOT attempt step 2 until you have completed step 1.
QuestionInner Query in mysql Pin
Rakesh Meel8-Aug-11 0:56
professionalRakesh Meel8-Aug-11 0:56 
AnswerRe: Inner Query in mysql Pin
Simon Bang Terkildsen8-Aug-11 1:53
Simon Bang Terkildsen8-Aug-11 1:53 
AnswerRe: Inner Query in mysql Pin
Simon_Whale8-Aug-11 2:49
Simon_Whale8-Aug-11 2:49 
AnswerRe: Inner Query in mysql Pin
DaveAuld8-Aug-11 12:44
professionalDaveAuld8-Aug-11 12:44 
GeneralRe: Inner Query in mysql Pin
Rakesh Meel8-Aug-11 19:38
professionalRakesh Meel8-Aug-11 19:38 
GeneralRe: Inner Query in mysql Pin
GuyThiebaut13-Aug-11 1:35
professionalGuyThiebaut13-Aug-11 1:35 
GeneralRe: Inner Query in mysql Pin
Rakesh Meel15-Aug-11 19:00
professionalRakesh Meel15-Aug-11 19:00 
Questionargument data type ntext is invalid for argument 1 of rtrim function Pin
md_refay7-Aug-11 22:09
md_refay7-Aug-11 22:09 
AnswerRe: argument data type ntext is invalid for argument 1 of rtrim function [modified] Pin
Shameel8-Aug-11 5:35
professionalShameel8-Aug-11 5:35 
QuestionDB2: Create primary key on partition table? Pin
cuong-nm7-Aug-11 21:02
cuong-nm7-Aug-11 21:02 
AnswerRe: DB2: Create primary key on partition table? Pin
Herman<T>.Instance9-Aug-11 2:29
Herman<T>.Instance9-Aug-11 2:29 
GeneralRe: DB2: Create primary key on partition table? Pin
cuong-nm9-Aug-11 16:30
cuong-nm9-Aug-11 16:30 
AnswerRe: DB2: Create primary key on partition table? Pin
Wendelius12-Aug-11 7:01
mentorWendelius12-Aug-11 7:01 
GeneralRe: DB2: Create primary key on partition table? Pin
cuong-nm14-Aug-11 17:19
cuong-nm14-Aug-11 17:19 
QuestionCube processing confirmation? Pin
current19996-Aug-11 1:01
current19996-Aug-11 1:01 
AnswerRe: Cube processing confirmation? Pin
Mycroft Holmes6-Aug-11 2:52
professionalMycroft Holmes6-Aug-11 2:52 
AnswerRe: Cube processing confirmation? Pin
S Douglas11-Aug-11 9:20
professionalS Douglas11-Aug-11 9:20 

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.