mw112009 (9/16/2015)

---

Select MemberNbr, EligYear,EligMonth, count(*) FROM [MemberMonth] GROUP BY MemberNbr, EligYear,EligMonth HAVING COUNT(*) > 1

This shows that there are duplicates.

Can you help me write the...

Wayne West (9/16/2015)

---

I saw one argument to...

Sean Lange (9/16/2015)

---

Kristen-173977 (9/16/2015)

---

I'm never sure where...

Kristen-173977 (9/15/2015)

---

Pedantic point but I expect that needs to be COPYING rather than MOVING...

Sean Lange (9/15/2015)

---

Lynn Pettis (9/15/2015)

---

Not only that, three and four part naming conventions in a SELECT list has been deprecated. Using table alias lets you use two part naming...

Not only that, three and four part naming conventions in a SELECT list has been deprecated. Using table alias lets you use two part naming conventions in a SELECT...

drew.allen (9/15/2015)

---

This query can be greatly simplified if you look at it with a different perspective. Instead of the MAX row number within each group, you want a COUNT...

n.ryan (9/15/2015)

---

"Who's a Good Developer" is quite an open question and is best answered by answering the question "What do we want this person to do?"

For example, there are roles...

erichansen1836 (9/15/2015)

---

Answer me this, who is going to maintain your work when you are no longer around to do so? Are you training others to provide support? Do you expect...

erichansen1836 (9/15/2015)

---

Answer me this, who is going to maintain your work when you are no longer around to do so? Are you training others to provide support? Do you expect...

vedau (9/15/2015)

---

I had done something similar but to validate the backups. Here are the steps that I used.

1. Share PROD backup folder so that you can access it on TEST.

2....

sqlinterset (9/15/2015)

---

I have a below table as:

I queried below to get additional column

Select *,row_number() over(partition by [Year] order by Age) as RN from #Test as

YearAgeRN

2014301

2014312

2014323

2015251

2015262

2015273

2015284

2015295

i want one more...

nightowl23 (9/15/2015)

---

hi,

the below query is not working?? the fact1 table has 33520 rows,and fact2 has 33410,

however it returns no row when i use not in clause, what have i...

erichansen1836 (9/15/2015)

---

The OP seems to be looking for justification of his personal decisions regarding architecture.

Sure, stick with this system. It will work. Will anyone else be able to help...

Look at Robocopy.