1 - You don't need a cursor for this task.

This is the insert statement :

insert into dbo.tArticulos (Articulo, Descripcion, UnidadBase, CosteEstandar)

select Col01, Col02, Col03, Col04, Col05

FROM dbo.tNavisionBuffer Nav

WHERE Col01...

It can be done but I'd strongly suggest adding a few limitations so that this doesn't slow down too much. You'd either have to go with dynamic sql or...

Hey Bull, how you doing .

Inserted contains the value when an insert is done and when an update is done (contains new values)

Deleted...

Thanx, looks like we agree again .

If you have 2 tables, it's not too bad, but as the db grows, you'll see that it's gonna be a pain in the ass to update the same information...

Might also think about making the db case insensitive because all the objects will also be CS which can be a big pain in the ass.

Select * from dbo.CSTable where CSCols like 'Trembley' collate Latin1_General_CI_AS

this will do the search ignoring the case.

Care to send the url of you fav tool .

If the db/table/column are not case sensitive, then 'Trembley' = 'TREMBLEY', so a normal index will do its job.

Nice approach, how would you implement that in an automated manner?

... Or am I missing the point completly?

Just wanted to see if you guys were paying attention .

SET @Adress = (Select Adress from dbo.Adresses A inner join dbo.Persons P ON A.PersonID = P.PersonID where P.FName = 'RG' and P.LName = 'US').

That'll throw an error if you have...

We never said to remove the sp, we suggested you avoid dynamic sql IN THE SP. Can you post the whole code so we can show you how to...

Still a strange problem... looks like you found a bug in the grouping section of the program.

Not really if you show 5 times less data per page.