i need help

to search between tow date

start date = dbo.mainb.tarih

end date = dbo.mainb.tarih

----------

and the

start date must to be

GETDATE()+ ' 16:00:00'

and end date

DATEADD([day], 1, GETDATE() ' 16:00:00'

----------

thnks

ilan

wow thnks a lot

the best Forum in the net !!!!

ilan

thnks a lot

ilan

OK it work 100% thnks

question 1

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

but i wont to see in the age field

age like this

----------

"age"

40.6|

39.8|

22.6|

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

question 2

HOW can i round the age after

if the age is big then 41.9...

ok thanks

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

but how can i to create a VIEW

thet one field is the date of born

and a new field thet show the age

like this

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

"date" | ...

OK i workig 100%

thnks

a little question

how can i add more filed to update

like

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

@Fname[nvarchar](50),@fld1 [smalldatetime], @fld2[int],

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

i wont to learn the method

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

declare @na varchar(500), @sisi int, @mmh char(10)

set @sisi='2'

set @mmh='uuu'

select @na =...

no it only update one record not all !!!

i the table [xsisi] i have 100 records

and like this it update only one

not the all 100 "FROM [xsisi]"

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

declare @na varchar(500), @sisi...

ahhhhhhhhhhhhh

evry day i learn something new

thnks a lot

ilan

hi

i get this

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

Server: Msg 170, Level 15, State 1, Line 8

Line 8: Incorrect syntax near '-'.

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

from this line

WHERE (fld1 BETWEEN @fromdate AND @todate) - 1) AND (fld2 = 12)

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

thnks ilan

...

i think i found the answer

----------

SELECT id, Fname, fld2, fld1

FROM dbo.Sn

WHERE (fld1 BETWEEN...

Thank you for your help

ilan

The code work 100%

thnks

------

a another small question ?

How can i use this code

but For Multi DELETE

---------

Thnks

again

ILAN

thnks for the help

ilan

HI I NEED YOUR HELP

what i wont to do is OREDR BY With "@ORDERBY"

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

DECLARE @search VARchar(3000)

DECLARE @scop VARchar(20)

DECLARE @orderby VARchar(20)

DECLARE @sql nvarchar(1000)

set @scop='\'

set @orderby='Rank'

set @search='DOC '

set @sql = 'SELECT TOP...

thanks i fix the problem

in The SCOPE instead of c:then "c:\"

you help my a lot

thnks again

ilan