hi

can i get  help on  my Stord procedures  ??????????

thnks

ilan

i wait for the answer !!!!!!!!!!!!!!!!

do you have a good example for run this job

thnks

ilan

need more help

how to do it ??????????

 create function to Replace text from table

in   field type TEXT

thnks ilan

i is not ok

my problem is this

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

--1----v-1-----------

UPDATE [pitable].[dbo].[allpi]

SET val1 = (SELECT *

FROM OPENQUERY(pcnh, 'SELECT value as ro1    FROM picomp  WHERE time = date(''*'') AND tag = ''rt1mp001''

'))

--2----v-2-------

UPDATE [pitable].[dbo].[allpi]

SET...

how can i do this

select

CASE

SELECT *

FROM OPENQUERY(pcntn, 'SELECT value as val ,''UNIT1''as uu ,''FF9900'' AS col FROM picomp WHERE time = date(''*'') AND tag = ''a1mp340''

thnks but thre is a problem

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

Server: Msg 14295, Level 16, State 1, Procedure sp_verify_jobschedule, Line 57

Frequency Type 0x2 (OnDemand) is no longer supported.

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

can i to force the JOB to do this

thnks ilan

i dont understanding what is the problem of microsoft so thet i can run job evry 20 second ????

no way to manual do it from Transact SQL ????

thnks ilan

ops ................

no i need it for my web site for live data

any idea how ????????????????