Search results for query: *

I need to use a SELECT statement to find the Genus (animal-type) that costs the most to feed per 30 days. I've got the following query that gives me the average cost per Genus, but I need only return the ONE a_Genus_ID that costs the most to feed. I basically need GS.a_Genus_ID WHERE...

I've either found a bug or I've gone insane. I have a select into statement that runs outside a stored proc but creates an open transaction that hangs within the stored proc. I'm on SQL 2000 sp3. It also runs if I put the statement into a variable and run it as EXEC(@sql). Inside the proc it...

We have locked our databases down to certain user created database roles. Now our problem is that when the SQL user is placed in these roles, they are unable to see any jobs listed under SQL Agent. I've tried several predefined server roles but can't seem to locate a lowlevel one that will allow...

I'm a DBA, so bear with me, I only know T-SQL. In DTS, I need to pump data from one machine to another based on a max(date) located in a table on the destination server. I've looked up Global Variables and I'm this far: 1) Execute SQL Task with Select Max(date) etc. with an output parameter...