That one works fine.

Thanks a lot.

I also want to count the id column grouping by zip and then do the "split".

so we had

12345

23456

23456

23456

23456

12456

12456

12456

33456

22456

44456

55556

we make it

12345 1

23456 3

12456 3

33456 1

22456...

Table structure:

create table tblTempZips (zip Varchar(5) null, id int primary key IDENTITY (1,1) not null )

Sample Data:

insert into tblTempZips

(zip )

values

('12345')

insert into tblTempZips

(zip )

values

('23456')

insert into tblTempZips

(zip...

Thanks for your reply

My problem is not only the id's but also the rest data. I need 4 fields one is the id the other is info1 the other...

In the proc.

I can handle it from the app but the point is not there.

You don't have to apologize.You did not confuse me at all.It was very clear that the "error" did not came from sql but from the registration. I didn't know...

sjcsystems was right. I ran DCOMCNFG at the applications list i select my com component then i click properties and at the security tab i choose use custom access permissions,use...

When i instanciate the com from another vb project works fine.Either early bound or late bound.I am checking now if i can do it throught .net and when i build...

Hi,

There is a way you can restore a database up to second BUT first your recovery model must be set in Full. If you had selected Full you can proceed

Fisrt...

Hi,

There is a way you can restore a database up to second BUT first your recovery model must be set in Full. If you had selected Full you can proceed

Fisrt...