Tim_S
-
Posts
23 -
Joined
-
Last visited
About Tim_S
-
Hi, Quick question, mostly in the subject: Can admin users search the full text index for the whole server? Specifically I need to be able to search through all users for messages sent and find a specific message, but not having full text search currently enabled, I can't test and my googling has failed me. Currently on Exchange 2003. Cheers!
-
Can you put in authentication?
-
Sorted it. Went the temporary tables route in the end: CREATE TEMPORARY TABLE temp_occ (a INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (a), KEY(id)) select `id`, `userid`, `datefrom`, `dateto`, `numberdays` from occasions WHERE DATE_SUB(curdate(),INTERVAL 1 YEAR) <= `datefrom`; SELECT s.fullname AS userfullname,SUM(o.numberdays) AS daystotal, o.datefrom from temp_occ o INNER JOIN tracking.staff s ON o.userid=s.id GROUP BY o.userid The temporary table creation pulls out the correct date range, then all I need to do is SUM() the dates. Thanks for the input, it helped guide me in the right direction. T
-
Good questions. MySQL. It's a custom one for work, so not trying to extract from SIMS or anything. Occasions --------- id, userid, datefrom, dateto, numberdays, type, reason, note "10","1","2010-02-02","2010-02-03","1.00","selfcert","sickness","ytjfhtht" "11","1","2010-02-05","2010-02-09","5.00","selfcert","sickness","rthtrhrthtrh" "12","1","2009-11-03","2009-11-12","9.00","selfcert","sickness","theasd" "13","1","2008-12-17","2008-12-18","1.00","selfcert","sickness","2654yt5" "14","344","2010-02-17","2010-02-18","2.00","selfcert","sickness","rthrthrt" the staff table you only need to know they have fullname and id. Usig HAVING as it's a group by clause - for use with SUM(). As far as I know that's the only way it could work. Cheers, T
-
Tried that to no avail (doesn't seem to work with SUM as subqueries can only return 1 row) Think I might have to try creating temp tables.
-
Thanks for the direction, will give that a try at least...
-
Quick answer - email him after the next meeting with a quick summary of what you discussed, making sure the training is in there. After a short while of nothing happening, email asking about the training and when you can expect to go - maybe even find a course in a time you'd be free and suggest it. Make it as easy as possible for them to just have to say yes. If nothing happens then, maybe offer to go and chat to the director to see if there is any way you can clear things up with them. Simply, phrase it that you're helping them out, but making it clear that if they don't sort it out then you will. It's a fine line to tread, but bear in mind that it's your career that they're blocking! I've had that kind of manager for the last 4 years, and on Thurs I head off somewhere new where training is compulsory. :-)
-
SELECT s.fullname AS userfullname,SUM(o.numberdays) AS daystotal, o.datefrom from occasions o INNER JOIN tra.staff s ON o.userid=s.id GROUP BY o.userid HAVING DATE_SUB(curdate(),INTERVAL 1 MONTH) <= `datefrom` Quick question related to the code above: I'm trying to add up the contents from a column (the SUM part) from a certain date range - in this case one month. My problem is that it does the sum calculation first, so whatever date range I put in it will add all the contents of the columns - any suggestions? T
-
We've got around 30 colour lasers (C7521's and C420DN's) from richoh and an MFD (DSC460), have been working well for 4 years, with only minor part replacements - if we do need a technician then they've usually been onsite within 24 hours and often sooner. The MFD breaks a little bit more often, but then it does around 100k pages a year. Again, repair is quick. Would happily use them again. Can't comment on running costs as that's the bursar's job.
-
That would be zimbabwe, uganda is very stable. That 1000 shillings will get you a cold beer or a dinner in Uganda! Interestingly, it's illegal to take shillings out of uganda.
-
[ghost] Getting ghostcast working under native WDS
Tim_S replied to mrbios's topic in O/S Deployment
Ah ok, not sure on that as haven't used the pxe drivers for ghost, only standard drivers. -
Gah. I lost too.
-
[ghost] Getting ghostcast working under native WDS
Tim_S replied to mrbios's topic in O/S Deployment
The network driver for the computer you're going to be sticking the image on. T -
My guess: 284
-
Talking directly about the position you pm'ed me about - don't worry about it. Attitude and ability to learn would be key, especially if you can tick some of the other boxes. Talking in general now, if you have some spare time / cash, then courses are really good to show you're willing to keep yourself up to date, but be willing to be paid a bit less to gain that vital experience - then use the experience to be paid what you're worth. I started in my current position around 8k less than what I'm on now as I didn't have the experience, but with that I've moved up quickly. Now I'm heading somewhere else, where again I'm going to be on less than I want but am being offered lots of training and experience to help me move up.
