SQLBill (8/20/2010)

---

Steve,

Good article, well written. However, as brought up it does give an appearance (notice I said appearance) of a conflict of interest.

You highlight a RedGate product and guess...

Well, that didnt tell us much, did it? I was assuming that member address view at least would link between the two.

It would be nice if the design was documented...

I think personal investment in training and conferences is great, and people should absolutely do it.

But don't think of it as a way to impress the boss or get him...

Could you post the definitions of each view too? That will probably be revealing as to how these tables link.

My guess is that envirnoment key is coincidental and not needed...

BravehearT1326 (8/20/2010)

---

Ran the following code to give me an idea how many rows on each table have the environment_key 'DL' which is used for joining the 3 tables together to...

'Seems' to generate a cartesian results set? If you arent sure, my first suggestion would be to add the environment key from each 'table' to the select and try...

edit:nevermind

Barkingdog (8/13/2010)

---

A business analyst raised this issue: what is an efficient way to do a SELECT against specific columns in a table. For example, we have one table with at...

Robert Lassiter (8/13/2010)

---

DECLARE @month char(10)

SET @month=(select distinct CASE

When July.F1007 is null or July.F1007 < 1 then 'MovementEXP.F1007'

Else 'July.F1007'

END from movementexp join july on MovementEXP.F01=July.F01)

Later I want to...

The only thing you divide by is SUM(TOTALQUANTITYMADE) so it must be returning zero for this product.

If that is not a valid case (should never be zero, Id query...

Robert.Smith-1001156 (8/3/2010)

---

Uh oh. Somebody got out of the cranky side of bed this morning.

In my experience, unless you're in a union shop you really can't afford to be that...

Actually on closer inspection Im not sure this needs much fancy consecutive counting, but there is a lot of business rules handling.

Thought I just about had this then something tripped...

One more quick question:

When I am finding the new records to be updated, which of the following should be done:

1) Find all records where CoverageTimePeriod is null

OR

2) Find the most...

Is lapse 1 or 0 or the number of months lapsed? (Your two examples had two different things). Is lapse only set to a value the month the lapse...

Thanks for the extra detail Lallitha. I have a few follow-up questions though:

-What are the inputs and expected output of the query? It looks like in your samples your...