Search results for query: *

...TrxDate <= @endmonth group by account) c1 on c.account = c1.account set @month = DateAdd(Month, DateDiff(Month, 0, @month)+1, 0) set @endmonth = DateAdd(Month, DateDiff(Month, 0, @endmonth)+2, 0)-1 select @month, @endmonth set @int = @int + 1 end select * from #customertotals

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...

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...

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...

...to put a document and send out for approval, then go work on another project while waiting for approval. or Start some code that I know will take a while to run, then do a quick query while the other one runs. Of course, I have two pcs, and three monitors. Nah, I'm not overworked...*thump*

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??

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

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...

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...

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??

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

Are you getting any errors or just no records?

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...

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...

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...

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...

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...

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...

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

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...