aargh, missed the point with the function.

Sorry about that!

Like NPeeters said it won't work. After executing your statement your variable is out of scope. So you...

Hi lenardd,

quote:

---

How would you code something like this in Dynamic SQL? I basically want to grab the value of the field...

quote:

---

When somebody else is spending the money, well I suppose there is nothing you can do. Often though if you present a...

quote:

---

20 minutes to figure that one out! Snitz, gotta love it. You have to insert rows into the subscripion table. Why would...

quote:

---

Kindly do not suggest normalising the table(s) as I wish to resolve it as is.

---

any...

Subcription possible?

Cheers,

Frank

Hi,

quote:

---

I would like to create a function that retrieves the value of a field by passing the string name of the table...

Hi Cindy,

quote:

---

Why do you need to lock down access through Query Analyzer/Enterprise Manager? If it's to prevent users doing things outside the...

quote:

---

Gee, that's a lot of budgets. You, know, the IDENTITY field was designed for this. It would be a LOT...

quote:

---

Frank - could the camera have been farther away from everyone and still be in the room?

---