Hello Dwain,

maybe you can help me answer my other question, which might solve the problem, i am going to make a temp table, then insert the records I want from...

Hello everyone

thanks dwain for the correction, however I have tried what you have and came up with the same results for example:

if i do the rowid = row_Number() etc., but...

Hello Lynn,

thank you for the fast reply, sadly i removed the Go part and now it says:

"An error occured while the query design method was being saved. Incorrect Syntax Near...

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 param2, make sure you...

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...