Concluído

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

Habilidades: Microsoft SQL Server , SQL

Veja mais: 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

Acerca do Empregador:
( 427 comentários ) Davenport, United States

ID do Projeto: #18987892

Concedido a:

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 Mais

$25 USD em 1 dia
(2 Comentários)
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 Mais

$15 USD em 1 dia
(0 Comentários)
0.0

10 freelancers estão ofertando em média $23 para esse trabalho

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 em 1 dia
(3 Comentários)
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 em 1 dia
(2 Comentários)
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 Mais

$30 USD em 1 dia
(1 Comentário)
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 em 1 dia
(0 Comentários)
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 em 1 dia
(0 Comentários)
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 Mais

$25 USD em 1 dia
(0 Comentários)
0.0
Ravikishore4092

Working on sql server

$25 USD in 2 dias
(0 Comentários)
0.0
Lovesparkmonir

I am sql developer

$25 USD in 5 dias
(0 Comentários)
0.0