add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
id name quantity delivery status
1 Omer 124 2022-10-18 00:00:00.000 0
2 Jacob 548 2022-11-05 00:00:00.000 0
4 Hans 548 2023-11-01 00:00:00.000 0
(No column name)
Hello, Omer todays order quantity 124 this order must be sent by the latest 18.10.2022.
Hello, Jacob todays order quantity 548 this order must be sent by the latest 05.11.2022.
Hello, Hans todays order quantity 548 this order must be sent by the latest 01.11.2023.
Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}.

Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}.
select name,quantity,format(delivery,'dd.MM.yyy') as [delivery] from message where status=0

(No column name)
replace(@template,'{{id}}',id)
replace(@template,'{{name}}',name)
replace(@template,'{{quantity}}',quantity)
replace(@template,'{{delivery}}',delivery)
replace(@template,'{{status}}',status)
id (No column name)
1 Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}.
1 Hello, Omer todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}.
1 Hello, {{name}} todays order quantity 124.00 this order must be sent by the latest {{delivery}}.
1 Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest 18.10.2022.
2 Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}.
2 Hello, Jacob todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}.
2 Hello, {{name}} todays order quantity 548.00 this order must be sent by the latest {{delivery}}.
2 Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest 05.11.2022.
4 Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}.
4 Hello, Hans todays order quantity {{quantity}} this order must be sent by the latest {{delivery}}.
4 Hello, {{name}} todays order quantity 548.00 this order must be sent by the latest {{delivery}}.
4 Hello, {{name}} todays order quantity {{quantity}} this order must be sent by the latest 01.11.2023.