IceDread (5/29/2012)

---

I agree that interviews are a tricky thing. Thou I do a bit like your friend does, prepare questions and read about the company on the web and what...

Lynn Pettis (5/25/2012)

---

Oliiii (5/25/2012)

---

Ah, here is why you don't seem to get what i say 🙂

I'm not talking about any failure or incident. I'm only talking about mistake.

When things go...

allmhuran (5/24/2012)

---

...

GSquared has provided a description that I expect applies to a heck of a lot of businesses out there, ie, "lots of different options from the list". I do...

The kind of "blame"/"responsibility" being proposed here is the healthy kind. Find out who messed up and why, and educate them on the right way to do it. ...

allmhuran (5/23/2012)

---

Yes indeedy, your rundown mimics very closely the various options currently used where I work, and indeed at pretty much everywhere I've...

Glad I could help.

Start with MSDN.com. It's where Microsoft documents all the T-SQL commands, functions, syntax, etc. Same content as the installable "help file", called Books Online.

If you need the syntax...

SQLKnowItAll (5/23/2012)

---

drew.georgopulos (5/23/2012)

---

not so good...there are business analysts interposed between the report requestor and developers, so developers rarely speak to the end user.

My feeling is that GSquared's suggestion hits the...

Start with an SQL task to generate a dataset with a list of the file names, and the range of records for each. Easy to do with a basic...

Possibilities that come to mind are a misdone in-place upgrade, or someone really badly messed up and restored the wrong backup of those. I'm not even sure that's possible,...

Oliiii (5/23/2012)

---

Where i work, when you fix something you have to usually show why it was like that, what you did to fix it and why the dude developing it...

This is probaby the part that's killing your query speed:

AND (( A.CO_IN_ITEM_OPT = '00' AND ( B.BUSINESS_UNIT = A.BUSINESS_UNIT OR A.BUSINESS_UNIT = ''))

OR ( A.CO_IN_ITEM_OPT = '01' ...

I think part of the problem is that your query doesn't have a Case statement in it anywhere, and doesn't need one.

What you need is something like:

select *

from #temp

where (@isActive...

drew.georgopulos (5/23/2012)

---

i was hoping for a less interactive/intensive way to arrive at a statement of what exactly the problem we are trying to solve is, but you are right, i...

Automation of my work is why I got into IT in the first place. Never yet worked my way out of a job. Don't think it'll happen any...