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...
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
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...
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...
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 :=...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.