Thanks Sean .....This should do it 🙂

Thanks again

@SQL_FS...... You got it right. Thanks for catching my mistake. Yes, for 101 the LatestStatus should be INACTIVE on April04,2012,

@sean......thanks for your query. Your query can...

Thanks for the suggestion. I never thought about that 🙂

Hi Lowell,

Thanks for your response. This is what I needed. However, is it possible to embed this logic to create a scalar valued function so that I can use these...

Thanks. This is just what I needed 🙂

Here is what I should see. Sorry, I had to put this vertically

consumerID - FX1

Ordercode - ...

Thanks Scott. Your script gave me what I needed. However, I've read in some forums that microsoft will probrably get rid of "master.dbo.spt_values". Just wondering if there are some other...

Seems like this is what I needed 🙂

Thanks guys.

thats how the database has been set up and this is jsut one sample data for one member. Am I still confusing you on my question??

Yes members can be reactivated. However, this reactivated members would be treated as a new members and we would only use the points they've earned after they've reactivated again. All...

Thats what I needed:-). Thank you.

Hi Ray,

No. The customerID is different for each customer. Below is the revised INSERT statement

GO

INSERT INTO dbo.CustomerPurchase ( PurchaseDate, CustomerID, CustomerName, PurchaseDetails)

SELECT '2012-06-01 00:00:00.000',1001,'Wilson Menthis','Purchased Item 6AB2'

UNION...

Hi Laurie,

Your query worked fine with the original samples. Now, the requirements has been changed and they want to add new columns in the destination table. From past three days,...

Thanks for both of your responses. I agree with both of you that having a varchar datatype for the datetime field is going to give us trouble. However, changing that...

It seems to be working 🙂

Thanks