Post reply

T-SQL

  • October 15, 2013 at 12:46 pm

    #1658661

    It looks a lot like you are protecting some code from public view, but getting it wrong?

    Originally, your parameter @ID was an int, now it seems to be a varchar...

    How about you just change it to print the variables @TaskOutFile and @sqlquery so you can see what is in them, then correct it?

    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]

  • October 15, 2013 at 7:23 pm

    #1658771

    I got the code working properly.

  • October 16, 2013 at 12:09 am

    #1658794

    Glad you got it working. You should still look at rewriting your process without using the Web Assistant tasks as those procedures are deprecated and your current process will not upgrade to future versions of SQL Server.

  • October 16, 2013 at 11:22 am

    #1659018

    Yes,I do plan to get it done using SSIS and SSRS.

  • October 16, 2013 at 12:34 pm

    #1659035

    sqlserver12345 (10/16/2013)

    Yes,I do plan to get it done using SSIS and SSRS.

    Great. If you have any question on those technologies, don't hesitate to ask.

    (I'll answer the SSIS ones :-D)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

    • Viewing 5 posts - 16 through 19 (of 19 total)

    You must be logged in to reply to this topic. Login to reply