Sfrgttk

What is formjacking?

Isn't a semicolon (';') needed after a function declaration in C++?

Is it common to refer to someone as "Prof. Dr. [LastName]"?

Given the mapping a = 1, b = 2, ... z = 26, and an encoded message, count the number of ways it can be decoded

Will linear voltage regulator step up current?

Taking an academic pseudonym?

Do error bars on probabilities have any meaning?

Why don't you get burned by the wood benches in a sauna?

How to modify 'inter arma enim silent leges' to mean 'in a time of crisis, the law falls silent'?

Why do we interpret the accelerated expansion of the universe as the proof for the existence of dark energy?

Can I do anything else with aspersions other than cast them?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

Can I combine Divination spells with Arcane Eye?

Found a major flaw in paper from home university – to which I would like to return

Have any astronauts or cosmonauts died in space?

Is it possible to detect 100% of SQLi with a simple regex?

Why is airport car rental so cheap

Why are "square law" devices important?

Why is the meaning of kanji 閑 "leisure"?

How can guns be countered by melee combat without raw-ability or exceptional explanations?

Aligning Systems of Equations

Why Is Image Exporting At Larger Dimensions Than In Illustrator File?

80-bit collision resistence because of 80-bit x87 registers?

Is there any danger of my neighbor having my wife's signature?

Sql Server UNION ALL query

Single sql query to select a record from parent table only if all it's records in child table has valuesReplacement for Nested SELECT statements for every row in SELECT clauseTroubleshooting extremely long running query (SQL Server 2012)split a row into multiple rows in sql server according to a specific columnReplacing isnull condition in where clauseSorting a Date Column in Microsoft SQL Server Management StudioReplacing NULL values in LEFT JOIN with MAX functionUpdate columns with different values depending upon different condition of rows from scd2 type tableStrange query plan when using OR in JOIN clause - Constant scan for every row in tableExclusionary Left Joins

0

I use a UNION ALL query and it outputs 2 rows for the same date. I want to output only 1 row like the second picture.

Do i have to use IIF, CASE or else command?

The date, time_in, time_out fields are output from other table (main_table) and then i use a left join with the following UNION ALL query.

   (select date, time_in, time_out,leave_start,leave_end,leave_type_id, leave_type_descr

   from   table1



   union all



   select date, time_in, time_out,null,null,leave_type_id, leave_type_descr

   from  table2)

sql-server

share

edited 47 secs ago

Mr.Brownstone

9,15932342

asked 7 mins ago

Mike TMike T

433

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How do you decide which leave_type_id takes precedence?
  
  – Mr.Brownstone
  2 mins ago
  
  
  

  
  
  
  

add a comment | 

0

I use a UNION ALL query and it outputs 2 rows for the same date. I want to output only 1 row like the second picture.

Do i have to use IIF, CASE or else command?

The date, time_in, time_out fields are output from other table (main_table) and then i use a left join with the following UNION ALL query.

   (select date, time_in, time_out,leave_start,leave_end,leave_type_id, leave_type_descr

   from   table1



   union all



   select date, time_in, time_out,null,null,leave_type_id, leave_type_descr

   from  table2)

sql-server

share

edited 47 secs ago

Mr.Brownstone

9,15932342

asked 7 mins ago

Mike TMike T

433

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How do you decide which leave_type_id takes precedence?
  
  – Mr.Brownstone
  2 mins ago
  
  
  

  
  
  
  

add a comment | 

I use a UNION ALL query and it outputs 2 rows for the same date. I want to output only 1 row like the second picture.

Do i have to use IIF, CASE or else command?

The date, time_in, time_out fields are output from other table (main_table) and then i use a left join with the following UNION ALL query.

   (select date, time_in, time_out,leave_start,leave_end,leave_type_id, leave_type_descr

   from   table1



   union all



   select date, time_in, time_out,null,null,leave_type_id, leave_type_descr

   from  table2)

sql-server

share

edited 47 secs ago

Mr.Brownstone

9,15932342

asked 7 mins ago

Mike TMike T

433

   (select date, time_in, time_out,leave_start,leave_end,leave_type_id, leave_type_descr

   from   table1



   union all



   select date, time_in, time_out,null,null,leave_type_id, leave_type_descr

   from  table2)

share

edited 47 secs ago

Mr.Brownstone

9,15932342

asked 7 mins ago

Mike TMike T

433

share

edited 47 secs ago

Mr.Brownstone

9,15932342

asked 7 mins ago

Mike TMike T

433

edited 47 secs ago

Mr.Brownstone

9,15932342

edited 47 secs ago

Mr.Brownstone

9,15932342

asked 7 mins ago

Mike TMike T

433

asked 7 mins ago

Mike TMike T

433