Completed

create ms sql query

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)"

Skills: Microsoft SQL Server, SQL

See more: how to create sql, sql create table foreign key, sql create table primary key autoincrement, create temp table sql, sql server create table example, create table oracle, how to create table in sql server 2012, sql server create table primary key, create dll sql calls, sql query tree structure records, asterisk call forward database sql query, sql query child child, sql query create matrix report, pass query frm front end end php sql, create running total sql query, sugarcrm create sql query url, convert ms sql query mysql, create ms access form produce html page, display table sql query result joomla, sql query tree structure result

About the Employer:
( 427 reviews ) Davenport, United States

Project ID: #18987892

Awarded to:

sjDavidson

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 More

$25 USD in 1 day
(2 Reviews)
1.9
mohamedabuamra

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 More

$15 USD in 1 day
(0 Reviews)
0.0

10 freelancers are bidding on average $23 for this job

Jinxuetian

Hi I read your post carefully. I have rich experience in mssql . I will satisfy your requirement on time. Please hire me.

$30 USD in 1 day
(3 Reviews)
1.7
sfeuh

Hi, open your team viewer and let me help you where agent = 188 and xtime is MAX contaxct me for more information. thank you

$15 USD in 1 day
(2 Reviews)
1.0
jayantavkumar

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 More

$30 USD in 1 day
(1 Review)
0.2
drissijob

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,

$30 USD in 1 day
(0 Reviews)
0.0
Piyusha007

​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.

$10 USD in 1 day
(0 Reviews)
0.0
WangJin11

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 More

$25 USD in 1 day
(0 Reviews)
0.0
Ravikishore4092

Working on sql server

$25 USD in 2 days
(0 Reviews)
0.0
Lovesparkmonir

I am sql developer

$25 USD in 5 days
(0 Reviews)
0.0