Thanks, I will check that out. I also found a really interesting article on how to build a CrossTab stored procedure that appears to do what I...
How do I handle a query where both the rows and the columns are dynamic? For instance, say I have a set of projects, each of which is being executed...
Derrick, thanks for the advice. I ran Profiler yesterday, and strangely enough it acted as though there were no requests coming in at all. No errors,...
Adriann: thank you, I will definitely look into that. Thomas: You are right, and I apologize. I hope you and others can understand that it is...
This is like one of those twilight zone movies. Suddenly, I think I'm speaking English but in reality I'm apparently speaking in Chinese or...
Although I appreciate your answering the post, your answer does not help me. I HAVE already set the permissions for the specific user created to...
What does that mean? How do I set the permissions on the new user so that when I run the ADO command it returns a recordset? Both sa and the new...
See if you can replicate this: create a new user and add them to the pubs database. Don't give them ANY permissions. Then log in to Query Analyzer,...
I'm not getting an error. This is bizarre. I'm logging in to Query Analyzer with the user account, not the sa account. I decided to try the...
OK, I have tracked it down somewhat. Apparently ONLY the sa user can run these queries. I have tried adding every single permission for users added...
Harsh, just try what David is saying and look at the result.
The sproc looks like this: create procedure spGetColumnNames @tablename varchar(100) AS SET NOCOUNT ON SELECT column_name FROM...
I am having a bizarre issue with permissions. I utilize a hosting service to stand up my SQL Server applications. Usually, I build a web app on my...
We are bidding an audit job. Details here: ========================================================================================= TECHNICAL...
That's good. I don't need backups or recovery, the data is historical and someone else is storing the master copy. This is only a 4-6 month effort....
I need to know if SQL can even do this. I have 4 SAS files I need to import and run queries on. Three of them have 50 million records, and one has 25...
Wouldn't that return both 2 and 5? I can only have it return one of those. I was headed down that road, and had gotten this far (untested): SELECT...
I have a table with two columns, task and predecessor (both integers). I need to be able to give a predecessor, and select ONLY the task id that has...
Found what appears to be a partial solution at http://www.geocities.com/SiliconValley/Garage/3323/aat/a_topo.html, but since it's in some language...
Doesn't SQL Server 7/2000 support implicit conversion of datetime to strings? Is there a definite need to convert this explicitly?
Separate names with a comma.
