have a ms sql data table with the fields per the attached pdf.
I am wanting to have a query that will pull the records where "agent = 188" and it will pull the most recent (based on time in xtime field) from each lead number sorted so I have the most recent xtime record first - then the next most recent record from a different lead, then the next most recent record from a different lead.
So the end result will be only one record from each lead - but they will be in descending order by xtime (most recent first)
This will be a web page query not on direct interface - like starting from: strSQL = "SELECT * FROM textin2 WHERE (agent = 188)"
10 freelancers estão ofertando em média $23 para esse trabalho
Hello, I am available right now. I can do the right job. You can trust me. This is my field of studies. I have 5 years experience on development. Thanks in advance. Best regards,
I have a good skill set in MsSQL Server 2008/12/14/16, TSQL, Procedures, Functions, Views, Triggers, Performance tuning, Exception handling, Transactions. I can finish your work within a minute.