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...
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 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...
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...
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...
I am in the unfortunate position of having to provide GANTT chart functionality for an earned value system. Here are the tables I'm intending to use:...
I have a stored procedure that intermittently generates the following message on my asp page: "Warning: Null value is eliminated by an aggregate or...
I have been trying to solve this problem off and on for over a year and no one can help me with it. I am turning to you in desperation! I need to...
Separate names with a comma.
