Click here to Skip to main content
12,816,490 members (34,402 online)
Click here to Skip to main content

Stats

0 views
Posted 26 Jan 2013

SQL Server Query statement

, 26 Jan 2013 CPOL
Check this.SELECT LV_TYPE,LV_TYPE,MIN(FROM_DATE) AS FROM_DATE ,MAX(TO_DATE) AS TO_DATE, COUNT(LVALUEP) AS LVALUE FROM tblLeaveGROUP BY PAYCODE,LV_TYPEPlease try followingSELECT PAYCODE,LV_TYPE, MIN(FROM_DATE) AS FROM_DATE, MAX(FROM_DATE) AS TO_DATE, COUNT('A') AS...

Revisions


  

Compare Revision Minor Date Status Editor
2 - publicly available No 26-Jan-13 6:20 Available Tharaka MTR
update the query
1 No 26-Jan-13 4:16 Available Tharaka MTR

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Tharaka MTR
Technical Lead Eyepax IT Consulting (Pvt) Ltd.
Sri Lanka Sri Lanka
Having more than 9 year hands-on industry experience in software development
Responsible for designing, implementing and managing complex software systems with stringent up-time requirement.

Visit my blog

You may also be interested in...

Pro
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170308.1 | Last Updated 26 Jan 2013
Article Copyright 2013 by Tharaka MTR
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid