If I take an example. Perhaps the easiest way to combine different statements would be to use union. For example if you have following logic (pseudo):
select@result = count(*) fromtablewhere column1 < 100if@result > 10then color = blue
elseselect@result = count(*) fromtablewhere column1 > 100if@result = 20then color = yellow
Now you could combine these to something like:
cursor = select count(*) fromtablewhere column1 < 100unionallselect count(*) fromtablewhere column1 > 100if first_row_in_cursor > 10then color = blue
elseif second_row_in_cursor = 20then color = yellow
However, as you see, both select statements would get the count from different rows. In example 1 the second query isn't executed at all if count > 10. In the second example all the selects are executed even if the results in different portions aren't needed. This can be very time (and resource) consuming.
This was a trivial case and most likely isn't exactly the same as in your situation but the point I'm trying to make is that is it really beneficial to combine all the statements. Another point of view is that the statement may become very large and hard to maintain if it contains too much logic.
Another (perhaps an easy ) option is to use scalar queries. This might work more easily for your case. The previous example could be something like:
select@result1 = (select count(*) fromtablewhere column1 < 100)
@ersult2 = (select count(*) fromtablewhere column1 > 100);
if@result1 > 10then color = blue
elseif@result2 = 20then color = yellow
However the same performance problem as described earlier may arise.
Select * from Table1 Where (ISNULL(A1,'')=ISNULL(B1,'') and ISNULL(B1,'')=ISNULL(C1,'')) And (ISNULL(A2,'')=ISNULL(B2,'') and ISNULL(B2,'')=ISNULL(C2,'')) And (ISNULL(A3,'')=ISNULL(B3,'') and ISNULL(B3,'')=ISNULL(C3,''))
I hope that copy/paste worked
Never underestimate the power of human stupidity
Select * from Table1 Where (ISNULL(A1,0)=ISNULL(B1,0) and ISNULL(B1,0)=ISNULL(C1,0)) And (ISNULL(A2,0)=ISNULL(B2,0) and ISNULL(B2,0)=ISNULL(C2,0)) And (ISNULL(A3,0)=ISNULL(B3,0) and ISNULL(B3,0)=ISNULL(C3,0))
Use isnull with all the column fields. If the value is null it will take it as zero else it will take the coressponding values.
Does anyone know where i may be able to find / download a English to Afrikaans OR Afrikaans to English Database ??? I need it for a project i am doing, i do not want one that connects online or a translator, i want an actual database with the words and translations.
First of all, don't start a topic with some generic topic like "help". I had to click on it and read it to determine it's contents - something I don't do when there's not much time. People could have an easy answer and skip your question, simply because the topic doesn't provide any clue. Most people posting questions here on the boards are looking for help in one way or the other.
On to your problem; there are some free dictionaries here[^], but I never seen them and can't say much about them.
Ergane[^] has it's dictionaries available as a separate download.
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:
A as INPUT
B as INPUT
C as INPUT
D as input
Cursor Cur asOUTPUT
Loop for c
Loop for d
execute the SQL Statement(selectEND loop
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.
Sorry I didnt mention earlier..
I am writing the stored procedure in oracle.
I wanted to know if I can use a array and the store the results in the reference cursor which can be pulled by SSRS. but i dont know how to pass the values form array to reference
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.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch