Comments by Kannan 261190 (Top 11 by date)

<pre lang="sql">

USE <pre lang="sql">HRMS0

Create Table Employee_details_test (employee_id varchar(100),Name varchar(100),Designation_code varchar(200))



insert into Employee_details_test values (&#39;B0001&#39;,&#39;Ramesh.G&#39;,&#39;J0001&#39;),

(&#39;B0002&#39;,&#39;Suresh&#39;,&#39;J0001&#39;),(&#39;B0003&#39;,&#39;Ram.G&#39;,&#39;J0002&#39;),(&#39;B0004&#39;,&#39;Biju&#39;,&#39;J0005&#39;)</pre></pre>



use PER1

Create Table Employee_details_test1 (employee_id varchar(100),Name varchar(100),Designation_code varchar(200))



insert into Employee_details_test1 values ('B0001','Ramesh.G','J0002'),

('B0002','Sures.m','J0001'),('B0003','Ram.G','J0002'),('B000','Biju','J0005')





Now i need a shedular to be RUN in SSIS package to update wat eever Changes happen in Hrms 40 table reflect in perdb table



Example if i do Changes name for B0001 as Ramesh.M in HRMS40 DB , the shedular should automatically do Changes PER1 table Employee_details_test1 against B0001 as Ramesh.M

ex:
1234 = 5000+8000+6000+0+3000+0+0+4000+2000=28000, this amount shouhd come in new Coloumn as [Total]

how to change null values to zero for the amounts for example around 500 employees are there
and we NEED 0 instead of NULL

how to restrict other element which ever not used by any employee id