Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. misterjib

    Nested aggregates update query

    Thanks for the feedback dhookom. I've not used domain aggregate functions much - I shall investigate for future reference. misterjib.
  2. misterjib

    Nested aggregates update query

    Hi Everyone. I've binned this approach now because I couldn't get it working and instead used a two step process (which I didn't really want/couldn't be bothered to do) where I first create a temp table to get the COUNT of the DISTINCT IDs then UPDATE the target table with a JOIN on the temp...
  3. misterjib

    EXEC permissions, roles and the system master

    Thanks Denny for that nudge in the right direction - it's not quite working yet but found this: http://www.sommarskog.se/grantperm.html#EXECUTE_AS which i think is going to prove useful reading. JIB
  4. misterjib

    EXEC permissions, roles and the system master

    Can someone please tell me what permissions need to be granted to a role (owned by dbo) in order to execute this SP (All the dbs are sa owned) USE [master] GO /****** Object: StoredProcedure [dbo].[spDatabaseProperties] Script Date: 02/10/2011 11:05:47 ******/ SET ANSI_NULLS ON GO SET...
  5. misterjib

    MC timeline function to act on multiple instances

    Hi people. I've got this on the timeline of an MC: _root.seQ1MC.b_seQ1yes.onRelease = function(){ tickVar = _name; //trace("local tickVar = " + tickVar); //trace("this tickVar value = " + _root[tickVar]); if(_root[tickVar] == true){ gotoAndStop("tickOn"); tick = 1; //tick is defined etc when...
  6. misterjib

    Nth Largest

    Forgive me lbass - your solution works fine in the footer. many many thanks
  7. misterjib

    Nth Largest

    This is brilliant lbass, really appreciate your assistance, but i'm still having difficulty displaying. can i just say, i'm a graphic person not a programmer... ok so: detail section whileprintingrecords; numbervar INR; if {Reviews.Date} = nthlargest(2,{Reviews.Date}) then ( INR :=...
  8. misterjib

    Nth Largest

    I'm probably (being) a bit stupid - any help is sincerely welcome. All i want to display is a single record in my report header /footer depending on Nth Largest. I've summarised the Nth most recent date and i cant for the life of me work out how to display values from other fields in the same...

Part and Inventory Search

Back
Top