Monday, 9 June 2025

User 1 has not site compare to user 2

 SELECT Site_Location 

FROM tbl_Users 

WHERE User_ID = 'sboissinot' 

AND Site_Location NOT IN (

    SELECT Site_Location 

    FROM tbl_Users 

    WHERE User_ID = 'swoodhouse'

)


at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

c#

 https://github.com/dcyuksel/Result

  • wrap text in excel
     if text length big make it next line shorcut is ALt+Enter or cilck on wrap text
  • interview Harsco(enviri)
     Points 1.complex page layouts and adherence to code standards. 2.primeNG pagination 3.ngcontent 4.ngdestory(memorylekage) 5.datatransfer wi...
  • Duplicate records find and delete
     Check duplicate count based on 3 columns combo select EMPID,FORMinfoID,FormName,Count(*) as counts from tbl_FilesMigrationLogs  group by Em...