Thank you both!!!  😀

Have a great weekend!!!

sorry...should've shared (slaps forehead)

Msg 229, level 14, State 5, Line 1
The SELECT permission was denied on the object 'sql_modules',database 'mssqlsystemresource',schema 'sys'

but it only happened on...

One more question:  Can you think of any reason why the strSQL portion when run (testing) worked with NO "permission to schema sys" issues, but when the cursor query runs,...

You guys are super fantastic!!  Now the issue is permissions for the schema sys.  it works if I do it individually but there's over 200 DB and countless tables and...

Thank you sir!

Thank you! I'll review again.

How would you recommend getting "all" the Names on the query? (even though there is NO value or CaseId associated)

it gave me all three "dRank"...

The specific "Names" needed are in the WHERE clause. if you take that there may be an "other" name in the table...

I tried this too...

select

CaseFileIdentifier

, ReferralDate

, CollectedOnDate

, CollectedOnTime

, dRank as CollectionSequence

,Isnull([HBsAb],'---') as [HBsAb]

,Isnull([HBsAg], '---') as [HBsAg]

,Isnull([Syphilis],'---') as [Syphilis]

,[HIV NAT], [HCV NAT], [HBV NAT]

,Isnull([RPR/VDRL], '---') as [RPR/VDRL]

,Isnull([NAT HBV], '---') as...

Hi Drew,

That didn't work... 🙁

Here is some sample data, when you have time to check it out.

Create Table tempSero

(

CaseId varchar(20)

, rDate datetime

...

Thank you Drew! I'll give that a shot and if it doesn't work, I'll put up some sample data.