sql - Cannot understand error: - 


select     cast(dbo.trnrisk.vehdrivername varchar(100))  , cast(dbo.vieclaimregister.clientid varchar(100))  , cast(dbo.vieclaimregister.fileno varchar(100))  , cast(dbo.vieclaimregister.claimno varchar(100))  , cast(dbo.vieclaimregister.nameinitials varchar(100))  , cast(dbo.vieclaimregister.lossdate varchar(100))  , cast(dbo.mstinsurer.absainsurername varchar(100))  , cast(dbo.vieclaimregister.agentid + ' ' + isnull(dbo.mstagent.agentname, 'unknown')as varchar(100)) agentidname   , cast(dbo.vieteamselect.subregionid + ' ' + isnull(dbo.vieteamselect.subregionname, 'unknown')as varchar(100)) subregionidname  , cast(dbo.vieclaimregister.teamid + ' ' + isnull(dbo.vieteamselect.teamname, 'unknown')as varchar(100)) teamidname  , cast(dbo.vieclaimregister.linkid + ' ' + isnull(dbo.mstlink.linkname, 'unknown')as varchar(100)) linkidname  , cast(dbo.trnpolicy.brokercontact + ' ' + isnull(msthandler.brokername, 'unknown')as varchar(100)) brokeridname  , cast(isnull(dbo.vieclaimregister.assessorid,'none') + ' ' + isnull(dbo.mstclaimassessors.assesorid,'unknown')as varchar(100)) assessoridname  , cast(dbo.vieclaimregister.owndamage varchar(100))  , cast(dbo.vieclaimregister.thirdparty varchar(100))  , cast(dbo.vieclaimregister.thirdpartyestimate varchar(100))  , cast(dbo.vieclaimregister.paid varchar(100))  , cast(dbo.vieclaimregister.estimate varchar(100))  , cast(dbo.vieclaimregister.owndamageestimate varchar(100))  , cast(dbo.vieclaimregister.subsection varchar(100))  , cast(dbo.vieclaimregister.driverage varchar(100))   -- riskcoverdays looks @ first item on risk table in order risk inception date.  -- if there multiple items @ earliest risk inception date.  -- not quite correct, big improvement on old access database ,  -- easy enough program ...   , cast(dbo.vieclaimregister.riskdeletion varchar(100))  , cast(dbo.vieclaimregister.reportdate varchar(100))  , cast(dbo.vieclaimregister.causeid varchar(100))   -- make/ model description without mead & mcgrouther code:   , cast(dbo.vieclaimregister.vehmodel varchar(100))  , cast(dbo.vieclaimregister.clientstatuscode varchar(100))   -- following intended outside printable area in spreadsheet:   , cast(dbo.vieclaimregister.sectionid varchar(100))  , cast(dbo.vieclaimregister.riskno varchar(100))  , cast(dbo.vieclaimregister.lossdate varchar(100))  , cast(dbo.trnpolicy.inceptiondate varchar(100))  , cast(dbo.vieclaimregister.dateloaded varchar(100))  , cast(dbo.vieclaimregister.reportdate varchar(100))  , cast(dbo.vieclaimregister.settleddate  varchar(100))   -- how many weeks load date report date per f1:   , cast(dbo.vieclaimregister.settleddate varchar(100))  , cast(dbo.vieclaimregister.lossdate varchar(100))  , cast(dbo.vieclaimregister.claimpostalid varchar(100))  , cast(dbo.vieclaimregister.fasttrack varchar(100))  , cast(dbo.vieclaimregister.exgratia varchar(100))  , cast(dbo.vieclaimregister.handlerid + ' ' + isnull(dbo.msthandler.brokername,'unknown')as varchar(100)) handleridname  , cast(dbo.vieclaimregister.k4k varchar(100))  , cast(dbo.vieclaimregister.registration varchar(100))  , cast(dbo.vieclaimregister.claimslinkid varchar(100))  , cast(dbo.mstuser.username varchar(100)) claimslinkname  , cast(dbo.vieclaimregister.repudiation varchar(100))  , cast(dbo.vieclaimregister.insurerid varchar(100))  , cast(dbo.vieclaimregister.fees varchar(100))  , cast(dbo.vieclaimregister.expenses varchar(100))  , cast(dbo.vieclaimregister.recoveries varchar(100))  , cast(dbo.vieclaimregister.salvages varchar(100))  , cast(dbo.vieclaimregister.recoveriesestimate varchar(100))  , cast(dbo.vieclaimregister.salvagesestimate varchar(100))  , cast(isnull(thirdpartyestimate,0)as varchar(100)) estimatethirdparty  , cast(isnull(dbo.vieestimatemovement.estimatemovement,0)as varchar(100)) claimmovement  , cast(vieclaimregister.authoriseddate varchar(100))  , cast(vieclaimregister.teamid varchar(100))  , cast(vieclaimregister.agentid varchar(100))  , cast(vieclaimregister.linkid varchar(100))  , cast(vieclaimregister.insurerid varchar(100)) insureridforfilter   -- how many days load date authorised date(claim turn around time)   , cast(mstproduct.businessarea varchar(100))    dbo.vieclaimregister   left  join dbo.mstuser on      dbo.vieclaimregister.claimslinkid = dbo.mstuser.userid  left join dbo.trnclient on dbo.vieclaimregister.clientid = dbo.trnclient.clientid  left join dbo.trnpolicy on  dbo.vieclaimregister.clientid = dbo.trnpolicy.clientid , dbo.vieclaimregister.fileno = dbo.trnpolicy.fileno  left join dbo.vieestimatemovement on dbo.vieclaimregister.clientid = dbo.vieestimatemovement.clientid , dbo.vieclaimregister.fileno = dbo.vieestimatemovement.fileno , dbo.vieclaimregister.claimno = dbo.vieestimatemovement.claimno    -- vieteamselect includes mstteam, mstsubregion, mstregion, mstcompany:   left join dbo.vieteamselect on  dbo.vieclaimregister.teamid = dbo.vieteamselect.teamid   -- link code per claim table, not policy table (!) :   left join dbo.mstlink on  dbo.vieclaimregister.linkid = dbo.mstlink.linkid  left join dbo.mstagent on  dbo.vieclaimregister.agentid = dbo.mstagent.agentid  left join dbo.mstinsurer on   -- insurer code per claim table, not policy table (!) :  dbo.vieclaimregister.insurerid = dbo.mstinsurer.insurerid  left join dbo.mstinsurer mstinsurerlead on   -- insurer code per claim table, not policy table (!) :  dbo.vieclaimregister.insurerid = mstinsurerlead.insurerid left outer join trnrisk on  vieclaimregister.clientid = trnrisk.clientido , vieclaimregister.fileno = trnrisk.fileno  , vieclaimregister.riskno = trnrisk.riskid  left outer join dbo.msthandler on  vieclaimregister.handlerid = dbo.msthandler.brokerid  , trnpolicy.brokercontact = msthandler.brokerid  left outer join dbo.mstclaimassessors on  dbo.vieclaimregister.assessorid = dbo.mstclaimassessors.assesorid  left join dbo.mstproduct on  dbo.trnpolicy.productid= dbo.mstproduct.productid

this sql query access set of data use in reporting services. giving me error "conversion failed when converting varchar value 'absa insurance , financial advisers (pty) limited' data type int." after casting varchar. still new sql appreciated. sorry long, there lot of data work with.

my guess need cast id values in these statements varchar:

 , cast(dbo.vieclaimregister.agentid + ' ' + isnull(dbo.mstagent.agentname, 'unknown')as varchar(100)) agentidname   , cast(dbo.vieteamselect.subregionid + ' ' + isnull(dbo.vieteamselect.subregionname, 'unknown')as varchar(100)) subregionidname  , cast(dbo.vieclaimregister.teamid + ' ' + isnull(dbo.vieteamselect.teamname, 'unknown')as varchar(100)) teamidname  , cast(dbo.vieclaimregister.linkid + ' ' + isnull(dbo.mstlink.linkname, 'unknown')as varchar(100)) linkidname  , cast(dbo.trnpolicy.brokercontact + ' ' + isnull(msthandler.brokername, 'unknown')as varchar(100)) brokeridname  , cast(isnull(dbo.vieclaimregister.assessorid,'none') + ' ' + isnull(dbo.mstclaimassessors.assesorid,'unknown')as varchar(100)) assessoridname

meaning need this:

 , cast(cast(dbo.vieclaimregister.agentid varchar(10)) + ' ' + isnull(dbo.mstagent.agentname, 'unknown')as varchar(100)) agentidname   , cast(cast(dbo.vieteamselect.subregionid varchar(10)) + ' ' + isnull(dbo.vieteamselect.subregionname, 'unknown')as varchar(100)) subregionidname  , cast(cast(dbo.vieclaimregister.teamid varchar(10)) + ' ' + isnull(dbo.vieteamselect.teamname, 'unknown')as varchar(100)) teamidname  , cast(cast(dbo.vieclaimregister.linkid varchar(10)) + ' ' + isnull(dbo.mstlink.linkname, 'unknown')as varchar(100)) linkidname  , cast(cast(dbo.trnpolicy.brokercontact varchar(10)) + ' ' + isnull(msthandler.brokername, 'unknown')as varchar(100)) brokeridname  , cast(isnull(cast(dbo.vieclaimregister.assessorid varchar(10)),'none') + ' ' + isnull(dbo.mstclaimassessors.assesorid,'unknown')as varchar(100)) assessoridname

Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more