I got a head-ache from this really, b'cos I thought about that as well and this kind of logic is new for me. I talked to the Client and they...

Sure, is this what you mean?

create table #Something

(

CustID Char(10),

SurveyId char(5),

ResponseDate datetime

)

insert #Something

select 'Cust1', '100', '5/6/13' union all

select...

Hi Sean,

Thanks, but it's not just distinct customer, I need to count based on whether his response to survey was in the last 30 days. If he responded to more...

Has anyone post a solution to this?

I have the same issue that when I execute a stored procedure, thro a sql job via sql agent, I get the output to...

@hugo:

I'm not an expert in SQL. I was also under the impression that Cursors are a big NO and hence should be avoided at all costs. I'm only...