Viewing 15 posts - 796 through 810 (of 844 total)
I'm with Simon here. You stick with what works, what is simplist (KISS principle) and what you can get done quickly. You look for better ways to do things, but...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 7, 2013 at 8:58 am
Thanks for the info Sean, I thought a table would be the best way to go. I don't think this example with completely work but I've got the general...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 16, 2013 at 10:50 am
I went to a community college, a 18 month straight program with courses on computer programming. None of the what I call 'filler' courses you have to take at...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 16, 2013 at 8:24 am
I agree I would do left joins also, I can't remember writing a right join. I didn't post the code, and I'm sorry when I read your post I...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 12, 2013 at 8:16 am
I agree with Sean's version. As you have found out this is a nightmare to figure out, it may work but it doesn't make it right. I think...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 12, 2013 at 7:55 am
jmoney 69422 (9/11/2013)
...I devised a problem for them to solve.
Great idea, if I was interviewing I would like this approach.:-) Got any openings? 🙂 Just kidding, or am...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 11, 2013 at 10:45 am
I agree with Dave62 on this, a probation period of 6 months. That's what my company has and it has worked for us, some mistakes but that can be...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 11, 2013 at 9:50 am
I was once fired on a Monday morning, I would have preferred the prior Friday. I would think they knew before I left on Friday that this was going...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 9, 2013 at 7:17 am
It's realy hard to understand what you are after here is it the 'Diff' can not be zero to send email or if number of rows returned is not zero...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 6, 2013 at 7:43 am
Steve Jones - SSC Editor (9/5/2013)
And for the lighter side of interviews:
Now that there is funny, I don't care who you are. 🙂
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 5, 2013 at 12:08 pm
I wasn't asked any weird questions but I was asked to solve a puzzle. It was one of those puzzles where you needed to only move a couple pieces...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 5, 2013 at 7:45 am
Until recently we didn't use the 'included' on our indexes. We started adding fields to existing indexes, we didn't run into a limit but ran into another problem. ...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 27, 2013 at 2:05 pm
I don't know if it really applies to your code but we found turning some 'functions' that were just big case statements into a 'reference' table. This really sped...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 27, 2013 at 8:35 am
I get it now, it was throwing me off when you said 'line', I was thinking the actual line number.
Maybe this is just me not understanding stored procedures but let's...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 22, 2013 at 2:58 pm
Thanks 'You name Here', its been a good day for gaining new knowledge. Not real sure where or when I would need to do this but I will try...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 22, 2013 at 1:10 pm
Viewing 15 posts - 796 through 810 (of 844 total)