tsql - query throwing error in web report writer -


i have query/view created used in report. when run in sms , in ssrs run fine. when connect view tool generates our reports throws following error. incorrect syntax near '.8'. when contact support product has how calculate 8thgradyear . have placed code below. suggestions.

select         dbo.studemo.suniq,  dbo.studemo.ident,  dbo.studemo.lastname, dbo.studemo.firstname, dbo.studemo.emailaddr stuemail,  dbo.studemo.birthdate,  dbo.track.schoolc,  dbo.school.schname,  dbo.stustat.graden, dbo.stustat.edate,  dbo.zstustat.descript status,  rtrim(dbo.facdemo.lastname) + '  ' + dbo.facdemo.firstname advisor,  dbo.track.schyear, sum(8) - dbo.stustat.graden + dbo.track.schyear [8thgradyear], sf.email, lower(sf.username) [user], lower(right(sum(8) - dbo.stustat.graden + dbo.track.schyear, 2) + left(dbo.studemo.firstname, 1) + replace(replace(replace(dbo.studemo.lastname, '-', ''), ' ', ''), '''', '') + right(dbo.studemo.ident, 3)) newuser,  convert(varchar(8), dbo.studemo.birthdate,1) password,  'students' + '/' + (case when track.schoolc in ('19', '43', '17', '23') 'middle' else 'elementary' end) + '/' + dbo.school.schname neworg,                           sf.ou, sf.lastlogintime            dbo.studemo inner join                          dbo.stustat on dbo.studemo.suniq = dbo.stustat.suniq inner join                          dbo.track on dbo.stustat.trkuniq = dbo.track.trkuniq inner join                          dbo.zstustat on dbo.stustat.stustatc = dbo.zstustat.stustatc inner join                          dbo.facdemo on dbo.stustat.funiq = dbo.facdemo.funiq left outer join                          dbo.vw_google_ou sf on sf.firstname = dbo.studemo.firstname , sf.lastname = dbo.studemo.lastname inner join                          dbo.school on dbo.school.schoolc = dbo.track.schoolc        (dbo.stustat.stustatc in                              (select        stustatc                                           dbo.zstustat zstustat_1                                       (snstatus in ('a', 'm', 'p')))) , (dbo.stustat.xdate null or                          dbo.stustat.xdate < dbo.stustat.edate) , (dbo.track.schoolc not in ('p34', 'p24', '802', '801')) group dbo.studemo.suniq, dbo.studemo.ident, dbo.studemo.lastname, dbo.studemo.firstname, dbo.studemo.birthdate, right(dbo.studemo.ident, 3), dbo.track.schoolc,                           dbo.stustat.graden, dbo.zstustat.descript, rtrim(dbo.facdemo.lastname) + '  ' + dbo.facdemo.firstname, dbo.stustat.edate, dbo.studemo.gradyear, dbo.track.schyear,                           sf.email, convert(varchar(8), dbo.studemo.birthdate, 1), sf.username, dbo.school.schname, sf.ou, dbo.studemo.emailaddr, sf.lastlogintime

sum function introduced in sql server 2008 , tool must using , older version of sql server.


Comments

Post a Comment

Popular posts from this blog

php - Submit Form Data without Reloading page -

i know question has been asked , answered bunch of times life of me can not solution work on code. believe if redo code, work properly, , in retrospect time i've spent on issue should have redone code...but beyond deadline , have working prototype up... can advise how update multiple forms on single page without reloading page? horrible @ php , complete noob js/jquery/ajax @ best. html/php in single file , believe causing me problems/is largest obstacle @ getting ajax form processing work. basically, want users to: select teams multiple dropdowns in form group 1 (league champs) , on update update db newly selected team without reloadding page. edit team scores per match , on score submit/update, update db new scores. for each requirement there multiple forms (1 each leagues, 1 each per match) have set class on each form id. everything works via php, form submission reloads page each time submitted , not ideal. i have tried ajax code here http://scotch.io/tutoria...
Read more

linux - Rails running on virtual machine in Windows -

the reason why want switch ubuntu people said gems works better on linux on windows. i don't want macbook pro rails development since love windows , cannot stand lack of apps mac. moreover, people saying ubuntu "better" mac: http://www.reddit.com/r/ubuntu/comments/1bgj1s/are_there_advantages_of_ubuntu_over_os_x_for/ does virtual box work enough doesn't have lag @ all? using i7-3517u cpu 8gb memory. need program in environment lag-free , not sluggish. or there alternatives recommend? i unsure permission settings or complicated stuffs regarding terminal. i'll using terminal develop. i'm still quite new here development in linux. please kind me >< thanks. @holyxiaoxin pretty sure should asking on superuser instead. nevertheless, suggest install ubuntu in partition instead of running virtual machine. here's guide https://help.ubuntu.com/community/windowsdualboot also, yes. developing in virtual machine accurate, @ end experiment w...
Read more