AnsweredAssumed Answered

Help with NSQL parameters.

Question asked by Keri Taylor on Sep 9, 2009
Latest reply on Oct 13, 2009 by Dave
Need help with NSQL code. I am getting this error when using the other parameters. Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.   I am a noob at this wrap thing, and have never done it till i found some posts from Paul... when i wrap the sql inside...where would i put the additional parameters if I needed them?   SELECT
@select:dim:user_def:implied:TEAM:prid:prid@
, @select:dim_prop:user_def:implied:TEAM:prprojectid:prprojectid@
, @select:dim_prop:user_def:implied:TEAM:prresourceid:prresourceid@
, @select:dim_prop:user_def:implied:TEAM:project:project@
, @select:dim_prop:user_def:implied:TEAM:projectid:projectid@
, @select:dim_prop:user_def:implied:TEAM:project_manager:project_manager@
, @select:dim_prop:user_def:implied:TEAM:CONVERT(DATETIME,por_pravailstart,101):por_pravailstart@
, @select:dim_prop:user_def:implied:TEAM:CONVERT(DATETIME,por_pravailfinish,101):por_pravailfinish@
, @select:dim_prop:user_def:implied:TEAM:fiserv_proj_status:fiserv_proj_status@
, @select:dim_prop:user_def:implied:TEAM:resource_caption:resource_caption@
, @select:dim_prop:user_def:implied:TEAM:role:role@
, @select:dim_prop:user_def:implied:TEAM:resource_manager:resource_manager@
, @select:dim_prop:user_def:implied:TEAM:CONVERT(DECIMAL(10,2),prallocsum):prallocsum:agg@
, @select:dim_prop:user_def:implied:TEAM:CONVERT(DECIMAL(10,2),estsum):estsum:agg@
, @select:dim_prop:user_def:implied:TEAM:sponsor_name:sponsor_name@
, @select:dim_prop:user_def:implied:TEAM:sponsor_obs_id:sponsor_obs_id@

FROM
(
select
tm.prid
,tm.prprojectid prprojectid
,tm.prresourceid prresourceid
,p.name project
,p.code projectid
,pm.LAST_NAME+', '+pm.FIRST_NAME project_manager
,ISNULL(tm.PRAVAILSTART,p.SCHEDULE_START) por_pravailstart
,ISNULL(tm.PRAVAILFINISH,p.SCHEDULE_FINISH) por_pravailfinish
,odf.newfiservprojstat fiserv_proj_status
,r.full_name resource_caption
,case when rr.role IS NULL Then r.full_name Else rr.role END role
,rm.LAST_NAME+', '+rm.FIRST_NAME resource_manager
,CASE WHEN r.RESOURCE_TYPE   Any help is greatly appreciated. :-)

Outcomes