Forum Replies Created

Viewing 15 posts - 1,066 through 1,080 (of 1,957 total)

  • RE: Need to export excel sheet with SPECIAL formats

    opc.three (1/10/2013)

    Nice offering MM. The technique is one I have seen outlined before but not necessarily applied to SSIS. While no one step is difficult there are quite a few...

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

January 10, 2013 at 6:06 am

#1575736

  • RE: Report column values which should open more than one pop up

    v-swgar (1/7/2013)

    Thanks so much for the reply mister.

    but this does not seem to work with part of text in the column which would be the hyperlink text?

    Can you please...

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

    January 10, 2013 at 2:41 am

    #1575666

  • RE: Need to export excel sheet with SPECIAL formats

    Phil Parkin (1/10/2013)

    Wow - you've done this before? Nice.

    Not in SSIS, but I have manually - just to learn how to - no reason not to do it in SSIS...

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

    January 10, 2013 at 2:39 am

    #1575663

  • RE: Need to export excel sheet with SPECIAL formats

    If you are using xlsx files, there is a way that is not too difficult if you are methodical...

    • Create your template file with formatting and some sample data.

    • Use your favourite...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      January 9, 2013 at 5:37 pm

      #1575514

    • RE: Decimal separator missed when pasting into excel from sql query

      or you might be able to set up a local / domain user with spanish region settings and just run SSMS as that user using the "runas" command...

      not nice, but...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      January 9, 2013 at 11:39 am

      #1575366

    • RE: Merge issue

      mister.magoo (1/8/2013)

      so you want to INSERT into "some_other_table" where "value" and "rn" don't EXIST in #tgt

      and UPDATE #tgt WHERE value and rn match to #src ?

      Is that right? 😉

      Sorry, I...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      January 8, 2013 at 11:44 am

      #1574961

    • RE: Merge issue

      so you want to INSERT into "some_other_table" where "value" and "rn" don't EXIST in #tgt

      and UPDATE #tgt WHERE value and rn match to #src ?

      Is that right? 😉

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      January 8, 2013 at 10:02 am

      #1574918

    • RE: Report column values which should open more than one pop up

      go to the Action section again and select "Go to URL"

      Enter an expression for the url to get an alert window:

      = "alert(""" & Field!Description.Value & """);"

      Of course, you should URL...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      January 7, 2013 at 4:40 pm

      #1574565

    • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

      Steven Willis (12/28/2012)

      Here's Mr. Magoo's method for splitting element pairs:

      Gosh, I hope that was a mistake?

      That code was not the best version of the XML split for that problem by...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      December 29, 2012 at 2:33 pm

      #1572357

    • RE: Unwanted parameter truncation

      Hi, I think you have missed a very simple suggestion from Jeff, which was to check the length in the stored procedure you are calling.

      If you are expecting anything up...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      December 23, 2012 at 6:05 pm

      #1571206

    • RE: Split input string into multicolumn - multirows

      Jeff Moden (12/21/2012)

      Steven Willis (12/21/2012)

      First test used the same data as generated in a post above using a Tally table CTE. I generated test data with 100 rows, 1,000 rows,...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      December 22, 2012 at 1:29 am

      #1571126

    • RE: Split input string into multicolumn - multirows

      Jeff Moden (12/19/2012)

      I'm getting some conflicting results on the performance testing. A 10 year old single cpu desktop computer and a laptop probably aren't the best places for me...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      December 20, 2012 at 1:34 am

      #1570440

    • RE: Split input string into multicolumn - multirows

      And the nice thing is this method works nicely on varchar(MAX)...

      I used 2000 rows of 2000 pairs of values to test :

      Duration_AvgCpu_AvgReads_AvgWrites_AvgRowCounts_Avg

      106994.000000985614196918 36806...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      December 19, 2012 at 7:52 pm

      #1570369

    • RE: Split input string into multicolumn - multirows

      Dwain,

      Performance wise, the main "speed ups" in this version are the use of our old friend FOR XML PATH('') to bolt everything into one XML fragment (means only handling one...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      December 19, 2012 at 7:28 pm

      #1570366

    • RE: Split input string into multicolumn - multirows

      dwain.c (12/19/2012)

      "Oh, Magoo! You've done it again!"

      Maybe 😉 I am just testing other data patterns...

      MM


      select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

    • Forum Etiquette: How to post Reporting Services problems
      • [/url]
    • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
      • [/url]
    • How to Post Performance Problems - by Gail Shaw
      • [/url]

      December 19, 2012 at 7:13 pm

      #1570363

      Viewing 15 posts - 1,066 through 1,080 (of 1,957 total)