Forum Replies Created

Viewing 15 posts - 1 through 15 (of 36 total)

  • RE: isnull / coalesce

    Thank you very much. It's really helpful.

  • RE: bcp message

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

  • RE: need help with site

    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

  • RE: rowtype in sqlserver

    The website is very helpful.

    Thank you very much.

    Abby

  • RE: how to use intersect in sqlserver2000

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

  • RE: how to use intersect in sqlserver2000

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

  • RE: how to use intersect in sqlserver2000

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

  • RE: format a string in sql server

    Thank you very much.

    Abby

  • RE: passing in a varchar

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

    Abby

  • RE: how to piece multiple tables into one table

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

  • RE: case statement in sql server

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

  • RE: case statement in sql server

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

  • RE: How to use hint in sql server

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

  • RE: How to use hint in sql server

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

  • RE: how to create text variable

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

Viewing 15 posts - 1 through 15 (of 36 total)