L' Eomot Inversé (12/10/2013)

---

I suspect that "ColX IS NULL" is a faster text than "ColX = 'Billable'" but that's not the point, if you do this with a left outer...

The problem is that billable information can change during the course of a month.

If I use a degenerate key, I have to update all the records for that customer for...

I asked a design question over here. If any of you would like to shed a light on my doubts, I would greatly appreciate it 🙂

If the question is not...

You can either add a primary key (clustered or...

You can control this in SharePoint, but I'm not sure it is possible in Report Manager.

You can pass the URL access parameter if you build your own reporting webpage and...

SELECT House_no

FROM myTable

WHERE CHARINDEX('-',House_no,CHARINDEX('-',House_no,1)+1) = 0

ORDER BY House_no

Gerald.Britton 28181 (12/9/2013)

---

Koen Verbeeck (12/9/2013)

---

Step 7 is normal. Once you open the connection editor, the password is removed.

Which configuration did you use in step 10? Remember that the password is...

Step 7 is normal. Once you open the connection editor, the password is removed.

Which configuration did you use in step 10? Remember that the password is not saved to the...

What's the status on this, did you resolve your issues?

Stephen Hirsch (12/9/2013)

---

"Always do what makes sense"

I'm not so sure about the example given in the article, but that is sound advice. My rule of thumb is, if you need...

Nice article.

One remark though: using SSIS doesn't necessarily mean RBAR.

You can stream the data into a bulk load just fine (as fast as the join) and still find the erroneous...

Easy one, thanks!

Too easy 😀

Congrats!

Nicely spotted 😀