my last question

how can i insert multy insert ?

like this

select 15,getdate(),user, *

 from tb_parts

 where sn = '3456,888,9999,8765,55,56,57'

TNX

it working !!

thanks to you all

my problem  happen because of old sql server 2000 residue

i remove all the old sql server 2000

i restart my computer and it working

tnx...

yes i am use sql server 2005 sp2

help

the problem is on the " trigger " only

this is the error

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

Msg 156, Level 15, State 1, Procedure Incorrect syntax near the keyword 'with'

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

my question is what is...

TNX

ineed help

the problem with my sql server 2005 SP2 is on this

the error i get i whan i  run the "trigger tr_new_tb_i "

Msg...

HI TNX

i have problem winth sql server 2005 Incorrect syntax

1

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

Create

trigger tr_new_tb_i on

someone can halp

TNX

yes i need to

select from TB_PARTS field s=sn,fld1,fld2,fld3,fld4

and insert to NEW_TB field s=new_number,new_date,user,sn,fld1,fld2,fld3,fld4

and get in table "NEW_TB" 20 rows

to "Jeff Moden " the SN...

all the examples above are with "Incorrect syntax"

but my problem is how can i do it

like this

select 1 item from my TB_PARTS

(TB_PARTS 

i test it it working

thank for all wonderful people here

is it possible to make all this as a "SQL Functions"

and use it inside select view

tnx for all

hi

need halp

sorry i dont explain ok

i dont wont a duplicated value  to be exist !

so that the user canot select the same value from the  six listbox

so the user can...

hi TNX

but i get an error whan i copy

all the big text !!!

can you fix it

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

Server: Msg 170, Level 15, State 1, Procedure fnSplit_Set, Line 13

Line 13: Incorrect syntax near...

ohhhhhhhhhhhhhhh

very slowly

Is there simple way to do it ?????

TNX