Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Onyxpurr

    Fill in with $0 balance when period has no records

    I'm sure someone has a much better solution, but this is what I'd use: create table #customers (Account int, TrxDate date, TrxAmt decimal(9,2)) insert into #customers values (123, '10/02/2011', 48.00) insert into #customers values (123, '10/18/2011', 52.00) insert into #customers values (123...
  2. Onyxpurr

    What motivates you?

    Leaders should be considerate of the team by a) handling mistakes made by the team with care and sensitivity, but fairly b) being honest about what you mean - if something is poor quality, say so - c) be positive - look at issues as opportunities to shine, not point fingers etc" I...
  3. Onyxpurr

    Deadbeats

    I don't wonder if some of it is being overly-pc. e.g. "Jane Smith isn't a deadbeat, she's just 'learning'. You're being overly negative. You need to work on that." I have a person in my company that I've been struggling with trying to be open-minded, but I know others have issues with that...
  4. Onyxpurr

    (Un)Qualified People

    I'm not sure if I've missed if someone has already suggested this, but... My department frequently gets these issues. And it is EXTREMELY difficult to get people to initiate an email sometimes. So we do this (it's now our policy)... When they request something from you, send the following...
  5. Onyxpurr

    How do you concentrate on more than one thing?

    I find it exciting to be able to do this, but on the same level, sad that we're pushed this much. One way I do this is figure out what projects of mine require some waiting in order to do another. e.g. Need to put a document and send out for approval, then go work on another project while...
  6. Onyxpurr

    Advice for a beginner

    Is he more creative or analytical? I'm more analystical so I do a lot of SQL reporting. And I love it!! However, if he's more inclined towards creative, I might suggest web programming or software development. Perhaps even gaming programming??
  7. Onyxpurr

    Subquery with 2 fields

    select product.* from product LEFT JOIN (select productId, colorId from Sales where <Condition>) Tbl1 ON product.productId = Tbl1.productId AND product.colorId = Tbl1.colorId WHERE tbl1.productid is null
  8. Onyxpurr

    Helpdesk - How to handle long timers and the inevitable burnout!!

    Do you know a few "professionals" in your team you could ask?? Perhaps if you could identify a few that would give you honest and professional feedback, they could give a you a better representation of what helps and what doesn't? How about time off incentives? Or as some others have said here...
  9. Onyxpurr

    Earning a degree (Phoenix)

    You get what you put in. I did an accelerated program with night stduents at my university and learned a lot. It also helped that most of the students in the classes with me were professional adults. I have worked professionally for about 5 years, and agree that experience is valuable, however...
  10. Onyxpurr

    Working hours...

    Cool article, thanks!! Sounds like a lot of conflicting opinions on that topic though. Productivity per hour is higher yet they are not successful?? WTH??
  11. Onyxpurr

    Insessorial, Nemathelminth, Mycetophagous, ...

    Yes, just think, if we had applied ourselves we could've been famous, rich spelling masters. Oh wait...
  12. Onyxpurr

    Problem with WHERE clause

    Are you getting any errors or just no records?
  13. Onyxpurr

    multi tasking madness...

    Well, at least accept it as a good indicator for being good at what you do. If you weren't, people wouldn't trust you with all these projects. In previous and current lives, these things have helped me with a heavy workload... 1) Start keeping a master project/task list. You should be...
  14. Onyxpurr

    Working hours...

    Well my issue as a data analyst, is requests from users that have no idea of what it takes to pull together a report and a system that is shaky at best. My current issue is reports requested within a time period that is not feasible. I try to communicate this to the users and ask for...
  15. Onyxpurr

    Working hours...

    I agree with Thadeus. I'm not sure why everyone feels the need to work over 40 hours for the company, but feel it is unethical to sometimes work under. Shouldn't it be a give and take? Honestly, my company is paying me for my mental abilities and skill, not really my time. On average I work...
  16. Onyxpurr

    Working hours...

    Actually I prefer salary. I just refuse to be worked to the bone because of it. At my current job I do work overtime on occasion, however I also have the flexibility to leave early or for an hour or two during the day if I need it. This has been perfect for me lately, because my mom has been...
  17. Onyxpurr

    Could care less vs Could NOT care less

    Yes, I think both go hand in hand. It seems today that people take a lot for granted without really questioning where it really came from. My friends and I have always been big word buffs and usually make play on words or phrases, have discussions about them, and I guess just in general are...
  18. Onyxpurr

    Could care less vs Could NOT care less

    What I've seen a lot lately is a misunderstanding of the saying, because couldn't sounds a lot like could. I think frequently you'll find people misquoting simply because: 1. They heard it incorrectly and just assumed. 2. People, in general, really don't think about what they're saying. If...
  19. Onyxpurr

    Googling quirks

    Why would I want to query my name with a question mark? ;-)
  20. Onyxpurr

    Leaving off the n't

    Unfortunately, that which makes us a smarter species can also be our weakness. It's in our nature to 'fill in the picture'. In other words, we see a tree, rather than its leaves and branches. Just another reason why it's so important to have a designated proofreader. I don't mind the...

Part and Inventory Search

Back
Top