| 00:29.37 | *** join/#uphpu _psychic_ (n=john@c-24-2-78-210.hsd1.ut.comcast.net) |
| 01:39.08 | *** join/#uphpu macnewbold (n=mac@69.2.248.251) |
| 01:39.08 | *** mode/#uphpu [+o macnewbold] by ChanServ |
| 01:47.10 | *** join/#uphpu stderr (n=stderr@c-24-10-220-8.hsd1.ut.comcast.net) |
| 01:47.31 | *** join/#uphpu wps (n=wps@65.73.113.199) |
| 01:47.31 | *** mode/#uphpu [+o wps] by ChanServ |
| 01:54.09 | *** join/#uphpu cycokilr (i=cycokilr@c-67-166-124-68.hsd1.ut.comcast.net) [NETSPLIT VICTIM] |
| 01:54.13 | *** join/#uphpu diskotec|w (n=UN@12.125.156.114) [NETSPLIT VICTIM] |
| 01:54.13 | *** join/#uphpu kryp71k (n=kryp71k@64.50.125.202) [NETSPLIT VICTIM] |
| 02:09.53 | *** part/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 02:22.15 | *** join/#uphpu _psychic_ (n=john@c-24-2-78-210.hsd1.ut.comcast.net) |
| 04:30.18 | diskotec|w | bigdog: you around? I've got a sql question. |
| 04:44.01 | bigdog_ut | yes |
| 04:52.21 | diskotec|w | I'm working on a report...I work for a hospital and I want to select one patient visit during any given date range no matter how many times they've been to the hospital. It could be the earliest visit or the latest, it doesn't matter. Is there a some sort of function that just returns unique data on a given column? I'm selecting a visit number which a patient may have a lot of and I'm also selecting a medical record number which they only have one of no |
| 04:52.21 | diskotec|w | <PROTECTED> |
| 04:53.40 | diskotec|w | I just want a record of a given patient just one time and I thought if there was some sort of function I could apply to a given column, that should do the trick. |
| 04:54.49 | diskotec|w | I was thinking if one exists, I'd apply it to the med_rec_no column |
| 05:00.33 | diskotec|w | oh...maybe I should use distinct? |
| 05:12.42 | stderr | well, distinct will give you one of each entry, and no 'clones' |
| 05:13.26 | stderr | diskotec|w: what RDBMS are you using? |
| 05:18.47 | bigdog_ut | on sec diskotec|w |
| 05:19.39 | bigdog_ut | distinct is fine |
| 05:38.46 | *** join/#uphpu wps (n=wps@65.73.113.199) |
| 05:38.47 | *** mode/#uphpu [+o wps] by ChanServ |
| 05:48.26 | *** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com) |
| 06:22.22 | *** join/#uphpu usynic (n=synic@pdpc/supporter/student/synic) |
| 06:47.12 | diskotec|w | thanks for the confirmation bigdog. =) |
| 06:47.44 | diskotec|w | sorry for the delayed response |
| 06:49.07 | diskotec|w | going home now...good night. |
| 13:26.25 | *** join/#uphpu cboyack (n=cboyack@128.187.191.216) |
| 15:09.24 | *** join/#uphpu synic (n=synic@pdpc/supporter/student/synic) |
| 15:20.16 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool138-133.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 15:34.39 | *** join/#uphpu wps (n=wps@209.63.57.116) |
| 15:34.40 | *** mode/#uphpu [+o wps] by ChanServ |
| 16:17.32 | *** join/#uphpu _psychic_ (n=john@128.187.163.209) |
| 16:56.16 | *** join/#uphpu _psychic_ (n=john@128.187.163.209) |
| 16:57.27 | *** join/#uphpu xilch|w (n=duh@66.239.17.226.ptr.us.xo.net) |
| 16:57.54 | *** join/#uphpu wps (n=wps@209.63.57.116) |
| 16:57.55 | *** mode/#uphpu [+o wps] by ChanServ |
| 18:08.32 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 18:14.02 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 18:19.34 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 18:25.05 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 18:30.36 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 18:31.49 | *** part/#uphpu Utah_Dave (n=boucha@0-1pool138-133.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 18:31.54 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool138-133.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 18:36.08 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 18:41.39 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 18:46.01 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 19:09.17 | wps | gentlemen |
| 19:09.33 | wps | how much should a senior level software engineer be paid in today's, Utah County Market? |
| 19:09.44 | wps | (is Level IV the highest?) |
| 19:09.51 | wps | $80,000 - $100,000 ? |
| 19:10.22 | wps | macnewbold? |
| 19:10.25 | wps | dataw0lf? |
| 19:10.31 | wps | what say ye? |
| 19:10.37 | macnewbold | That's probably pretty close. That'd be the minimum, I think, if they're trying to hire such a person. |
| 19:10.59 | wps | so, perhaps even up to $120,000 - ish? |
| 19:11.02 | macnewbold | D.O.E., maybe up to $120,000, or perhaps more |
| 19:11.03 | macnewbold | yes |
| 19:11.20 | wps | 20 years software experience… word perfect… novell… masters degree |
| 19:11.32 | macnewbold | I'd say that such a "senior" level person would have, oh, nevermind |
| 19:11.40 | macnewbold | yes, someone with that kind of credentials, |
| 19:11.40 | wps | what? |
| 19:11.53 | macnewbold | as long as they've got some good stuff to show for it, |
| 19:11.55 | macnewbold | they'd be worth that |
| 19:12.01 | macnewbold | or more |
| 19:12.08 | macnewbold | as long as their skills are still up to date |
| 19:12.19 | wps | yes, but what do you think that they could ask for? |
| 19:12.38 | wps | (because if they ask too high, then the company might very well hire someone a little less experienced so they don't have to pay as much) |
| 19:13.33 | macnewbold | with that experience and stuff, with up to date skills and good results to show from previous work, |
| 19:13.45 | macnewbold | they could probably ask $120,000 pretty comfortably |
| 19:14.11 | wps | thanks |
| 19:14.21 | macnewbold | though if they want it bad, |
| 19:14.58 | macnewbold | they may be negotiable, with a concrete plan in place for raises |
| 20:22.45 | *** join/#uphpu stderr (n=stderr@c-24-10-220-8.hsd1.ut.comcast.net) |
| 22:14.11 | *** join/#uphpu jsmith (n=jsmith@70.103.248.130) |
| 22:34.49 | *** join/#uphpu RyanE (n=ryan@rberick.dsl.xmission.com) |
| 23:05.07 | stderr | http://www.dionaea-house.com/ |
| 23:14.46 | *** part/#uphpu Utah_Dave (n=boucha@0-1pool138-133.nas28.salt-lake-city1.ut.us.da.qwest.net) |