Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
{replace-and-render}


{replace-item:%component-selections%}{sql:dataSource=myDS|output=html|heading=false|border=0|table=false}
 select top 785':''',ccc,''':''',ccc,'''' from (
   select distinct component as ccc from releases where 
   date>dateadd([year],-1,GETDATE())
union 
   select distinct component as ccc from installs where  expdate >= getdate() 
)  as c  order by ccc asc
{sql}{replace-item}
{replace-body}

{run:autorun=true|replace=component:sysadmin:Select component:select:%component-selections%}
{run}

{replace-body}

{replace-and-render}

Image Removed