asp.net - Combine Select Statements -


i building dashboard screen requires multiple sql statements return data. of these database calls adding in regards performance.

as stands code calls online meaning i'm making database calls inside code. move of database calls stored procedure not sure how combine of database calls 1 stored procedure return multiple values have display each of values individually.

can show me how combine these select statements 1 , return multiple values yo used inside code. 

/*pending count */ select count(*) issue issue.workerkeyfk =  lngworkerkey       , issue.closeddate null  /* today's issue count */              select count(*) issue issue.workerkeyfk =  lngworkerkey       , issue.issuedate =  formatdatetime(datetimes, dateformat.shortdate)  /* on due issue count */ select count(*)  issue issue.workerkeyfk =  lngworkerkey       , issue.duedate <  formatdatetime(datetimes, dateformat.shortdate)       , issue.closeddate null         /*get closed issue count */ select count(*) issue issue.workerkeyfk = lngworkerkey       , issue.closeddate not null 

here's how it:

select     sum(iif(issue.issuedate = formatdatetime(datetimes, dateformat.shortdate), 1, 0) today_issue_count     , sum(iif(issue.duedate < formatdatetime(datetimes, dateformat.shortdate) , issue.closeddate null, 1, 0) overdue_issue_count     , sum(iif(issue.closeddate not null, 1, 0) closed_issue_count issue     issue.workerkeyfk = lngworkerkey

that way have 1 resultset deal with, , execution should pretty quick on server.


Comments

Post a Comment

Popular posts from this blog

angular - DownloadURL return null in below code -

when change file updated in firebase storage when try downloadurl show null. filechange(event: any) { const imagefolder: string = this.employee.id; const filelist: filelist = event.target.files; const file: file = filelist[0]; const storageref = firebase.storage().ref().child(`${imagefolder}/profile.jpg`).put(file); console.log(storageref.snapshot.downloadurl); } the put() asynchronous. if want url after file uploaded have this: firebase.storage().ref().child(`${imagefolder}/profile.jpg`).put(file).then((snapshot) => { storageref = snapshot.downloadurl: console.log(snapshot.downloadurl); });
Read more

meteor - inserting data to database gives error "insert failed: Method '/texts/insert' not found" -

i have other project broke somehow(i have no idea) , rebuilt app same file names , code , working fine. problem when go insert data database called texts error insert failed: method '/texts/insert' not found not know wrong because copied every line of code previous project , problem came wasn't there before. confuses me when create user accounts accounts.createuser() works fine. sendtext.js import react "react"; import {texts} "./../api/text"; import {withrouter} 'react-router-dom'; import {meteor} "meteor/meteor"; import {accounts} "meteor/accounts-base" class sendtext extends react.component{ send(e){ e.preventdefault(); let message = this.refs.message.value; let name = accounts.user().username if(name != ""){ if(message){ texts.insert({ name, message }); this.refs.m...
Read more