As far as I know, that isn't allowed.  Something like this should work:

DECLARE

@name SYSNAME

SELECT

 @name

Truncate a table, or truncate the transaction log?  There's information about both of these in Books Online.

John

Does your stored procedure have parameters, and if so, are you passing different parameters in the second time?  It's always helpful if you post your code, by the way.

John

http://www.sql-server-performance.com/tips/all_main.aspx

Chris

I think the answer is "just because".  sa has fixed permissions and therefore you can't add it to or remove it from fixed server roles, hence the error message.

John

Chris

Yes, sa can perform any task that a member of security admin can (and more).  Mind you if your thrid party product requires the sa account, then it's probably time...

Torben

Do you mean enter the credentials in the same way as a SQL login?  I don't think that's possible.

John

Torben

Right-click on your Query Analyzer icon and choose Run As.  You can then enter the security details for the account you want to connect as.

John

Thomas

You could do it in one statement using dynamic SQL, but I think it's more elegant to do it like I've done below.  Why do you prefer the single query...

Marie-Sofie

Does this get you any closer?  I've left it to you to do the manipulation of the figures.  Obviously it's not tested since there was no sample data, and performance...

Andrew

From Books Online:

ALTER INDEX cannot be used to repartition an index or move it to a different filegroup. This statement cannot be used to modify the index definition, such as...

Delete the data in the child table that references the data you want to delete from the parent table.  Then you will be able to delete the parent data.  Alternatively,...

Ben

Can you adapt this example from Books Online to work in your environment?

John

USE AdventureWorks;
GO
SELECT c.FirstName, c.LastName
    ,ROW_NUMBER() OVER
    (PARTITION BY PostalCode ORDER BY SalesYTD...

First, don't mix old-style and ANSI join syntax.  Rewrite something like this:

select Distinct (e.empID),empName,lc.CountyName

from Indicator I

inner join emp e on e.jobid...

Ben

I think the ROW_NUMBER function is exactly what you're looking for here.

John