Færdiggjort

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

Evner: Microsoft SQL Server, SQL

Se mere: 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

Om arbejdsgiveren:
( 427 bedømmelser ) Davenport, United States

Projekt ID: #18987892

Tildelt til:

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 Flere

$25 USD på 1 dag
(2 bedømmelser)
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 Flere

$15 USD på 1 dag
(0 bedømmelser)
0.0

10 freelancere byder i gennemsnit $23 på dette 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 på 1 dag
(3 bedømmelser)
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 på 1 dag
(2 bedømmelser)
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 Flere

$30 USD på 1 dag
(1 bedømmelse)
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 på 1 dag
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
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 Flere

$25 USD på 1 dag
(0 bedømmelser)
0.0
Ravikishore4092

Working on sql server

$25 USD in 2 dage
(0 bedømmelser)
0.0
Lovesparkmonir

I am sql developer

$25 USD in 5 dage
(0 bedømmelser)
0.0