I am heavily against the use of functions like this.

Think about...

Here's a simple example

declare @Result integer;

with ctetest

as(

select 1 as Val

)

Select @Result = ctetest.val

from ctetest

Select @Result

You may only use SELECT, INSERT, UPDATE or DELETE with a...

Ankit Mathur-481681 (10/30/2009)

But as you suggested I think I'll have to give a proper thought to table-valued functions too. I wasn't in too much favour of a function coz my...

It simply wont allow you to do that as you are effectively splitting a single statement.

I would suggest capturing the output of the query to a variable an testing...

You could try this. As suggested already converting the stored procedure to a tvf (table valued function) would be a 'better' option.

http://www.sqlservercentral.com/articles/T-SQL/68233/

You will need to play with the order by if you are bothered by which row needs to be returned.

with cteloans

as

(

select l.loanid, l.branchoffice, l.AcquiredFrom,

l.previouslnnum, b.lastname, b.firstmiddlename,

p.addressline1, p.addressline2, p.city,

p.state, p.zip, l.originalamt,

s.primstat,...

You've posted on a 7,2000 , are you using that or a later version.

On 2005+ you can add a row_number() calculation and filter on that.

Dont do it , step away from the cursor.

You dont need one , use correct set based logic.

use rowcnt on sysindexes to pull the rowcount, itll be much faster

-- Stupid suggestion - ignore

you need to ...

ORDER BY Case when language in ('English','Hindi','Punjabi') then 0 else 1 end,language

God damn i need to step away from this, spending far to much time on it

http://ask.sqlservercentral.com/questions/826/the-fifo-stock-inventory-sql-problem

GilaMonster (10/23/2009)

I can't get anything else,...

Or get a statement trace of the same batch executing. Should give you a better idea of which statements to look for....

How are you stopping the loop updating the same rows as the previous iteration ?

Just given this a go...

Commenting doesn't seem to work :crazy:

But deleting multiple batch elements from the BatchSequence element and then saving the file as a .sqlplan and loading in...