Thanks for the feedback. And I wont bog you down with questions, just that if you want to let us know the exact issues you encountered then we can certainly...

Done. Ohh was this a question? 😛

Did you have to draw this out on a...

I know this is the quickest and easiest way to go about it. You know that you are storing a...

I also wonder if you may want in the future to know if when those actions occurred. In your current design you would need three new columns for the times...

We are going to need your table definitions and a script to fill them with sample data. (Directly from the articles that you were linked to). I am not clear...

SQL Server could hold everything in RAM. Yet the database objects need to be tagged as to what database they belong to. I look at it as temp tables and...

Good stuff, thank you for taking the time to explain this.

Diligentdba 46159 (8/31/2016)

---

' I would not underestimate the competence level of members here to pick up new knowledge. ' - neither do I but I do think the average sql...

Odds ratio is better explained here since there is a more detailed example https://en.wikipedia.org/wiki/Odds_ratio

It makes better sense now, though I wouldn't call this simplistic necessarily.

the sql server world is...

lemmae880 (8/29/2016)

---

HI

CAN ANY ONE HELP PLEASE

TITLE: Web Service Task

------------------------------

Could not read the Web Services Description Language (WSDL) file. The input WSDL file is not valid. The following...

It seems to me that the odds ratio is equivalent to a percentage. n1/n2 only tells me how many of the bottom subgroup there are for each one of the...

This is why one must be very careful with the SELECT * approach. Since you will have to run a refresh of the view, I find it less potentially confusing...

SteveD SQL (8/30/2016)

---

Hi MMartin1

Thanks for your response, while my tables do have check and RI constraints I also use surrogate keys and therefore most of my data import type packages...

tung! (8/30/2016)

---

roger.plowman (8/4/2016)

---

Mononymics are fairly straightforward as far as I'm concerned.

The mononymic would go in the given/first name and "N/A" would go in the family name.

Also, nulls are abominations,...

So that you don't have to worry about hard coding years in your script, you could do :

WITH cte AS (

SELECT DISTINCT Sales_Rep, PYear, Number_of_Employees FROM mytable

)

SELECTcoalesce(py.sales_rep, cy.sales_rep) as...