this PROCEDURE run from IIS asp page and the page refresh evry 20 second

maybe ##temp table weel be more good ???

the problem is the delay in the link server

can you...

ok

for start

how to make the  BCP batch file thet copy the data from text file

to table in sql server 

on line

Or

evry 1 second

-------

thnks ilan

how can i  update with this

and put all with the update

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

SELECT

--1<<<<<<<<<<<<<<<<<<<<<<

 [fld1] =  

 CASE

 WHEN  

( select

FROM dbo.main_yoel WHERE (NOT (mafname1 IN (0)))

-if the table is empty THEN...

but how i use CASE on update  thet dependant ON select

-----------

SET columna = CASE

--1

 when @fld1=SELECT na, mafname1

FROM dbo.main_yoel WHERE (NOT (mafname1 IN (0)))

it i a power station

and i wont to show the value ON LINE from the web

and in power station evry second is important

(i need live examples to...

thnks for the advise !

i need good  examples + samples

because i need to do it evry 1 second an read from 4 text file !!!

and i not experienced with BCP and how...

OK it look great but how  to create the FUNCTION

and run it after ???

because it not work !!!!

i wont to run the FUNCTION from a View and create a new Colum

thnks a...

thnks  it work 100%

ilan

How to do it ???

use CASE WHEN

and put it all in one ????

thnks a lot ilan

how to do this

can i get any help o do this

thnks a lot ilan

fix question

1. @Date_from = '31/06/2004'
2. @Date_end  = '01/07/2004'
3. @Time_from = '07:00'
4. @Time_end = '08:00'
5. @fld1= " "

fld_date_from = @Date_from...

hi

this is my problem !

i need to Generate a new Word Documents after the record is insert in  sql server table

with new file name ("doc" or "rtf") and in the word...

How to create function

and use it in my table ?

OR

how can i do it in table

if i have 500000 records

thnks

ilan

thnks

from msdn.microsoft.com

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

LOWER
Returns a character expression after converting uppercase character data to lowercase.
Syntax
LOWER ( character_expression ) 
Arguments
character_expression
Is an expression of character or binary data. character_expression can be a constant,...

thnks it work

100%

ilan