thnks but how can i insert

80000 records

and loop the insert ???

ilan

not work !!

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

CREATE TABLE [tblTest] (

 [YEARVAL] [smallint] NOT NULL CONSTRAINT [DF_tblXXX_YEARVAL] DEFAULT (datepart(year,getdate())),

 [AUTONUM] [int] IDENTITY (1, 1) NOT NULL ,

 [ValX] [char] (1) NOT NULL ,

 CONSTRAINT [PK_tblTest] PRIMARY KEY  CLUSTERED ,

 ...

problem with the code

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

CREATE TABLE [tblTest] (

 [YEARVAL] [smallint] NOT NULL CONSTRAINT [DF_tblXXX_YEARVAL] DEFAULT (datepart(year,getdate())),

 [AUTONUM] [int] IDENTITY (1, 1) NOT NULL ,

 [ValX] [char] (1) NOT NULL ,

 CONSTRAINT [PK_tblTest] PRIMARY KEY  CLUSTERED...

i have a little   problem

i wont to add this(the new) Column

 to table  thet i use  thet have records !!!

and i have one IDENTITY Column with AUTONUM

i wont  new evry year

to start from from 1

but like this

in start of the year 2003

1-2003   2-2003 ......................................................................99999-2003

and in the start of the year 2004

like this

1-2004   2-2004 ......................................................................99999-2004

and evry new...

And what abut the auto number from the beginning of the year that  

I wont that the number start from 1

until...

And what abut the auto number from the beginning of the year that  

I wont that the number start from 1

until...

 How can i make auto number from the first day of the year?

How can I make this?

From the binging of the year

watch this it work like this !!!

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

DECLARE

@sqlCmd NVARCHAR(1000),

@mh-2 VARCHAR(10),

@mha VARCHAR(50)

SET @mh-2 = '1'

SET @mha = 'WHERE mhlkot.mhlka_id IN ('+

ok

----------

in siloke =(59 row(s) affected)

and in

mhlkot= (10 row(s) affected)

-----------

ilan

Pardon me

it is ok the code

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

thnks

ilan

still an error

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

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

Line 1: Incorrect syntax near 'mhlkot'.

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

thnks

ilan

thnks but i get an error

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

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

Line 11: Incorrect syntax near 'sp_executesql'.

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

ilan

this

---------------------------------------------FNAME MHLKA SOG COUNT_ID

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

BOB-MILER DEP...

thnks it work 100%

ilan