[sqr-users] RE: Temp Table Error

["Sam McBride" <Sam.McBride@radioshack.com>]

Thanks Donald, your solution worked.

Message: 6
Date: Tue, 17 Oct 2006 14:49:32 -0400
From: Donald Mellen <donm@ontko.com>
Subject: Re: [sqr-users] Temp Table Error
To: "This list is for discussion about the SQR database reporting
        language        from Hyperion Solutions." <sqr-users@sqrug.org>
Message-ID: <453525BC.4010804@ontko.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

If you have dynamic sql in your select, most especially in the "from"
portion, sqr will many times "convert" all the columns to strings unless
you specify the type on the column.  Something like....

        begin-select
        my_number_col  &std_hours=number
           ....
        from my_temp_table
        ...yadda yadda yadda

should work for you. (The previous was indented for readability purposes
only).

HTH,
Don

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users