mobasha (3/11/2008)
thanks.do any one have a solution if i need to run this select every 2 seconds?
i have been trying but am stuck in a dead end.
Well, this does what you asked for, but probably is not what you want:
While (1=1)
BEGIN
Waitfor Delay '00:00:02'
{your query's}
END
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]