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

The log message that you posted are from the job itself and not the SSIS Package. Do you have, if not you should, logging enabled within the SSIS package? If...

No matter how the package is invoked or from where, it will run on the machine it is saved in. What exactly are you aiming for ? The fact that...

Ok thank you Jack, I shall read up on that article