I want to create a stored procedure in SQL Server2012
well thats good,,, i have wrote many stored procedures to work this problem out but none of them worked
the stored procedure has to do the following
Select all rows of a coloumn(date as data type) if any one of the row matches the current datetimestamp
then select id of that row and then perform some other operations
I need this stored procedure to run daily
Urgent help needed
I need this stored procedure to run daily
Urgent help needed
Khan Abrar AhmedPosted Apr 13, 2014, 7:31 AM
for examlpe
CREATE PROCEDURE P_get_Data
AS
begin
DECLARE @CurrentDate DATE =CAST(GETDATE() AS DATE)
SELECT * FROM dbo.WUSers AS wat WHERE DateCreated=@CurrentDate
end
after creating the store procedure then create a daily job to call store procedure.