Professional Web Applications Themes

strange (newbie?) problem - Microsoft SQL / MS SQL Server

I have created a simple package in SQL Server 2000 that tries to exec a stored procedure that uses a temp table. The proc does not run. I then created a permanent table, which works perfectly. I am originally from the Sybase world, if you can't tell, and wondered how one gets around this behavior. I am going to try table variables next; but if that is the only way to do this, it seems limiting. TIA - Regards, jh...

  1. #1

    Default strange (newbie?) problem

    I have created a simple package in SQL Server 2000 that tries to exec
    a stored procedure that uses a temp table. The proc does not run. I
    then created a permanent table, which works perfectly. I am
    originally from the Sybase world, if you can't tell, and wondered how
    one gets around this behavior. I am going to try table variables
    next; but if that is the only way to do this, it seems limiting.

    TIA -

    Regards,
    jh
    Jared Guest

  2. #2

    Default Re: strange (newbie?) problem

    Jared,

    Can we see the stored procedure code?

    Thanks!
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "Jared" <com> wrote in message
    news:google.com... 


    Dinesh.T.K Guest

  3. #3

    Default Re: strange (newbie?) problem

    CREATE procedure usp_workdammit
    OnDate datetime = null
    as
    Begin
    if OnDate is null
    -- declare OnDate datetime
    select OnDate = getdate()


    create table #temp3
    ([LoanID] [int] NOT NULL ,
    [CLTVRangeID] [int] NULL ,
    [CustID] [int] NULL ,
    [DocTypeCode] [int] NULL ,

    etc.

    insert #temp3
    select distinct
    L.LoanID ,
    CLTVRangeID = (select isnull(CLTVRangeID,0)
    from CLTVRange
    where LA2.CLTV >=CLTVMinVal
    and LA2.CLTV <=CLTVMaxVal) ,
    Us.CustID ,

    etc.


    update loanfact
    set LoanID = t.LoanID ,
    CLTVRangeID = t.CLTVRangeID ,
    CustID = t.CustID

    etc.


    What happens is that when I run it as a stored procedure, it works.
    When I try to incorporate the stored procedure in a package, it
    objects. That's wy I thought table variables were the way to go, I
    just didn't have time to get the syntax.
    Jared Guest

Similar Threads

  1. Strange Problem with XML
    By kandy71@gmail.com in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: December 3rd, 01:03 AM
  2. Very Strange Problem
    By Porly@adobeforums.com in forum Adobe Illustrator Windows
    Replies: 5
    Last Post: June 15th, 04:13 PM
  3. A very strange problem
    By Dino in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 21st, 01:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139