Forum Replies Created

Viewing 13 posts - 61 through 73 (of 73 total)

  • RE: Cursors

    fetch next from c1 into @db_name,@table_name,@date,@col

    WHILE (@@FETCH_STATUS = 0)

    begin

    set @sql = 'delete from ' +@db_name +'.dbo.'+@table_name+'insert into '+@db_name+'.dbo.'+@table_name+' SELECT distinct top 100* FROM [112.64.104.210,3824].'+@db_name+'.dbo.'+@table_name --+ 'WITH (nolock)'-- WHERE '+@col+@states_contd+@date_dt...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    December 7, 2009 at 12:22 pm

    #1088809

  • RE: A few records in a single row

    Can you post the DDL and DML scripts in readily consumable format...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    December 7, 2009 at 12:19 pm

    #1088806

  • RE: Case Sensitive Obejcts --

    Thanks Lynn..however, I will continue to use CS collation...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    December 4, 2009 at 8:00 am

    #1087750

  • RE: Case Sensitive Obejcts --

    Thanks Lynn...It says CS (Case sensitive), but its grayed out...how do i change that now?

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    December 3, 2009 at 2:25 pm

    #1087385

  • RE: Split the data without loop

    Mohit...The code you gave doesnt work here i believe...

    My direct expected result should be in table as below:

    ID -- value

    1 ...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 25, 2009 at 1:09 pm

    #966220

  • RE: Split the data without loop

    SQL SERVER 2000...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 24, 2009 at 4:21 pm

    #965697

  • RE: Split the data without loop

    Thanks matt..I got the Tally Concept**

    Now for learning Sake....How would you accomplish reverse of this?

    I mean to say..

    If the table looks Like

    ID -- ...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 24, 2009 at 4:04 pm

    #965680

  • RE: Split the data without loop

    Yup..I got what tally table means.Thats Awesome...It rocks...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 24, 2009 at 3:11 pm

    #965644

  • RE: Split the data without loop

    I have a table where in i have all the values concatenated with "-"..now i have to split them into multiple rows to insert into a new table..

    Please let me...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 24, 2009 at 2:11 pm

    #965591

  • RE: Droping temp table

    Thanks a lot sergiy...it works..

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 5, 2009 at 1:56 pm

    #954383

  • RE: join with no mtach

    thanks a lot...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    February 6, 2009 at 3:22 pm

    #939838

  • RE: Extract Image object

    Dear experts..can any one please give direction to this problem?

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    April 8, 2008 at 8:19 am

    #799769

  • RE: Alternate to DTS

    Thanks for the reply Girish. These options looks fine. but linked servers are not permitted to us. do you have any idea on making the excel file as XML string...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 25, 2008 at 11:51 am

    #793673

Viewing 13 posts - 61 through 73 (of 73 total)