Click here to Skip to main content
15,920,602 members
Home / Discussions / Database
   

Database

 
QuestionSee this Pin
sivakumat11-Aug-11 1:20
sivakumat11-Aug-11 1:20 
QuestionCompare 3columns from a row with data Null value Pin
Naunt10-Aug-11 23:16
Naunt10-Aug-11 23:16 
AnswerRe: Compare 3columns from a row with data Null value Pin
Mycroft Holmes10-Aug-11 23:26
professionalMycroft Holmes10-Aug-11 23:26 
AnswerRe: Compare 3columns from a row with data Null value Pin
sujit076110-Aug-11 23:55
sujit076110-Aug-11 23:55 
GeneralRe: Compare 3columns from a row with data Null value Pin
Naunt11-Aug-11 0:18
Naunt11-Aug-11 0:18 
QuestionHELP !! Pin
Josh7harington10-Aug-11 5:14
Josh7harington10-Aug-11 5:14 
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 
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 all values of c and d.
For this reason i am using nested loop:
SQL
A as INPUT
B as INPUT
C as INPUT
D as input
Cursor Cur as OUTPUT

	Loop for c
		Loop for d
			execute the SQL Statement(select 
		END loop
	END Loop

problem:
Now the results of the SQL statement has to be saved temporarily somewhere I am not allowed use permanent tables and I m struglling using temporary tables.
If i save the value in the cursor each time the loop runs the previous results get overwritten.

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 
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 

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.