1. Главная
2. SKRT_DATA_MUSIC

CREATE FUNCTION GetEmployeesHiredInDateRange (@StartDate DATE, @EndDate DATE)
RETURNS TABLE
AS
RETURN
(
SELECT
e.EmployeeID,
e.FirstName,
e.LastName,
e.Email,
e.HireDate,
e.DepartmentID
FROM
Employees e
WHERE
e.HireDate BETWEEN @StartDate AND @EndDate
);

-----------------------------------------------

CREATE PROCEDURE ProcessEmployeeData
@StartDate DATE,
@EndDate DATE,
@DepartmentID INT
AS
BEGIN
-- Step 1: Get employees hired in the date range using the table-valued function
DECLARE @TempEmployees TABLE (
EmployeeID INT,
FirstName NVARCHAR(50),
LastName NVARCHAR(50),
Email NVARCHAR(100),
HireDate DATE,
DepartmentID INT
);

INSERT INTO @TempEmployees
SELECT * FROM GetEmployeesHiredInDateRange(@StartDate, @EndDate);

-- Step 2: Create a temporary table to store processed data
CREATE TABLE #ProcessedEmployees (
EmployeeID INT,
FullName NVARCHAR(101),
Email NVARCHAR(100),
HireDate DATE,
DepartmentName NVARCHAR(100)
);

-- Step 3: Insert data into the temporary table with additional processing
INSERT INTO #ProcessedEmployees (EmployeeID, FullName, Email, HireDate, DepartmentName)
SELECT
e.EmployeeID,
e.FirstName + ' ' + e.LastName AS FullName,
e.Email,
e.HireDate,
d.DepartmentName
FROM
@TempEmployees e
INNER JOIN
Departments d ON e.DepartmentID = d.DepartmentID
WHERE
e.DepartmentID = @DepartmentID;

-- Step 4: Select data from the temporary table to return the result
SELECT * FROM #ProcessedEmployees;

-- Step 5: Clean up the temporary table
DROP TABLE #ProcessedEmployees;
END;
FUNCTION GetEmployeesHiredInDateRange (@StartDate DATE, @EndDate DATE)
RETURNS TABLE
AS
RETURN
(
SELECT
e.EmployeeID,
e.FirstName,
e.LastName,
e.Email,
e.HireDate,
e.DepartmentID
FROM
Employees e
WHERE
e.HireDate BETWEEN @StartDate AND @EndDate
);

-----------------------------------------------

CREATE PROCEDURE ProcessEmployeeData
@StartDate DATE,
@EndDate DATE,
@DepartmentID INT
AS
BEGIN
-- Step 1: Get employees hired in the date range using the table-valued function
DECLARE @TempEmployees TABLE (
EmployeeID INT,
FirstName NVARCHAR(50),
LastName NVARCHAR(50),
Email NVARCHAR(100),
HireDate DATE,
DepartmentID INT
);

INSERT INTO @TempEmployees
SELECT * FROM GetEmployeesHiredInDateRange(@StartDate, @EndDate);

-- Step 2: Create a temporary table to store processed data
CREATE TABLE #ProcessedEmployees (
EmployeeID INT,
FullName NVARCHAR(101),
Email NVARCHAR(100),
HireDate DATE,
DepartmentName NVARCHAR(100)
);

-- Step 3: Insert data into the temporary table with additional processing
INSERT INTO #ProcessedEmployees (EmployeeID, FullName, Email, HireDate, DepartmentName)
SELECT
e.EmployeeID,
e.FirstName + ' ' + e.LastName AS FullName,
e.Email,
e.HireDate,
d.DepartmentName
FROM
@TempEmployees e
INNER JOIN
Departments d ON e.DepartmentID = d.DepartmentID
WHERE
e.DepartmentID = @DepartmentID;

-- Step 4: Select data from the temporary table to return the result
SELECT * FROM #ProcessedEmployees;

-- Step 5: Clean up the temporary table
DROP TABLE #ProcessedEmployees;
END;

play_arrow

321

13

00:00:00

8 Distortion Pedal screw around-yes I turn them all on at the same time

play_arrow

4,609,147

332 тыс

Telegram Ke Ye Secret Features Aapko Pata Nhi Honge⚡️

play_arrow

562,700

948

120 Minutes of Mailtime Moments w/ Mailbox & Blue 📬 | Blue's Clues & You!

play_arrow

347

6

АХБОР 16 07 2024

play_arrow

377

3

C# Basics - Hello World

play_arrow

1,208

30

Мондьоринг 2. Евгений Славков и малинуа Классик Аллерт Вардруна. Гран-При ЧР2022. 234б.

play_arrow

358

18

Mein neues " Stefan Mattner " Outdoormesser / Custom Messer / Custom knife

play_arrow

14

1

UiPath training in 30 days UiPath developer in 30 days |