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)

---

I have a select query on table unify, here i want to display the "Desc" value from JKS table instead of "u.code" field

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)

---

Do you think it is worth writing an article / blog on how you have used a particular feature (in SQL Server) to help you in your day to...

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)

---

You've shown very simplistic queries that are hitting entire data sets. Your tuning opportunities here are...

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)

---

You know, I think the Silver Spoons are going to need to be reordered - I'd suggest at least a...

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)

---

You know, I think the Silver Spoons are going to need to be reordered - I'd suggest at least a case. SS...

Always

Does anybody know anything about this lot? I've had that rarest of things, a useful Groupon offer arrive and I'm thinking of taking it up. I thought it...

ChrisM@Work (10/1/2015)

---

jasona.work (10/1/2015)

---

I do...

Mmmm...

Sausage (breakfast sausages) with syrup on them is goooddd.

As for a maple ale / beer,...

ChrisM@Work (10/1/2015)

---

BWFC (10/1/2015)

---

I got a bacon making kit for my birthday on Sunday. I can't wait to give it a go. Hopefully next month there'll be a butty...