based on your sample data...what should the result look like?

marg 14154 (7/14/2014)

---

I am trying to import a text file to a SQL server table using SISS. I use SSIS but this is my first time in import this type....

may be this will give you some ideas

http://www.bidn.com/blogs/mikedavis/ssis/153/using-expression-ssis-to-save-a-file-with-file-name-and-date

Memberid 22222 was not enrolled from 2013-01-01 to 2013-01-31, but was enrolled from 2013-02-01 to 2013-08-31 and 2013-09-01 to 2013-12-31. The only gap is January and that is only...

Arno...did you run your script against the test data script I provided....what were the...

Lynn Pettis (7/11/2014)

---

First, to clarify. A person is considered continuously enrolled as long as the total of any gaps in enrollment are less than 45 days in the given...

Tammy-274861 (7/11/2014)

---

Hi J Livingston!

The member abc would be continuously enrolled, since adding the gaps, he has a total of 42 days gap, which is less than the 45 days allowed.

The...

Tammy-274861 (7/11/2014)

---

Hi J Livingston!

The member yxz would be discarded since he has more than the 45 days allowed per year as gap to be continuously enrolled. Notice that I am...

for clarification....what would you expect for these :

INSERT INTO [nj_members] VALUES('abc','123',2013-01-01,2013-01-31)

INSERT INTO [nj_members] VALUES('abc','123',2013-02-14,2013-03-31)

INSERT INTO [nj_members] VALUES('abc','123',2013-04-14,2013-04-30)

INSERT INTO [nj_members] VALUES('abc','123',2013-05-14,2013-12-31)

INSERT INTO [nj_members] VALUES('xyz','999',2013-01-01,2013-06-30)

INSERT INTO [nj_members] VALUES('xyz','999',2013-08-01,2013-11-30)

thanks for script...just to confirm please....you are definitely running this in 2005 and not higher?

care to provide some sample scripts of create tables/ insert sample data and expected outcome based on the data you provide....will be easier to provide a tested solution for you.

Tammy...it will be easier to help you if you can please provide some scripts that create a table with suitable sample insert data scripts that describe you problem....along with the...

what is the business definition of "lifetime value of customers"?

sifar786 (7/6/2014)

---

[font="Verdana"]Hi,

Outputs: dropdown Filters are on Country Category, Manufacturer, Brand and aggregation done after applying each such filter.

Select:

Your CountrySPAIN

Your CategoryJUICES

Your ManufacturerA.J. BARD

Your BrandRUBICON

Calculations:

Data is grabbed from ItemWeekWise table

Country

Count the...

think you are going to be busy here.....:w00t::w00t:

there are some regular posters on here that are far more experienced than I in BI...hopefully one will pick this up as well.

out...