Update x set x.a = Z.Code from TableX X inner join

(select code from openquery(select b,c,code from table y)) z

on z.b = x.b and

z.c = x.c

in the form source use dbo.ProcedureName

and in input parameters : Forms!myform!mytextbox

then separate each parameter with a comma.

What is the question?

I'll let this sink in before I show you the set-based solution.

You might consider it seriously if this report is run very often.. or if the in list is very...

Then I guess that the problem comes from the employes list... can we see how you populate that variable?

You can't have a parameter in a view so no... By I suspect another problem. What error r u getting from sql server? Or Are you just not...

SET ANSI_NULLS ON

GO

SET ANSI_WARNINGS ON

GO

CREATE PROC A

AS

Select null

GO

This will run much faster (the longer the list, the faster) :

Declare @list varchar(200)

set @list = '688,708,87,88'

Select * from Employees

where empID in (Select Element from dbo.Split(@list, ','))

CREATE FUNCTION [dbo].[Split]...

if intMemberId"" then

strSql="select tblEvent.EventID as EventID,tblEvent.Event as Event,tblEventCategory.EventCategory as EventCategory,tblEvent.EventDate as EventDate,tblEvent.EventToDate from tblEvent,tblEventCategory where MemberId=" & intMemberId & _

"and tblEvent.EventCategoryCode=tblEventCategory.EventCategoryCode...

Can we see the cursor code... I'd like to give a shot at the set based approach.

Tx Frank... Still a long way from catching you.

If you don't add any indexes then yes. But it's said in the bol that the only garantee to have the order by stay the same is to specify...

HTH.

And here's post #1000 <<<<<<<<<<<<<<<<<<<

Ya.. gives something to dream about and keep learning more about sql server... Maybe it's gonna be my turn someday .

In this case this will correct your query and should give you what you need :

CASE WHEN datepart(m, tblInvoiceMaster.invoice_date) = 5 THEN net_amt_due ELSE 0 END as soldmay,

SUM(CASE WHEN...