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