CirquedeSQLeil (4/14/2010)

---

Lynn,

On the topic of case consistency - please don't ever try Microsoft CRM. It will absolutely drive you bonkers. CRM requires objects be created through the GUI....

Trey Staker (4/14/2010)

---

Lynn Pettis (4/14/2010)

---

I realize many run SQL Server using a case insensitive collation, but really, your code should be consistant. I'm sorry, but roleID and RoleID aren't...

Looking at a third party tool may also be needed if you have limited space to store backups files. Or you could implement a zip routine to compress your...

I realize many run SQL Server using a case insensitive collation, but really, your code should be consistant. I'm sorry, but roleID and RoleID aren't the same. That's...

And I did. Just waiting now to see what...

It works, just not the way you...

Here is my code:

select distinct

reportID,

RoleID,

stuff((select ', ' + t2.User2

...

Also, your code won't work as is when run on a system using a case sensitive collation.

Missing DDL for the table you are.

Make it easy on us, show us what the result set should look like based on your sample data. They do say a picture is worth a thousand words,...

Celebrities and the super rich always seem to get special treatment, don't they.

Is this an on-line application or is the data loaded via files?

Unfortunately, there is no way to recover your data at this point. Once data has been updated to...

To the TinD I am going, fun you all can have.

If you can't be bothered with posting what is asked, I guess I can't be bothered with helping you. Search SSC, you'll find numerous examples on this site that...

Trey Staker (4/14/2010)

---

Bwhahahahaha... This is awesome. I had a manager once that wanted me to get the code off of microfishe. He also thought that we could restore...