Crispin,

I wanted to thank you for replying.  In the end you didn't exactly give me the answer but you got my mind working and pointed me in the right direction. ...

Because what I need is the maximum value from one database based on values from my source data.  The aggregate component just lets me find the aggregrate value from the...

I found the solution to this and thought I would share.  It turns out Windows was saving passwords for me and hiding them.  I needed to clear them out in...

Giving Loser more permissions would entirely ruin the point of the account.  I need to have one with limited permissions so I can test stuff like a user, not like...

The issue is actually not the SQL login.  That part is contained in my connection string.  I was actually looking for a way to do the IIS authentication.

I had posted this to another forum as well and Markus Fischer was kind enough to give me the link that saved the day:

http://charliem.wordpress.com/2006/04/12/reporting-services-2005-into-2000/

I figured I would post it...

I didn't test it but is seems this should work and is a bit simpler:

SELECT s.* FROM Students s

LEFT JOIN StudentExam se

ON s.StID=se.StID

WHERE ISNULL(se.ExamName,'') <> 'SQL Server'

This way any NULLs...

Ash,

Thanks.  I should have known to look for a service pack but I was just so frustrated by that point I wasn't thinking.  That saved the day in WAY more...

This did not work for me.  I never clicked that checkbox and I still lost all my identity values.  In addition, I don't really want to create the whole thing...

I got it.  I altered that first insert to be a select...into statement and it executes BEAUTIFULLY!!!

Dingbat me realized after posting this what you meant and OF COURSE that was the way to do it 🙂

I added the insert for each time I create a column. ...

Could you give me a brief example of what you mean?

Because the table is being created dynamically.  No table exists until a cursor is executed and the table is defined.

Missqti, you and me both feel the same way.

Though, look how much longer later and I just abandonded any hopes of using that product for now.

Never mind.  I am a doofus.  My issue was actually later in the query and not worth mentioning....