Find Jobs
Hire Freelancers

create ms sql query

$10-30 USD

Completed
Posted about 5 years ago

$10-30 USD

Paid on delivery
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)"
Project ID: 18987892

About the project

9 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 right away for you. Please don't hesitate to contact me for more information. Kind Regards Steven
$25 USD in 1 day
5.0 (3 reviews)
2.1
2.1
User Avatar
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 person which you are looking for. I have done many experience years in projects just like this, feel free to chat with me and we will get the right price and a perfect job I am waiting for your response.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
9 freelancers are bidding on average $23 USD for this job
User Avatar
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 discuss further. My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$30 USD in 1 day
5.0 (30 reviews)
4.9
4.9
User Avatar
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
5.0 (3 reviews)
1.7
1.7
User Avatar
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
5.0 (3 reviews)
1.4
1.4
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
​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.0 (0 reviews)
0.0
0.0
User Avatar
Working on sql server
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am sql developer
$25 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Davenport, United States
4.9
456
Payment method verified
Member since Jan 3, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.