I think I have worked out what your doing now. This is what I have so far using the real column names...

I get this error and cannot work out what...

Hi All,

Thanks for your help.

ALZDBA I am trying to test your function now but I cannot understand what values you are passing to the function?

Can you give me an...

Ahh right I see what happened now. I am running Windows XP Pro so I'm assuming when the SQL Server install runs and IIS is not configured it skips the SSRS...

Yes, down but certainly not out. I passed the exam yesterday at the 2nd attempt!!

Thanks to everyone who contributed to this post. I just hope Eddiez passed his 2nd attempt last month?

So...

I have searched for a new schema owner and selected dbo, then clicked ok. I presume this saves the changes?

I then go to the users section and right click >...

OK I have done a lot of work with the Transcender software and I'm now at a point where I am consistantly getting around the 90% mark each time.

I still...

I can't even use PIVOT either can I?!

Thanks for your help guys, I rarely use pivots but I am experimenting now. The problem is I am running SQL Server 2000 which doesn't have the OVER or Row_Number...

Hi Terry,

Thanks for your post. I am very interested in how you were able to research the simulation questions?

I also failed my first test with a similar score to yourself,...

CaseID                   BorrowerID1              BorrowerID2            BorrowerID3            BorrowerID4

1589                      7750

1590                      7751                        7752                      7753                      7754

Sorry I got it wrong! I require the output to run like this horizontally. Apologies.

Hmm, that seems too easy. Let me check I got the problem exactly right...

There are many other columns in these tables but I am using the columns to be joined to keep things much simpler.

The sample data looks something like this;

Case Table