Don't be so sure about that. 😉 Try...

With a temp table this is simple.

create table #MyVals(RowID int identity, returnVal int)

insert #MyVals exec my_proc @para1

insert #MyVals exec my_proc @para2

insert #MyVals exec my_proc @para3

select * from #MyVals order by...

select * from sys.server_principals where is_disabled = 1

Aside from a login trace I...

Pretty sparse on the details...so you can't create a temp table (that is a strange mandate), no looping (good idea to avoid looping whenever possible).

So this is like calling the...

You're right. That is totally unclear. Can you explain what you mean a bit more clearly?

YSLGuru (9/30/2011)

---

Sean Lange (9/22/2011)

---

Given the inability to do this via RI it looks like what you posted originally should work fine. The painful limitation of course is that it can...

You said you have errors. Would you care to share those?

Realize the reason nobody is willing to help is the same reason you don't want to deal with it. That code is a mess. We don't have the tables or...

That isn't t-sql, it is oracle.

Maybe some ddl, business rules, clear explanation...seems all your posts today are lacking the most important thing to get some help, details.

Some others may weigh in with their opinions but I think you will find it easier to have a separate database for each client in the long run. From the...

seftest_09 (9/29/2011)

---

I am a new and am having some trouble with joining two tables.

table1: (topicID, questionID) where topicID is the primary key. For each topicID, there are many questionID's.

Now,...

Select stateName, stateId

union all

select '--Select All--', null

from USStates order by stateName

That will get you the "empty" row for select all.

No problem. That get you what you need then?

You have to add an extra ' to make it work.

select 'don''t'

--edit sadly a typo in so few words. 🙂