Forum Replies Created

Viewing 15 posts - 106 through 120 (of 326 total)

  • RE: How to update on condition based?

    Jason-299789 (2/7/2013)

    I know the one you're talking about GSquared, Gail made a lot of very interesting points and I think Paul also added a few comments about inplace updates.

    The...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 7, 2013 at 4:10 am

    #1585320

  • RE: How to update on condition based?

    No worries. I can't find the thread, but Paul White did an excellent job of writing it up on his blog.

    thanks again ; will read that out ..

    And coming...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 7, 2013 at 3:40 am

    #1585303

  • RE: How to update on condition based?

    ChrisM@Work (2/7/2013)

    demonfox (2/7/2013)

    ...updating column1 to column1; definitely not a good idea...

    There was a thread covering exactly this, fairly recently. I'll try to track it down. IIRC the conclusion (for most...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 7, 2013 at 2:57 am

    #1585288

  • RE: Is it possible to use a case statement inside a cursor?

    HildaJ (2/6/2013)

    I'm very new to TSQL so my apologies for my lack of experience. Really working on it : ) So instead of using a cursor what would...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 7, 2013 at 1:41 am

    #1585253

  • RE: error while casting a column name

    ALI100 (2/6/2013)

    SetFormattedValue =CASE

    When rg.ReferredFieldType='NUM'

    Then CAST(#PointedMslValues.Value AS NUMERIC(18,cAST(rg.ReferredDecimalPoints) )

    more cases .

    END

    I am generating a dynamic query which is giving error actually it...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 7, 2013 at 1:19 am

    #1585235

  • RE: I need a plan to cleans all the tables in a database for every 9 months.

    vinu512 (2/6/2013)

    m.rajesh.uk (2/6/2013)

    cleans all the tables in a database

    What do you mean by cleaning tables??

    Yes , An edit regarding this ;

    For staging tables cleaning , one job should do the...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 7, 2013 at 1:06 am

    #1585228

  • RE: I need a plan to cleans all the tables in a database for every 9 months.

    m.rajesh.uk (2/6/2013)

    I need a plan to cleans all the tables in a database for every 9 months.

    what are the best ways to do that.This time period can be...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 7, 2013 at 1:01 am

    #1585224

  • RE: How to update on condition based?

    purushottam2 (2/6/2013)

    I want to update data on condition based, if condition met then only update else left it.

    I was using CASE statement but i realized in CASE there is no...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 7, 2013 at 12:51 am

    #1585220

  • RE: Updating Views

    Lokesh Vij (2/6/2013)

    Nice question Steve!

    +1

    Thanks for the question.......

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 7, 2013 at 12:36 am

    #1585216

  • RE: How to use table valued function as part of select statement in sql server

    purushottam2 (2/5/2013)

    Id columns i have just given for reference, in my case TVF will always return 1 row but in table may have multiple id. So i think it...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 5, 2013 at 1:32 am

    #1584216

  • RE: Trigger to insert into a new table from a deleted row.

    Pablo Campanini-336244 (2/4/2013)

    Hello

    1.- What would be the code to insert some columns from a deleted record into a different table.

    2.- Can I update a field on a table when an...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 5, 2013 at 1:29 am

    #1584213

  • RE: how to find result for this table

    vanapandi (2/5/2013)

    thank you sir,,,i got result...i want to improve my knowledge in sql server..can you suggest me..

    i am also finally got result by using sub query...whether it is wrong way

    ...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 5, 2013 at 1:17 am

    #1584208

  • RE: SQL Function takes more than 2 hours to return a table..

    Jason-299789 (2/5/2013)

    I'm not suprised it took a couple of hours looking at the query you have loops with cursors which is going to drag performance down into the basement and...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 5, 2013 at 1:08 am

    #1584201

  • RE: how to find result for this table

    Lokesh Vij (2/4/2013)

    Here you go:

    CREATE TABLE Payment

    (

    PaymentHistoryID INT,

    paymentID INT,

    ...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 4, 2013 at 11:16 pm

    #1584179

  • RE: how to find result for this table

    Please provide the ddl ..

    follow this link for best practices to post :

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    February 4, 2013 at 10:41 pm

    #1584175

Viewing 15 posts - 106 through 120 (of 326 total)