Hello,

Thank you for the code, the only problem I am having with this is the:

from msdb..DASD

what table is that? where did you get that from, its throwing the error message...

Beautiful thank you 🙂

Hello Everyone,

I figured out the problem, sorry, but for everyone, please make sure you have REPORTSERVER, keyword, add server, example below:

http://ir-prodsql03/ReportServer/Pages/ReportViewer.aspx?%2fScore%2fRegistration&rs:Command=Render&param1=variable1&param2=variable2

I was putting:

http://ir-prodsql03/Reports/Pages/Report.aspx?ItemPath=%2fScore%2fRegistration&rs:Command=Render&param1=variable1&param2=variable2

also for param1 and...

hey Daniel,

thanks for your replies,

yes please, I should do a group by customer id, then use count for the profile id correct? then the count will determine the color, does...

thanks again :).... where do i mark as answered to give points or whatever?

.... HOLY crap your good.... no seriously, thats exactly what i need thank you :):-D

Sorry all for any confusion here is a more acurate example,

Yes you are right those dont match however below the right examples of matching from the tables customer and person:

Insert...

ok now for the explanation

using the second row insert of match as an example:

Insert #Match

select '1', '6', 'firstname' union all

first number 1, comes from table Customer, second number 6,...

sorry again, offically this works, i tested it twice and will work:

insert Match2

select '1', '1','firstname' union all

select '1', '6', 'firstname' union all

select '4', '2', 'address' union all

select '5', '1',...

here go, this works:

insert Match

select '1', '1', 'firstname'

select '1', '6', 'firstname'

select '4', '2', 'address'

select '5', '1', 'firstname'

sorry for the confusion I put a # sign before matching thinking...

I see now says the blind man 😀

insert #Match

select '1', '27', 'firstname'

select '8', '6', 'firstname'

select '40', '107', 'address'

select '45', '19', 'firstname'

Hello hello SSCarpal Tunnel

thank you for being paitent with me, here is the information that hopefully makes sense and I included everything from all tables to the query i amt...

ok then....

like this:

if firstname from customer where customerid = 1 matches firstname from person where personid = ... whatever id

THEN

INSERT INTO match (customerid, personid, columnname)

VALUES (customerid, personid, firstname)

then after...

Again thank you, the output I would like is if bob customer id 1 from customer table matches the first name bob from person table with id 27, then insert...

Hello Everyone,

Here is the DDL, again sorry which is exactly the same that was posted except there is an id for both customer and person, and its the identifier and...