Luis Cazares (2/11/2014)

---

The problem is that '0000000' is being converted to int and adding it to the year. Instead of converting th char and then to int, I would just...

Miles Neale (2/11/2014)

---

Sean,

We have to find a way to justify any hire, and we try to use what tools and...

And be careful with those NOLOCK hints. It seems this may be ok in this situation but are you aware of what that hint brings to the table? Missing and/or...

jcrawf02 (2/11/2014)

---

wolfkillj (2/7/2014)

---

Word is that there are photos of a shirtless Grant from SQL...

Miles Neale (2/7/2014)

---

Sean Lange (2/7/2014)

---

That sounds to me like some people need to find more work to do. They are obviously spending way too much brain power over analyzing interview...

Miles Neale (2/7/2014)

---

Sean Lange (2/7/2014)

---

Miles Neale (2/7/2014)

---

If I respond to the question with "You got to be joking" or Wrong Tool For the Wrong Thing" I will not be...

Yes Please.

Miles Neale (2/7/2014)

---

If I respond to the question with "You got to be joking" or Wrong Tool For the Wrong Thing" I will not be scored and will not...

Taking Lowell's attempt at converting this ddl (excellent job, I would love to see your macro for this) you could do something like this.

;WITH MyCTE([col1],[col2],)

AS

(

SELECT 'qta-subbld4-swt1-ups1','qta-sub-bldg4-swt1-ups1.domain','<-should show' UNION ALL

SELECT 'qta-lr-china-hssp-ups1','qta-china-hssp-ups1.domain','<-should...

Dieselbf2 (2/7/2014)

---

Sean Lange (2/7/2014)

---

You also some parenthesis in your where clause that are very likely incorrect.

See if this might be more of what you are looking for.

Select P.PartID, P.mansPart, P.Cost...

There is nothing like insert statements, and this is nothing like insert statements. Please understand that...

You also some parenthesis in your where clause that are very likely incorrect.

See if this might be more of what you are looking for.

Select P.PartID, P.mansPart, P.Cost As PartCost, V.PartID,...

Grant Fritchey (2/7/2014)

---

wolfkillj (2/7/2014)

---

Word is that there are photos of a shirtless Grant from...

Yet another good question about SSAS. This has been a tough week of questions as I have never used SSAS.

Ed Wagner (2/7/2014)

---

I like the new "mark as answer" functionality. The green threw me at first, but it sure did draw attention to the post, which is the intent....