hi

i found this in our own sqlservercentral.com

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=170397

hope this gives u some idea as to what to do

hi

try this

select

temp.cname from (select c.cname,count(o.cno) AS total from...

hi

u shud be able to do what u r trying, but r u trying to select data from a temp table created inside the inner procedure(proc 1) that u r trying...

hi

if u r using sql server 2005 u can use the PIVOT operator for this.

hi

r u sure that ur database is really in sinlge user mode? maybe somebody has (accidently) changed the access rights due to which u cannot access the database.

if it is...

hi betty

has the authentication mode changed to windows only. Is that the issue?

Hi

dont think  u can execute a procedure inside a function.

either convert both the function and procedure to procedures or convert them to functions

All The BEST