leejayd (2/4/2016)

---

When on BI dev assignment I often have to create views as the basis for creating a start schema. Many times I have to use named queries in...

SQLisAwE5OmE (2/4/2016)

---

Sean Lange (2/4/2016)

---

SQLisAwE5OmE (2/4/2016)

---

Hi Sean,

I tried your query, and I am getting the following error.

Msg 4104, Level 16, State 1, Line 43

The multi-part identifier "pa.ParentID" could not be bound.

Msg...

SQLisAwE5OmE (2/4/2016)

---

Hi Sean,

I tried your query, and I am getting the following error.

Msg 4104, Level 16, State 1, Line 43

The multi-part identifier "pa.ParentID" could not be bound.

Msg 207, Level 16,...

christophe.bernard 47659 (2/4/2016)

---

Hello all,

i work with sql server 2008 and i have a little problem about a work i must to realize ...

Imagine this sample :

declare @tblDatas table(id int, completeName...

lauriesmith1890 (2/3/2016)

---

Hello, I have 2 tables: Child_Table and Health_Table:

Child_Table has columns used: App_ID, Major

Health_Table has columns used: Re_ID, Plan

I need to insert the App_ID and Re_ID into a temp table...

This has to be one of my favorite stories about an EAV system. https://www.simple-talk.com/opinion/opinion-pieces/bad-carma/%5B/url%5D

Luis Cazares (2/2/2016)

---

Sean Lange (2/2/2016)

---

Luis Cazares (2/2/2016)

---

<rant>

I'm not sure what's worse. An article promoting RBAR code or comments arguing that the code in the article won't work even if it...

Luis Cazares (2/2/2016)

---

<rant>

I'm not sure what's worse. An article promoting RBAR code or comments arguing that the code in the article won't work even if it does.

Some people's fingers work...

M Joomun (2/2/2016)

---

Sean Lange (2/2/2016)

---

M Joomun (2/2/2016)

---

I have a variable, TempQuarterlyPeriod, which has values 1, 2, 3 or 4. Based on the contents of TempQuarterlyPeriod I want to update two...

Good question Andy. Of course these are always subject to interpretation when the question is "what would you do". Hard to actually be incorrect there. 😉

The one response that would...

Can you explain this? I don't think I understand what you...

archyya (2/2/2016)

---

teamWLOvUnfavWfavL_1to3_1to31_3hto7_3hto71_7hto10_7hto101_7hto102_7hto103_10h_10h1PtsForPtsVs

atl554655220122221010397

bos3681341310111100107105

here's an NBA example (excuse the formatting) , but here I would also like to include a WINSlast5games column that calculates how many wins a team has in last...

M Joomun (2/2/2016)

---

I have a variable, TempQuarterlyPeriod, which has values 1, 2, 3 or 4. Based on the contents of TempQuarterlyPeriod I want to update two other values, TempStartDate and...

Posted my 2¢.

I would think this is considered against the licensing for Developer edition. As Gail said if you are uncertain then maybe you should ask Microsoft directly. However I am taken...