did you try it in SSMS 2008? doens't work in 2005, those features are part of the 2008 version.

in a word, yes.

Elliott W (8/24/2009)

---

You could, although it pains me to suggest it, use DB Chaining, and as long as the tables (and I think databases) are owned by the same user...

That's unfortunate. There's no way you can have the user essentially "impersonate" a higher-access user when running that view only? I know with functions you can say "WITH EXECUTE AS...

You're sure that when you inserted that information into the field, you inserted NVARCHAR characters? if you were using a stored proc, the stored proc needs to accept NVARCHAR, not...

Alrighty then, Bob, how? 😛

My view in database B is running a query along the lines of,

SELECT FIELDS

FROM DatabaseB.dbo.Table1

JOIN DatabaseB.dbo.Table2 ON Table1.Column = Table2.Column

...etc...

I don't want to give the user...

should be doable, sure. if you can post the equation in question, then it should be easy enough to apply it to the result set and transform it accordingly. my...

Ravi, a lot of what you're asking, you really should be doing yourself. I mean really, the main purpose of posting here should be to get ideas on how you...

Re-write it such that you're returning all the records on the join, rather than just the MAX record, then use the ROW_NUMBER() function to partition your recordset in a way...

Sorry, there's a better way actually,

What you can do is, insert the records with a NULL value for the foreign key field, and then after inserting, run an update and...

If I understand it right, what you're trying to do is, insert records into a table, and then after inserting the records, update the foreign key field, because you don't...

yeah, lucked out on getting it right, since both of those answers are technically correct.

same as everyone else who got it wrong ... focussed on the varchar and float operations, and totally forgot it was being assigned to an int at the end :/

here's the deal -

what you're trying to accomplish, at least from what i've understood, is really not something you should be doing from a T-SQL level.

T-SQL handles iterative things...

well that's totally different than what you asked. the procedure i gave you isn't going to work for having different items to go with.

you've now got a triple-nested iteration there....