David McKinney (10/27/2015)

tom.w.brannon (10/27/2015)

GilaMonster (10/1/2015)

So, um, whereabouts...

You're still not making a great deal of sense.

One thing is that the first '+' sign before the ISNULL will cause an error if there's nothing before it.

We're trying to help but we've got no idea what your tables look like. Please do as we've asked and provide some usable data.

This link, http://www.sqlservercentral.com/articles/Best+Practices/61537/ will show you...

Minnu (10/21/2015)

SELECT

u.id,

(...

Thanks Martin.

After a bit of testing\trial and error, I went down the small dimension and adding to the existing dimension route. The Comments dimension that's already there...

BL0B_EATER (10/15/2015)

Frost

ChrisM@Work (10/8/2015)

Jeff Moden (10/7/2015)

Jason A. Long (10/7/2015)

Jeff Moden (9/6/2015)

Grant Fritchey (9/6/2015)

Jeff Moden (9/6/2015)

Grant Fritchey (9/6/2015)

I can't get my head around that kind of attitude, particularly when there'e so much to learn. Like you say,...

Ed Wagner (10/6/2015)

BWFC (10/6/2015)

Michael L John (10/5/2015)

Lynn Pettis (10/5/2015)

Ed Wagner (10/5/2015)

I notice you posted the question in the SSIS forum.

If you have a read of this page:http://stackoverflow.com/questions/18876559/ssis-convert-string-to-a-guid-when-importing-and-saving-data it will show you how to do it in SSIS.

View

Michael L John (10/5/2015)

Lynn Pettis (10/5/2015)

Ed Wagner (10/5/2015)

Always