Popular Posts

  • Backup Plans for Data Loss
    SQLServerCentral » Latest topics Backup Plans for Data Loss Comments posted to this topic are about the item [B] Backup Plans for D...
  • Asymmetric Processor Cores
    SQLblog.com - The SQL Server blog spot on the web Asymmetric Processor Cores Most Intel processors use one of two cores, the main-l...
  • A New New World
    SQLServerCentral » Latest topics A New New World Comments posted to this topic are about the item [B] A New New World [/B] more in...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Monday, November 13, 2017

CASE statement and inner join giving duplicates

SQLServerCentral » Latest topics
CASE statement and inner join giving duplicates
Dear DBAs
I am using a CTE to get terminal locations from one table and then joining this CTE with 2 more tables to get the time and attendance from those tables.
The results appear fine when i use 2 tables but as soon as i join the CTE to the m
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)