Thank you very much. It's really helpful.

Hi, it works great for me! Thank you very very much!!!

Hi, I might be avaliable for help after July.

But where are you located?

I am a database programmer, 4 years in oracle/unix platform, 1 years in sqlserver/win2k platform.

Abby

The website is very helpful.

Thank you very much.

Abby

I see, it's the SAME as I posted above ( see the second post for this question). Not sure if this is the most efficient way to resolve this kind...

Hi, Thanks for the reply. The problem is:

when use

IN (1, 2, 3 ), you are using 'OR' logic.

NOT the same purpose for 'intersect'.

It should be an 'AND' logic,...

My current way to do it is using this sql:

select user_id

from my_intersect

where user_id in

(select user_id

from my_intersect

where thing_id = 1

)

and user_id in

(select user_id

from my_intersect

where thing_id = 2

)

and user_id in

(select user_id

from my_intersect

where...

Thank you very much.

Abby

Hi, Thanks all for your help. I am also thinking about using table variable. Guess nothing simple. :=)

Abby

Great! That really works for me!

Thank you very much.

By the way, if table_1, table_2, table_3 and table_4 are temp tables, what's their scope?

In other words, if In my sp, I...

Hi, Thanks. The 'else if' clause resolves my problem. I though SQL Server doesn't have the equivalence for elsif in oracle, since

in my example book, it only has 'if...

Hi, Thanks for the reply. What I really would like to know is

when @mv_dummy = 1,

update table_1

when @mv_dummy = 2

update table_2

when @mv_dummy = 3

do_something_else_like_calling_a_sp,

Table_1 is not the same as table_2.

Can...

Hi, Thanks for your response. I will try it out on either Friday or Sunday, because I am on another short assignment today and tomorrow. I can't have an execution...

Hi, Thanks for translate the decode part. But what I am really looking for is the hash hint part. It is true that without the hash part, the sql would...

Hi, Andy.

Thanks for the reply. Unfortunately, we are not using XML or change any code for the frontend.

The project is a pure translation of oracle packages to sql...