Ah - I switched to execute as user, and i see better results now.

Thanks a ton for pointing that out !

Agree. Thankfully this is in the exploratory phase only. For the immediate needs, I am planning to only give individual permissions to select/execute on original dbo tables/SP that i want...

Thanks for the responses guys. For background, we have an application to do some complex calculations on data imported via excel.

Our users want to also safely try "what if" scenarios...

well, we used it mainly for dealing with "Timeouts while executing SP". So far we have modified dozens of SPs (and functions), if not hundreds. It works every single time.

Use local variables to hold the values of the passed parameters. And then use the local variables instead of the passed parameters. This has ALWAYS worked for us in our...

As Dave mentioned - there is no relationship rule given. So it is not possible to come up with the output that the OP is asking for.

But I suspect that...

Thanks guys. I will read up on that.

yup - the nolock is soo much faster...

If you took the time to know how to post queries on this forum, you would know ... Its the link in Gianluca's signature. It explains how people should post...

Please provide scripts to create sample tables.

Looks like home work, but I will oblige. Have not been here for a long while.

Please post queries using format in my signature.

create table #foo(id int, name varchar(200), [state] varchar(90),...

Mr. Magoo,

It works when I use your check, ABS(SARatio - 1)>=0.01.

There are no errors reported (which is correct). And yes, the column is a float.

But I swear I was doing...

Yeah, you did the right test.

This makes it even more wierd.... I am getting the same result as yours when i run in query analyzer.

but instead of table object i...

Here is a sample of the result that I wish to achieve:

TransferID FromInvestorID ToInvestorID TransferRatio StartingBasis ...

If I were you, I would be fixing my app so that it inserts the nulls in the missing columns correctly.

If I were you, and the above was not possible,...