Thank you sir! Lookup worked.

Thanks Top Hand! but I guess my example was bad... so this is what I have in my excel imported table:

[Contract Start Date] | [Contract End Date] | [Remaining Month]...

Another question. I am thinking of attending one of these 5 day BI boot camp class. How are these classes? Worth it?

thank you all for your advice!

Thank you all again.

As for the transactions, it is more of an old data import rather than live transaction.

Problem is when we imported those old transaction date, it...

Thank you all for your help.

Another question :(. Is it possible to extract deleted data from transaction log file?

My understanding is that I have to purchase some third party...

Thanks for the answer Greg.

So basically,

1. Go to SSMS > Management > SQL Server Logs

2. Use filter to find the data deletion point and time.

3. Export csv or txt file.

4....

Thahk you Thank you Thank You Sir!!!

This is my version:

select count(Customer_id)

from InvoiceHeader

where month(PostingDate) = 5

and year(PostingDate)= '2007'

and exists

( select *

from InvoiceHeader

where (month(PostingDate) between 2 and 3)

and year(PostingDate)= '2007'

)

Our InvoiceHeader...

Thank you noeld!! can I ask you one more???

If I am understanding this right, your query sample will look for

any customer who made purchase between given periods (let say...