quote:Originally posted by Adriaan Add a new non-clustered index on (CustomerId). Another option would be to change the non-clustered index to...
alzdba, I didnt miss that part. In his heart, a man plans his course, but the LORD determines his steps
quote:Originally posted by Adriaan What indexes do you have on tblTransactions? Clustered: TransacID Non Clustered: WhenCreated CustomerID...
SELECT DISTINCT T1.CustomerID , T1.WhenCreated FROM tblTransactions T1 WHERE T1.WhenCreated IN ( SELECT TOP 2 T2.WhenCreated FROM tblTransactions...
Hi Alzdba, What is SSP by the way? <img src='/community/emoticons/emotion-1.gif' alt=':-)' /><br /><br /><br /><br /><hr noshade size="1"><br...
Alzdba... Thanks.. My friend. I will try out that idea. In his heart, a man plans his course, but the LORD determines his steps
Khtanm Thanks for you reply. But does it ensure the same number of transactions of each customer will be returned? quote:Originally posted by...
Hello. Thanks for people reading this This is a table which stores 2 million records for all the customers. Columns of tblTransactions:...
Further Please teach me how to SQL.<br /><br />This is a big table which stores 2 million records for all the customers.<br /><br />Columns of...
"Can you provide some ways that I might be able to avoid using cursors in my applications?"...
It solved the problem.<br />Like 2 sec something to get the result which is very well.<br />[<img src='/community/emoticons/emotion-1.gif' alt=':)'...
You are the man, I am 1/2 sleep. it is 2 am over here. I appreciate it. In his heart, a man plans his course, but the LORD determines his steps
alzdba, I have tried your one succesfully. and it performs well select CustomerID , max(WhenCreated) as max_Customer_WhenCreated from...
Hello People, This is a big table which stores 2 million records for all the customers. Columns of tblTransactions:...
Do most of the developers spend more life on computer rather than with her/his family? Well, I do. But I really want to change. In his heart, a...
Gracias. All good guys. Love this place. I reply emails often.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Actually I am from China P.R (Communist world) I am currently in 'Cloudland' for a telematic project. Cheers.
Well it is one of the sites that I want to donate for. Keep it up. The articles are awesome! Xiexie, Merci, Danke and Thanks. God bless. I reply...
Separate names with a comma.
