Forum Replies Created

Viewing 15 posts - 856 through 870 (of 2,894 total)

  • RE: string with int

    CELKO (11/25/2012)

    ...

    CAST(@abc AS VARCHAR(10)) should work and it much preferred over the old 1970's Sybase CONVERT string function...

    CAST and CONVERT are similar but not the same. CAST in T-SQL...

    November 26, 2012 at 3:18 am

    #1562117

  • RE: Update statement question

    CELKO (11/23/2012)

    Here we go again. Dear J.C. you do need to calm down.

    "!=" has nothing to do with 1970's Sybase and/or UNIX. Yes it was used old times, but...

    November 24, 2012 at 12:47 pm

    #1561991

  • RE: Update statement question

    Jason-299789 (11/23/2012)

    Bhuvnesh (11/22/2012)

    what other alternative we can take here instead of "!= "

    You can use "<>" which is another notation for not equal, which is what Joe is suggestion everyone...

    November 23, 2012 at 3:11 am

    #1561801

  • RE: Which is best Inner join or Left outer join

    David McKinney (11/22/2012)

    I agree with the poster in this example. A left join in the other direction might make some sense, but B lj A makes no sense given...

    November 22, 2012 at 9:58 am

    #1561675

  • RE: Which is best Inner join or Left outer join

    thava (11/22/2012)

    ...

    hi "Eugene Elutin"

    Thanks for your response

    i know very well about joins

    please read my scenario and give an opinion about this

    Hi Thava,

    I have read your...

    November 22, 2012 at 9:46 am

    #1561673

  • RE: Optimization of stored procedures

    CELKO (11/22/2012)

    Will optimizing the stored procedures improve the performance of the database while running reports.

    Can you be more vague? 🙂

    I can! My vague-king question is here:

    How?

    November 22, 2012 at 8:00 am

    #1561649

  • RE: Update statement question

    CELKO (11/22/2012)

    I'm doing a DB review and have always been taught to write updates with a JOIN like using this syntax.

    UPDATE Target

    SET col_list = S.col_list

    FROM Table1 AS Target

    ...

    November 22, 2012 at 7:55 am

    #1561647

  • RE: Which is best Inner join or Left outer join

    What is better "green" or "blue" colour?

    Please read and try to understand what different JOIN types do, Then you will be able to answer your question what is "better" INNER...

    November 22, 2012 at 7:27 am

    #1561634

  • RE: Name query resultls by different column names

    CELKO (11/22/2012)

    ...

    “No matter how far you have gone down the wrong road, turn around.” -- Turkish Proverb.

    It is so true!

    But, why don't you follow it yourself?

    😉

    November 22, 2012 at 6:57 am

    #1561621

  • RE: Performance issue while fetching 20000000 records

    ...if i used views or temp table

    ...

    From you have said, you already using temp tables.

    Without looking into real code, it's impossible to suggest anything specific.

    Try using views and...

    November 22, 2012 at 6:52 am

    #1561620

  • RE: Performance issue while fetching 20000000 records

    priti 19979 (11/22/2012)

    I have some 20000000 rows in my database. While fetching records on some criteria it take too much time. I created all possible indexing also but still it...

    November 22, 2012 at 5:29 am

    #1561602

  • RE: Parameterized dynamic SQL

    D.Post (11/22/2012)

    Ok, so we have to use dynamic queries for object names.

    Make sure to check the object against the sys views.

    DECLARE

    @DBName NVarchar(50)

    SET @DBName = 'Master1'

    IF NOT EXISTS (SELECT *...

    November 22, 2012 at 5:21 am

    #1561600

  • RE: multiple columns to single column (normalization)

    what about this:

    select id, a.PartId

    from #cars

    cross apply (VALUES (1*[part1]), (2*[part2]), (3*[part3])) a(PartId)

    where a.PartId > 0

    November 22, 2012 at 4:51 am

    #1561594

  • RE: Create A stored proc template that checks if exists then Alter otherwise create

    Sean Lange (11/21/2012)

    .... As you have likely discovered you can't quite do what your template is doing. ddl statements have to run in a batch. In order to do this...

    November 22, 2012 at 2:44 am

    #1561545

  • RE: switching address with Subtring & len funtion

    karthik M (11/21/2012)

    ...

    ...If so, why should i learn CLR?

    ...

    No, you shouldn't. It's purely up to you what you would like to learn.

    For example, I used to work in team...

    November 22, 2012 at 2:27 am

    #1561538

Viewing 15 posts - 856 through 870 (of 2,894 total)