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...

Interviews, like tests, dont measure what you know, just what you dont know. When the criteria becomes harder, more difficult questions, the more likely you are to pass up a...

Maybe with

=IIF(Fields!Category.Value < Fields!Periodic.Value ,"red","black")

?

If actual is less than budgeted I would think that is a good thing. I would highlight it...

If you are seeing the new data source under the data sources folder, but the preview still complains of a reference to the old source, try clicking the save button....

Get me? (11/24/2015)

---

How large is each image file? Even if you scale them in reporting services it just uses html attributes or CSS for scaling but doesn't shrink the...

Just curious, to move on to the next step... the default behavior is for the current job step to complete reporting success. Are these steps you refer to in the...