Advanced Search

A solution for the date comparison plus same date

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SET @dtmToDate = DATEADD(DD, 1, @dtmToDate)
  2. SELECT TOP (@intMaximumRowsToReturnOnGrid)
  3. 	SysUserAuditID,
  4. 	LoginName,
  5. 	LoginDatetime,
  6. 	IPAddress,
  7. 	CASE IsAuthenticated
  8. 		 WHEN 1 THEN 'Yes'
  9. 		 ELSE 'No'
  10. 	END AS IsAuthenticated
  11. FROM
  12. 	AuditLogin 
  13. WHERE
  14. 	(@strUserName = '' OR LoginName LIKE '%' + @strUserName + '%')
  15. 	AND LoginDateTime >= @dtmFromDate AND LoginDateTime <= @dtmToDate

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.