sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-

msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script 

 declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt                              appt._id=112601)                              --select @starttime set @script =  'select distinct    ptlast_name + '', '' + pt.first_name patient_name,              dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob,              (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' +             convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), dob), appt_date) - case when day(dob) > day(appt_date) 1 else 0 end)) + ''/'' +             convert(varchar, (datediff(d, (dateadd(m, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), dob), appt_date) - case when day(dob) > day(appt_date) 1 else 0 end), (dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), dob)))), appt_date)))) patage,             pt.org_id, pt.address1 pataddress,             pt.last_name lastname,pt.first_name firstname,             pt.middle_name middlename,             phy.last_name + '', '' + phy.first_name physician,             dbo.formatdate(appt.appt_date,''mm/dd/yyyy'') collecteddate,             (case when substring(start_time,0,charindex('':'', start_time)) < 12 convert(varchar,start_time) + convert(varchar,'' am'') else' +convert(varchar,@starttime)+  '+ substring(start_time,3,6) + '' pm'' end) collectedtime,              (case when pt.gender =''1'' ''m'' else ''f'' end) gender,pt.city,lst.state_short_name state ' +              (case when @specimenid = 0 ', 0  speciid' else ', (case when tbl_pat.speci_id > 0 tbl_pat.speci_id else '''' end) speciid' end) + '         pt inner join                       appt on pt.pat_id = appt.pat_id inner join                       phy on appt.phy_id = phy.phy_id inner join                       lst on pt.state = lst.state_id ' +                        (case when @specimenid = 0 '' else 'left outer join  tbl_pat on appt.appt_id = tbl_pat.speci_apptid' end)  + '    (appt.appt_id = 112601) ' + (case when @specimenid = 0 '' else 'and (tbl_pat.speci_id = ' + convert(varchar, @specimenid) + ')' end) exec (@script)

can or correct script please


Comments

Post a Comment

Popular posts from this blog

ruby on rails - Permission denied @ sys_fail2 - (D:/RoR/projects/grp/public/uploads/ -

-
i trying rename upload image permission denied @ sys_fail2 - (d:/ror/projects/grp/public/uploads/gallery/test.jpg, d:/ror/projects/grp/public/uploads/gallery/qinsnvzicc20160509132021.jpg) my code : photo = params[:gallery][:gal_img] name = photo.original_filename directory = "#{rails.root}/public/uploads/gallery/" path = file.join(directory, name) uniq_name = (0...10).map { (65 + rand(26)).chr }.join time_footprint = time.now.to_formatted_s(:number) file.open(path, "wb") |file| new_file_name = uniq_name + time_footprint + file.extname(file) file.write(photo.read) @uniq_path = file.join(directory, new_file_name) file.rename(file, @uniq_path) end i have checked , giving privilege in ruby directory. please let me know why getting permission denied error?
Read more

c++ - nodejs socket.io closes connection before upgrading to websocket -

-
i'm trying write c++ client talk websocket server written using nodejs , socket.io. can't c++ client establish websocket connection; server drops connection right after client requests http connection upgraded websocket. i used tcpdump watch packets going , forth. when use websocket server browser, works great , tcpdump output shows packets going , forth. when try connect server using c++ client, websocket connection never gets established. output tcpdump shows upgrade request being sent server followed server dropping connection. i tried replicating sequence of events using nc . connected server (running on port 8080) , copy-pasted exact set of headers sent browser, captured tcpdump. duplicate of working headers, connection dropped. there no output on server end indicating why connection gets dropped. here headers sent: get /socket.io/?type=player&eio=3&transport=websocket&sid=7mdclht_8ctsd6f4aaac http/1.1 host: localhost:8080 connection: upgrade prag
Read more

python - PyQt: Label not showing correct number of length -

-
i making quiz application in pyqt4, there 3 main generators: incorrect , correct , timeout . all answers connecting scorecheck function: def scorecheck(self, sendercheck): if ( sendercheck == self.answ ) or ( sendercheck == self.answ1 ) or ( sendercheck == self.answ5 ) or ( sendercheck == self.answ7 ) or ( sendercheck == self.answ8 ) or ( sendercheck == self.answ10 ): self.wronganswers.append(1) elif ( sendercheck == self.answ2 ) or ( sendercheck == self.answ4 ) or ( sendercheck == self.answ9 ): self.correctanswers.append(1) elif sendercheck == self.tmr3: self.timeouts.append(1) print "worked" print len(self.timeouts) else: pass self.wronganswerlabel = qtgui.qlabel(str(len(self.wronganswers)), self) self.wronganswerlabel.setgeometry(220, 40, 200, 200) self.wronganswerlabel.setobjectname('wronganswercount') self.wronganswerlabel.setstylesheet("#wronganswercount { font-size
Read more