Ray - thx for the feedback. Actually I used your exact solution - and it works fine in Mgmt Studio -- returning the table Name(s).  Problem is - in Reporting...

John - thx a million.. That worked fine! 

Thx for the feedback.  FYI, to render the contents of the DROP down list in Reporting Services, I use an underlying dataset with this SQL:

SELECT [NAME] FROM...

Markus - thx for the SQL.. this worked fine in 2005.   I modified the SQL to run against 2000 system tables and it's failing trying to get to sysdatabase_permissions (no such...

This script will cycle thru each 2005 DB and "auto-fix" each database User's SID to match their SQL Server level SQL Login. 

DECLARE @sql nVarchar (100), @DB VarChar (50), @SQL1 nVarchar...

Unfortunately, no.  If I come across 1, I'll reply.

I haven't tried it yet.. just wanted to inquire.

I successfully used REVLOGIN to generate the LOGINS script (from the source) and apllied to the target.   Our issue resides with the fact that each SQL Login on our new,...

Ed - much appreciated.. you can eMail the script at "webmaster @ skippackridge.com"  (I seperated my eMail address here to avoid spam!!  Please parse back together) 

thx in advance

Lynn - anything is appreciated.  thx

Oblio - your solution worked PERFECTLY !!   I can't thank you enough.

- Bill (DBASkippack)

DDL

---

CLSTLastName     VARCHAR(40)

CLSTFirstName    VARCHAR(40)

Value            VARCHAR(100)  --<  don't blame me: I didn't design !!!

Perf_YTD         DECIMAL(18,4)

BB_Return_YTD    DECIMAL(18,4)

CLSTLastName  CLSTFirstName  Value  Perf_YTD  BB_Return_YTD

------------  -------------  -----  --------  -------------

Jones         Adam           55        1.234         ...

Unfortunately, I am still receiving the same error msg:

Msg 130, Level 15, State 1, Line 3

Cannot perform an aggregate function on an expression containing an aggregate...

Thx Oblio - that worked great.  Would you happen to know how to resolve this issue?  I'm receiving an error in Management Studio because I'm performing a COUNT(*)...

Gonna try this:

UPDATE RGPerfExtract SET Perf_YTD_Percentile =

 dbo.UDF_LinearInterpolation(Value, Perf_YTDLT, Perf_YTDGE,

 dbo.UDF_FloatingPointDivision(countLT-1,countMinus1),

 dbo.UDF_FloatingPointDivision(countLT,countMinus1)) * 100 --as percentrank

  FROM (

   SELECT SUM(CASE WHEN Perf_YTD < Value   THEN 1 ELSE 0...