Ok, i would create a new stored procedure that does your update that would be something like this:

create procedure usp_updateItems

(

--input parameter are put here

)

as

--local variables

DECLARE @PREFIX VARCHAR(6)

DECLARE @CODE VARCHAR(8)

DECLARE @PARENTGUID...

i don't know what the stored procedure usp_itemsdb_insertgroup does. You have partguid as input parameter so the stored procedure would look something like this:

update table x

set guid=@guid,code=@code

where parentguid=@parentguid

then in you...

Hi did also a test on my development pc (p3 128 mb ). The table has 2 milion rows response times for both queries < 1 ms. There is a...

I must have misunderstood i thought that the case studie where being brought back to live and that they where not being read. About working on one , i have...

Hi see also the cursor select definition i changed

SELECT PART,DIGIT FROM Proactis_Custom.dbo.parts

Hi, if i understandcorrectly you have to change the following lines:

DECLARE @PREFIX VARCHAR(6)

DECLARE @CODE VARCHAR(8)

DECLARE @GUID UNIQUEIDENTIFIER

DECLARE @PARENTGUID UNIQUEIDENTIFIER

DECLARE @PART VARCHAR(50)

DECLARE @DIGIT VARCHAR(4)

--SELECT @PART = PART FROM PROACTIS_CUSTOM.DBO.PARTS

--SELECT...

nice article , i wish i had dynamic properties in sql 7. You can also start a dts package from a job , you can use the same technique...

I suggest not to use cursor in a trigger because it could have severe performance impact.

try using openrowset , there you get put the connection info . see sqlserver books online (bol) for more details

great article it gives me a good start on using perl. I have one question is it also posible to create a dsn less connection. This makes it easier to...

Hi, i tink you don't need a view you can directly use the recordset you create in the stored procedure.

for example

you have this stored procedure:

create usp_test

(

@name varchar(50)

)

as

select * from authors

where...

I think using dts is the easist solution. With the copy database wizzard you can create dts package that does this for you. This package can be scheduled to run...

Yes the sql language is the same. Only the data in tables could be different.

A set does not return a result a select does.

just add an orderby on the datecolumn something like this

select count(distinct(performed_by_userid)) as no_users,

convert(char(12),datecol,106) as auditdate

from tablename

group by convert(char(12),datecol,106)

order by datecol