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)"
Hi, I've worked with T-SQL at an advanced level for over twenty years, and I'm currently carrying out a number of projects on a freelance basis and I'm sure I'd be able to help with your query. I could do this ri Daha Fazla
Hi there, Yes I have no rate yet, but I have experience, and I am sure I will take my first 5 stars from you after I have done your job perfectly. I have read your project details and I think I am the right perso Daha Fazla
Bu iş için 10 freelancer ortalamada $23 teklif veriyor
Hi I read your post carefully. I have rich experience in mssql . I will satisfy your requirement on time. Please hire me.
Hi, open your team viewer and let me help you where agent = 188 and xtime is MAX contaxct me for more information. thank you
I am a technology solution architect and having more than 14 years of experience in IT industry. I can create query for you using partition and row_number. This will be achieved easily. Let me know if you want to discu Daha Fazla
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.
Dear Sir. I am very interesting on your project. I am major in AI such as Image Processing, Speech Processing, Planning, and so on. I have many experience on development of C/C++/C#/SQL/VB/VB.net/Java/Python progr Daha Fazla