Kevin (6/4/2008)

---

The question I have is WHat if you have some tables that have a With(NOLOCK) hint on them that are joined to tables that do not have the NOLOCK...

Sounds a lot like homework... don't mind helping, but let's see what you've tried... also, take a look at the URL in my signature... you'll get a better answer quicker...

I've not seen...

Ok... I'll try to be gentle even with an attitude like that... 😉

You haven't provided enough information... why do you...

noeld (6/3/2008)

---

The use of a "central" table to get_nextID is not that hard and is "portable". Of course it will never get closer to the simplicity of an identity column....

THAT's why I sometimes get a bit angry with the folks that insist that everything must be done on the client side... server spends more time piping stuff over the...

Hmmmm.... that food for thought. I'm gonna have to make an SP in master that does an update on sysProperties and label it as a system proc... it will...

Heh... or like my old DBA used to say... "Got resources? Use 'em!" 😛

Heh... they asked for data and table over there, too! Somebody eventually did it for him, though.

Glad you got an answer, Jack. And, I agree... Dense_Rank...

Agreed! You do have to be a bit "pipe" sensitive...

Heh... you should see how a Cursor or While loop pans out... thin lines aren't always a good thing on the execution plan... 🙂

Yep... I understand that... but why does it work in SQL Server 2000? What is it that allows sp_AddExtendedProperty to add a row to sysProperties without, apparently, having to...

sqluser (5/29/2008)

---

Hi all,

Is it possible to use Dynamic Query in UDF?

If yes, tell me how to...

Jack,

Could you post some data in the form identified in the article in the URL listed in my signature, please? It'll help us give you a correct answer more...

Heh... thanks for the plug, Jason.

Stk, if you can, you should probably avoid the many forms of recursion. Recursion is a form of hidden RBAR that's not much better...