hi

SET NOCOUNT ON

should do the trick

Paul

if you look under return in BOL it says the following :-

"The RETURN statement unconditionally terminates a query, stored procedure, or batch. None of the statements in a stored procedure...

hi,

the SQL 7.0 SP4 version is 7.00.1094 for MS03-031

Paul

Hi,

just use :-

update ITEM

set CTLG_NO = replace(CTLG_NO,'4133','5555')

instead (see replace in BOL for an explanation)

Paul

hi,

try http://support.microsoft.com/default.aspx?scid=kb;en-us;811889

as a starting point

Paul

hi,

shouldn't it be :-

update ITEM

set CTLG_NO = replace(CTLG_NO,'41331111','55551111')

from 41331111 to 55551111 ?

Paul

hi,

for a quick, one off update you could try the following :-

select substring("41CP52RBILL AD00043310 2003-07-032Ingenium", charindex("-", "41CP52RBILL AD00043310 2003-07-032Ingenium",0) -4 ,10)

(replacing the values in quotes with your...

in 2000 databases can now have their own collation orders (known as sort order in 7.0)

this error occurs when you join character fields between 2 databases with different collation orders....

sorry, bit too quick there, it's s self join. This effectively is two copies of the base table so you can do something like

"AND t1.DateField < t2.DateField"

t1 and t2 are aliases for mytable1 and mytable2

Hi,

you could set rowcount to 1

and then delete based on the unique identifier, ordered by date. This was delete the earlier one and leave the later one. (don't forget to...

have you upgraded your client tools to SQL 2K ?

hi,

the select should be :-

SELECT SUBSTRING(col1, 6, (CHARINDEX(' ', col1, 6))-6)

-- take the substring from 6th character till the first space after 6th character

FROM pgr_profiler

where col1 like 'exec...

we had some encrypted procedures in a production system for a while. However when it came to troubleshooting it became a pain, as we couldn't be 100% sure of the...

hi,

use the substring function:-

SUBSTRING(hour, 1, 2) will return "08" etc ...

Paul