bsmith 63193 (3/15/2016)

---

I am fairly new to BI and SSIS, but am currently working on putting together a data warehouse. I have read that using surrogate keys is a must...

Have you run a DBCC CHECKDB on MSDB?

I don't...

Jason-299789 (3/15/2016)

---

Phil Parkin (3/15/2016)

---

Jason-299789 (3/15/2016)

---

@yb751

The NULL will only be eradicated if there is a row with a non-Null value, in the same column.

See the code below, when aggregating on Account....

Indeed. Why make such...

Jason-299789 (3/15/2016)

---

@yb751

The NULL will only be eradicated if there is a row with a non-Null value, in the same column.

See the code below, when aggregating on Account.

DECLARE @myTable TABLE...

lkennedy76 (3/15/2016)

---

okay guys, I am stuck. I have two columns that I need to add and make one total for a report. there are null values so I have to...

WHERE [column] not in ('x','y','z')

dan-572483 (3/14/2016)

---

Using SSQL Server Data Tools for SQL 2012, one of my Data Flows got "moved" to the bottom of a huge workspace, meaning that when I open it for...

sqlnewbie17 (3/15/2016)

---

How do I build an SSIS package which will have a dataflow task within a foreachloop container.

The dataflow task has source and destination ole db's.

At the beginning outside of...

yb751 (3/14/2016)

---

I started working with the hierarchyID data type. So far it's been pretty great working with the built-in functions rather than having to use recursive CTE's.

Consider the...

Jack Corbett (3/14/2016)

---

hjp (3/14/2016)

---

Thank you for an interesting article. I find it less useful, though, when you rely on two assumptions:

1. SQL Authentication (and the willingness to store...

Jack Corbett (3/14/2016)

---

I like Lowell's solution and I think it will perform better than an AFTER update trigger because the AFTER trigger will require 2 updates to take...

SQL!$@w$0ME (3/14/2016)

---

Thanks Phil. Can I accomplish this with just one update trigger?

Can you give me a logic for the update trigger. The script below is not working as intended.

--Column...

SQL!$@w$0ME (3/14/2016)

---

using UPDATED and DELETED temp tables, how can I override the new value and keep the old value for a column using UPDATE trigger. My requirement is not to...