If you have a Member_ID is your correct identifier for each person, then this should give you the correct information.

CREATE TABLE SampleData(

FIRST_NAME ...

I can't remember anything like this in T-SQL. It can be simulated with other instructions, but the real functionality would be using MDX. Unless someone else can think of something...

So you include the whole history each month? Or why do you have only "enddate < @d1"?

This is an example of filtering using 6 months.

SELECT *

FROM SomeTable st

JOIN (VALUES(0),(-1),(-2),(-3),(-4),(-5))...

Without the information requested previously by Alan and me.

The only help I can give is this: The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url]

Read...

I wasn't sure about this, but it seems to work. It's resource intensive because there are lots of combinations. I don't have time to comment the code, but I strongly...

That doesn't sounds like a need of recursive queries. It seems to me that a tally table could do the job or just a date range.

We need more details including...

Is to remind us how things have...

I didn't want to post any code because this seems a lot like homework.

What have you tried? Why would you have a row with a phone set as null instead of not having a row at all?

You could at least post DDL, sample...

Sangeeth878787 (2/24/2015)

---

Hi Luiz,

I am really thankful for your conversion script, can you suggest me, based on this function logic, I need to add extra columns in SSIS, could you ...

I can't reproduce your problem. Or maybe you're doing something different.

CREATE TABLE Test(

string_pct varchar(10))

INSERT INTO Test

VALUES

('100%'),

('50%'),

...

Why do you have the division in the GROUP BY but not in your column list?

You need to either include it in both or remove it from both.

Could you post...

Phil Parkin (2/23/2015)

---

Luis Cazares (2/23/2015)

---

There's no need to over complicate it.

Actually, if you're inserting into an integer column, you don't need the CAST() from this example as it will be...

I'm not sure if someone explained it wrong or if you misunderstood what happens in SQL.

SQL (in this case T-SQL) is a declarative language, so you tell the engine what...

There's no need to over complicate it.

Actually, if you're inserting into an integer column, you don't need the CAST() from this example as it will be implicitly converted.

declare @dt varchar(12)...