We generally adopt an ETL approach and copy our data into 'worktables' created by our multithreaded app. Each thread creates a worktable ( generated by guid ) in a work...

Thanks for the links and your time.. Our com+ object is old school C++ and will shortly be upgraded to c# or vb in the CLR. We will rework the...

Ole is used as the data records are coming from various remote servers which are not able to be linked to our database. The code example here is a specific...

DECLARE @ID CHAR(12)

DECLARE @CharPattern CHAR (71)

SELECT @ID = '40065*01007d'

SELECT @CharPattern = '[-+*][a-zA-Z0-9][a-zA-Z0-9][a-zA-Z0-9][a-zA-Z0-9][a-zA-Z0-9][a-zA-Z0-9]'

BEGIN

IF (ISNUMERIC (SUBSTRING (@ID, 1, 5)) = 1) AND (SUBSTRING (@ID, 6, 7) LIKE @CharPattern collate Latin1_General_BIN )

BEGIN

SELECT @ID...

<<That's really weird>>

Hi Steve... weird indeed ... All the servers are on sp4.. my local server ( on xp ) is sp4 as well and that works fine...

I am guessing that...

You could try this

declare @STR varchar(32)

select @STR  = '0010A'

select reverse(replace(rtrim(replace(reverse(@str),0,' ')),' ',0))

it basically reverses the string, replaces 0's with spaces, trims off the trailing spaces, replaces...

The subject is how to get the last record from a cursor.....

You can declare a scollable cursor and then fetch last

eg..

declare my_cursor SCROLL CURSOR   for select my_attribute from my_table

open my_cursor

fetch last from my_cursor into @my_variable

I has a similar problem a while ago which I think was sorted by picking up the lastest Analysis service pack from microsoft.

http://www.microsoft.com/sql/downloads/2000/sp3.asp?SD=GN&LN=EN-GB&gssnb=1

Try where datediff(dd, [datetime], '2004-06-02' ) = 0

you can also add

[datetime] >=  '2004-06-02'

if you need to pick up an index on datetime

Why not use a case statment to get what you want

ie

select blah blah,

        case @partition

 when 'wk'

  then datediff(wk,printdate,@enddate)

 when  'mm'

  then datediff(mm,printdate,@enddate)

 when  'hh'

  then datediff(hh,printdate,@enddate)

 end

 as part

There is an implicit table for insert or update triggers which contains the records that were inserted.

You can simply do the following

declare @requestor varchar (25)

select @requestor = requestor from inserted

similarly...