last extracted date and change date

Shambhu Rai 1,021 Reputation points

Hi Expert,

Have loaded data in table for 2 times in a week without date dimension table or last extracted date ... how will i identify last refresh date and current refresh date in sql server

create table emp(employee varchar(23),Age varchar(23),Salary varchar(23))

insert into emp('Test1','23','10')

insert into emp('Test2','25','20')

insert into emp('Tes3','27','30')

User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,008 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,555 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,242 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,171 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 88,621 Reputation points

    If that is all the data you have, the answer is you don't. You will need to arrange for this by adding a datetime column that defaults to sysdatetime() or similar.

    1 person found this answer helpful.