Eric M Russell (12/30/2015)

---

Orlando Colamatteo (12/30/2015)

---

Eric, agree it's not a ton more but Phil expressed it in more detail. This is basically my thoughts on it and where my comment...

As the name implies, staging is just that. The data is not meant to be a permanent fixture, otherwise call it a operation data store. If the goal is auditing...

+1

I avoided...

This looks like more of a math problem. You need to be able to define the function that represents the curve of travel. I am sure once you have that...

Michael L John (12/17/2015)

---

GilaMonster (12/17/2015)

---

Neither. It's there to...

It appears from my understanding that this could very well be quite complex maintenance wise. In your design, could you not snowflake out the course # to include the...

GilaMonster (12/15/2015)

---

Your exists subquery has no reference to the table in the outer query. Hence it will only be evaluated once and if the subquery returns any rows at all,...

shank-130731 (12/15/2015)

---

This worked for me, sort of. UAO.InvNo had a few records that were duped which stopped the query. When I deleted the dupes the query ran as expected. Thanks!

INSERT...

Banbo Bird (12/14/2015)

---

Hi,how can I get result like this:

Create table T1

(

pid INT primary key identity(1,1),

name varchar(10),

amount int

)

Create table T2

(

sid INT primary key identity(1,1),

subnum int,

flag varchar(5),

...

danny.delgado 65386 (12/14/2015)

---

I tried below combining it into three CTE but still no luck 🙁

WITH Cnt AS (

select Count(Distinct UserID) as Entitled_Users, DATEFROMPARTS(YEAR(t.WhenAddedToGroup),MONTH(t.WhenAddedToGroup),1) as When_Added_To_Group

from HVDMembership t

where FirstName not...

I expanded the code a bit and added more rows to list for month and year as two separate columns

CREATE TABLE #Temp (When_Added_To_Sec_Group DATE , UserID INT)

INSERT #Temp Values...

Rod at work (12/11/2015)

---

Eric M Russell (12/10/2015)

---

MMartin1 (12/10/2015)

---

Eric M Russell (12/10/2015)

---

In many cases the interviewer doesn't really know what they're asking about, and this...

Eric M Russell (12/10/2015)

---

What amazes me is how may times I would decide half way though an interview that I'm really not interested, spend the rest of the interview checking...

Eric M Russell (12/10/2015)

---

In many cases the interviewer doesn't really know what they're asking about, and this would be the guys who asked a...

Good points there. Consider asking a deep programming question that you have solved before, but doesn't happen everyday. You probably would not remember right there on the spot exactly how...