Click here to Skip to main content
15,915,093 members

Comments by Member 10229796 (Top 17 by date)

Member 10229796 12-Feb-15 7:42am View    
if give between '2013-100' and '2013-102'
it display like
2014-1000
2014-1010
2014-1011
2013-1012
2013-1013
2014-1016
2014-1017
2014-1018
2014-1019
Member 10229796 12-Feb-15 7:27am View    
select ES_LIBRARY_ID as ES_BAR_CODE from es_library_user where ES_LIBRARY_ID IS NOT NULL and ES_LIBRARY_ID between '2014-100' and '2014-1029'
Member 10229796 29-Jan-15 10:55am View    
sir this table related library visitors.visitor can visit number time in day.each time visitor visited to library i can maintain data in the table. but i want display to report total visitors uniquely each day
Member 10229796 29-Jan-15 10:04am View    
sir this table related library visitors.visitor can visit number time in day.each time visitor visited to library i can maintain data in the table. but i want display to report total visitors uniquely each day
Member 10229796 29-Jan-15 9:58am View    
sir this is actual query

select lv.ES_DATE,lv.es_user_name,lv.ES_USER_TYPE,d.ES_DEPT_NAME,lv.ES_SYSTEM_NO,lv.ES_IN_TIME from ES_LIBRARY_VISITORS lv
left join ES_DEPARTMENTS d on d.ES_ID=lv.ES_DEPT_ID
where ES_BRANCH_ID=1 and CONVERT(VARCHAR(10), lv.ES_DATE, 111)
between '2013/10/18' and '2013/10/18' and lv.ES_USER_TYPE='Student' and lv.ES_DEPT_ID='3'
order by case lv.ES_USER_TYPE when 'Student' then 1 when 'Employee' then 2 else 3 end,
lv.ES_SYSTEM_NO