Dear Sir,
I want to send daily notification mail with mention formats.
How to do this.
| Id |
emp_id |
emp_nm |
dept |
vst_nm |
vst_adhr |
fa_hu_nm |
gndr |
crnt_add |
pur_pos |
emp_out_flag |
cisf_out_flag |
emp_in_flag |
cisf_in_flag |
mrk_in_emp |
mrk_in_cisf |
mrk_out_emp |
mark_out_cisf |
| 7 |
007221 |
D.P. Chakarborty |
IT |
TEST |
123456789123456 |
TEST |
Male |
TEST |
TEST |
N |
YES |
N |
N |
5/5/2022 11:12 |
5/5/2022 11:12 |
NULL |
6/5/2022 11:32 |
| 8 |
008845 |
V.K. Pandey |
IT |
TEST |
123456789123456 |
TEST |
Male |
TEST |
TEST |
N |
N |
N |
N |
5/5/2022 11:15 |
5/5/2022 11:15 |
NULL |
NULL |
| 9 |
071100 |
Shyam Singh |
HR |
TEST |
123456789123456 |
TEST |
Male |
TEST |
TEST |
N |
N |
N |
N |
5/5/2022 11:17 |
5/5/2022 11:17 |
NULL |
NULL |
CREATE TABLE [dbo].[vstr] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[emp_id] NCHAR (10) NULL,
[emp_nm] VARCHAR (100) NULL,
[dept] VARCHAR (20) NULL,
[vst_nm] VARCHAR (100) NULL,
[vst_adhr] NCHAR (20) NULL,
[fa_hu_nm] VARCHAR (100) NULL,
[gndr] VARCHAR (50) NULL,
[crnt_add] VARCHAR (5000) NULL,
[pur_pos] VARCHAR (5000) NULL,
[emp_out_flag] VARCHAR (3) DEFAULT ('N') NULL,
[cisf_out_flag] VARCHAR (3) DEFAULT ('N') NULL,
[emp_in_flag] VARCHAR (3) DEFAULT ('N') NULL,
[cisf_in_flag] VARCHAR (3) DEFAULT ('N') NULL,
[mrk_in_emp] DATETIME DEFAULT (getdate()) NULL,
[mrk_in_cisf] DATETIME DEFAULT (getdate()) NULL,
[mrk_out_emp] DATETIME NULL,
[mark_out_cisf] DATETIME NULL,
[img] VARCHAR (50) NULL,
CONSTRAINT [PK_vstr] PRIMARY KEY CLUSTERED ([Id] ASC)
);
