Viewing 15 posts - 13,051 through 13,065 (of 18,923 total)
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...
September 21, 2005 at 6:36 am
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...
September 21, 2005 at 6:29 am
Hey Bull, how you doing
.
Inserted contains the value when an insert is done and when an update is done (contains new values)
Deleted...
September 20, 2005 at 3:19 pm
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...
September 20, 2005 at 2:41 pm
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.
September 20, 2005 at 2:38 pm
Select * from dbo.CSTable where CSCols like 'Trembley' collate Latin1_General_CI_AS
this will do the search ignoring the case.
September 20, 2005 at 2:28 pm
Care to send the url of you fav tool
.
September 20, 2005 at 2:24 pm
If the db/table/column are not case sensitive, then 'Trembley' = 'TREMBLEY', so a normal index will do its job.
September 20, 2005 at 2:21 pm
Nice approach, how would you implement that in an automated manner?
... Or am I missing the point completly?
September 20, 2005 at 2:03 pm
Just wanted to see if you guys were paying attention
.
September 20, 2005 at 1:57 pm
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...
September 20, 2005 at 1:56 pm
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...
September 20, 2005 at 12:58 pm
Still a strange problem... looks like you found a bug in the grouping section of the program.
September 20, 2005 at 12:03 pm
Not really if you show 5 times less data per page.
September 20, 2005 at 11:56 am
Viewing 15 posts - 13,051 through 13,065 (of 18,923 total)