Advanced Search

Return to Snippet

Revision: 45193
at April 27, 2011 04:00 by kashif21
Initial Code 
SET @dtmToDate = DATEADD(DD, 1, @dtmToDate)
SELECT TOP (@intMaximumRowsToReturnOnGrid)
	SysUserAuditID,
	LoginName,
	LoginDatetime,
	IPAddress,
	CASE IsAuthenticated
		 WHEN 1 THEN 'Yes'
		 ELSE 'No'
	END AS IsAuthenticated
FROM
	AuditLogin 
WHERE
	(@strUserName = '' OR LoginName LIKE '%' + @strUserName + '%')
	AND LoginDateTime >= @dtmFromDate AND LoginDateTime <= @dtmToDate
Initial URL 









Initial Description














Initial Title





A solution for the date comparison plus same date









Initial Tags














Initial Language





SQL