I have no idea why the PRint returns a 6, but the select should return a 0 because sp_executesql completed successfully. If you want to return the return value...

There has to be some major differences in the Query plan when returning data from the view. I'm surprised that the TOP operator speeds things up as according to...

You can use sp_executesql. Something like this which is from another forum post, bust should give you an idea:

Declare @sql nvarchar(max), @params nvarchar(100), @Retval Int

Set @sql = 'SELECT @Rows...

Grant,

Glad I didn't mention what you aren't supposed to mention. I'm not planning on going to PASS this year, but I probably will start saving up for next year...

The few I have gotten I have responded.

I got one today that the guy was clearly impatient as he had posted the same question in 2 forums already....

Is the LenderId table a mapping table to a master LenderID?

Based on your answers I would just let the user pick the Lender by name and my query would be...

Not that I am aware of. I also believe the Resource Governor limits, but does not boost. I could be wrong though.

The error is telling you exactly the problem you need to move the nested table into a group row not the detail row. You can't nest data regions inside...

Is LenderID character or numeric? Are the names the same for the "duplicate" lenders? Are you using 2000 or 2005? How are the LenderId's being entered? ...

blnbmv (8/6/2008)

So you mean to say cursor and while both take temp tables and also you said that you wont do like that then can pls explain me how you...

There is ALWAYS a transaction, you just don't have an explicit transaction. If the posted code is really the only code being run in the process then I don't...

I don't know of any other way to convert that format string to datetime. If you have some way to limit the # of inserts through a join or...

It looks like this is like the public database role. Every user that is granted rights to the server is put in the public server role. On my...

As Steve said and I said in my earlier post, if you give us the problem we may be able to solve it using a set-based solution that will be...

Here are a couple of comments. Instead of:

DECLARE @sql nvarchar(max),

@SFound int

SET @SFound = (SELECT COUNT(*) FROM...