Comments by ABAKh (Top 21 by date)

I already created job with SQL Agent as it is in the second link that you sent, my question is: Is it possible with SQL Agent to create a job that can execute stored procedure daily on specific time, or if it is not, how to execute stored procedure daily on specific time with MS SQL Server, any answer or suggestion is appreciated. Thanks a lot.

I created it from SQL Server under SQL Server Agent.

I'm waiting your response Mr. ZurdoDev, The way to do this(Code, Guidance, any thing that make me complete this), I appreciate your answer.

Then if i can't do it this way, please explain to me how to do it

This is the code:
DECLARE @AssignToId INT
SET @AssignToId = 0
WHILE (@AssignToId < (select count(distinct AssignToId) from TicketDetails
where ((RespondDate is not null) or (LEN(RespondDate) !=0)) and ((TicketStatusId = 1) or (TicketStatusId = 5)) and RespondDate < DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()+1)) and AssignToId=AssignToId))

BEGIN

select TicketId, TicketDate, ProjectNameEn, RegionNameEn, CityNameEn, AssignToNameEn, PriorityNameEn, CreatedByEmployeeEn, RespondDate, AssignToEmail, AssignToSupervisorEmail, AssignToId
from TicketDetails
where ((RespondDate is not null) or (LEN(RespondDate) !=0)) and ((TicketStatusId = 1) or (TicketStatusId = 5)) and RespondDate < DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()+1)) and AssignToId=AssignToId
order by TicketId

Set @AssignToId = @AssignToId + 1
END

I appreciate your answer, as i knew that in SQL Server there is no load balance cluster, and instead of it there is fail over cluster, the question is, can i configure it while the database is working or before that, i mean on the installation of the database stage. Thank you a lot.

Then tell me how to create a stored procedure from above inserted data to fulfill my task. And I will be thankful

No, I want view to make a report

Other wise I want to create view for table has (equipid,equipName,levelid)
Inserted data will be like:
(1,'a',0),(2,'b',1),(3,'c',1),(4,'d',2),(5,'e',3),...

Yes i have, but i have got no thing. i want some body to tell me so i can communicate with him if i have any doubt. i appreciate your respond.

Hey guys can any body tell me what should i do when i install the project on another computer ?

Thanks alot the first link works ,but the path wont work when i move the project to another computer ,what the solution will be .

I can't change the value of the second row to 2 , because the two rows in the analysis table are rlated to the row in the diagnosis table which has id=1

i appreciate yotr answer but i still getting duplicate fields

i created the view but i got duplicate coulmn fields