Forum Replies Created

Viewing 15 posts - 346 through 360 (of 544 total)

  • RE: which is faster? SSIS or SQL?

    SQLKnowItAll (3/21/2012)

    Charmer (3/21/2012)

    Hi friends,

    i try to run some T-SQL statements in ssms like insert and update left outer join with 5 tables...due to large records it takes too much time..

    so...

    March 22, 2012 at 9:51 am

    #1462844

  • RE: which is faster? SSIS or SQL?

    Hi To all,

    What i am exactly doing is just inserting and updating records left join with 4 to 6 tables.....

    i even created indexes for the columns which ever i am...

    March 22, 2012 at 3:15 am

    #1462570

  • RE: which is faster? SSIS or SQL?

    Thanks guys...

    March 21, 2012 at 10:41 am

    #1462290

  • RE: SSIS Insert Else Update

    Ted Zatopek (2/6/2012)

    Does anyone know if there's a new way to handle insert-else-update in an SSIS package in 2012?

    We've started a deep eval of 2012 features for use in a...

    March 21, 2012 at 4:49 am

    #1462078

  • RE: How to maintain two digit values in sp?

    Eugene Elutin (3/16/2012)

    You don't need to change anything.

    It's not producing just 2-digit numbers

    if you supply 0, the next value generated will be 1, one digit of Base36 will hold any...

    March 16, 2012 at 10:06 am

    #1460609

  • RE: How to maintain two digit values in sp?

    Eugene Elutin (3/16/2012)

    Looks like you didn't look what -base encoding is. As you don't care of order in which values are incrementing, that is definitely would work for you.

    As promised...

    March 16, 2012 at 9:56 am

    #1460602

  • RE: How to maintain two digit values in sp?

    Jeff Moden (3/15/2012)

    Charmer (3/15/2012)

    SQLKnowItAll (3/15/2012)

    Can you create a tally table with these values (if maximum is 2000, I would create 3000 just in case)?

    sorry friend,What is a tally table? i...

    March 16, 2012 at 3:34 am

    #1460381

  • RE: How to maintain two digit values in sp?

    Jeff Moden (3/15/2012)

    Charmer (3/15/2012)

    SQLKnowItAll (3/15/2012)

    Can you create a tally table with these values (if maximum is 2000, I would create 3000 just in case)?

    sorry friend,What is a tally table? i...

    March 16, 2012 at 2:59 am

    #1460371

  • RE: How to maintain two digit values in sp?

    Jeff Moden (3/15/2012)

    Charmer (3/15/2012)

    here i have a parameter of variable @MaxLength where i pass the value like 2 or 3 or 4 and depends upon the need.

    You give an example...

    March 16, 2012 at 2:56 am

    #1460369

  • RE: How to maintain two digit values in sp?

    SQLKnowItAll (3/15/2012)

    Can you create a tally table with these values (if maximum is 2000, I would create 3000 just in case)?

    sorry friend,What is a tally table? i don't have much...

    March 15, 2012 at 11:05 am

    #1460030

  • RE: How to maintain two digit values in sp?

    SQLKnowItAll (3/15/2012)

    The first problem is that @DecNumber is a BIGINT. You cannot store characters in BIGINT. First you need to change this to CHAR(2) or something that applies....

    March 15, 2012 at 10:57 am

    #1460020

  • RE: finding duplicate records?

    pallavi.unde (3/13/2012)

    Use Rownumber() it will create a virtual column of separate id for each row.. then by using that id you can update any duplicate record.

    and its bad practice if...

    March 15, 2012 at 5:51 am

    #1459754

  • RE: finding duplicate records?

    Koen Verbeeck (3/15/2012)

    You mean the attachments here at SQLServerCentral?

    When you create a new post, you have a button Edit Attachments in the Post Options a bit down.

    yes i got it....i...

    March 15, 2012 at 5:48 am

    #1459752

  • RE: finding duplicate records?

    Koen Verbeeck (3/15/2012)

    Charmer (3/15/2012)

    Friends,

    Some one temme how to add files over here...?

    Add files where? Your email attachment?

    Yes Koen

    March 15, 2012 at 5:09 am

    #1459735

  • RE: finding duplicate records?

    Friends,

    Some one temme how to add files over here...?

    March 15, 2012 at 4:00 am

    #1459710

Viewing 15 posts - 346 through 360 (of 544 total)