For single result, you could try something like this,

declare @res varchar(50)

set @res=''

select @res=@res+product_name + ', ' from order_item

where orderid = '001234'

select @res

If you need for eatch orderid, develop a function based...

Another way to handle it (in a long run, upgrade may kill the issue) is a window schedule job (at command) to call it.

An insert trigger can handle it.

next login

There is an option in job schedule Start whenever the CPU(s) become idle. It also

depends how long the job runs.

The job will disable itself if sheduled run one time.

Is this the only job get disabled daily? If not, schedule a job to enable it.

select clientID, count(*) from table

group by clientID

having count(*) > 1

Application role is designed for it.

Set @baby_srch_string = ''

WHILE  @int_srch_id IS NOT NULL

BEGIN

  SELECT @baby_srch_string = @baby_srch_string+srch_val +Char(9)

   from ##srch_val

   JOIN srch_elmt_assoc on srch_val_id = srea_sche_id

   Where srch_val_id in (Select srch_val_id from ##Srch_val where srch_val IS NOT Null)

   AND...

select taskid from task a

 inner join assigment b on a.taskid=b.fk_taskid

 where a.status = 1 and datediff(mm, b.ass_stopdate, getdate())>4

Try following

DECLARE @status varchar (10)

SELECT @status = Status FROM tblProfile WHERE uID = @uID

IF @status = 'live' 

     INSERT INTO tblResult

     (uID, Location, Status)

     Values

     (@uID, @Location, @status)

Article PSS ID Number: 268481 discribes the same error. Check it out.

Charindex has start_location argument.

In your case the statement would be

select charindex('[', col, charindex('[', col)+1) from table2

assume col is the name of the column.

False, null, null, null works for me.

If worksheet is OLS, would it be

select * from ExcelSource...OLS$

Agree with you.

Have you tried "False, Null, Null, Null", it may well be the case.