Database Query Help

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 428,570 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,626 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser: Programming Forums

Database Query Help

•

Join Date: Jun 2007

Posts: 2

Reputation: mniece is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

mniece

Offline

Newbie Poster

Database Query Help

Jun 2nd, 2007

I appreciate your reply. However, that query is identical to what I've tried and it returns back all the records from the status table for a given group. The idea is to only get the latest, singe record for each application.

The example above actually had a mistake in it. The ideal returned query would show this:
STAT_ID STAT_TM STAT_DSC APPL_ID APPL_NM GRPS_ID
-------------------------------------------------------------------------------
3 4:15pm "OK" 1 "Script 1" 1
5 4:15pm "FAILED" 2 "Script 2" 1

-Michael

Last edited by mniece : Jun 2nd, 2007 at 6:47 am.

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Statistics

Members: 428,570

Users Online Now: 4,626

Active IRC Users: 29

Forum Threads: 136,780

Forum Posts: 694,270

Code Snippets: 906

Blogs: 149

Blog Entries: 2,305

Directory Links: 566

DaniWeb Home > Forums > Web Development > Databases > MS SQL > Database Query Help

Database Query Help

Database Query Help

Database Query Help