Just have to ask, you mentioned you tried all the data types in SSIS. I assume this includes the "double" type as well? I am surprised it would fail here.

I did a quick search and looked through a few links on recursion. Here is one that I think explains the basics fairly well from a elementary standpoint.

http://www.cplusplus.com/articles/D2N36Up4/

MMartin1 (1/15/2016)

---

In Excel, insert a column next to the one with the date. Assuming there is a value in B2 displaying like 12/31/2015 ... Enter a formula into C2 (the...

Koen Verbeeck (1/15/2016)

---

It's not exactly the same. In...

After deployment, the shared data source connection is stored, like the reports, to the virtual directory that SSRS deployed to. Here you can change the value of the shared connection...

If you do a search on something along the lines of "Employees table and CTE query to show who reports to who" you will get the main go to example...

GilaMonster (1/15/2016)

---

CASE WHEN <Condition 1> AND <Condition 2> AND <Condition...

Phil Parkin (1/15/2016)

---

Welsh Corgi (1/15/2016)

---

Phil Parkin (1/15/2016)

---

Welsh Corgi (1/15/2016)

---

drew.allen (1/14/2016)

---

No,...

In Excel, insert a column next to the one with the date. Assuming there is a value in B2 displaying like 12/31/2015 ... Enter a formula into C2 (the new...

Great question. It reminds me of the merge join transform in SSIS, the inputs have to be ordered in like fashion.

summerpet39 (1/14/2016)

---

Extracting data from Google Analytics requires some programming skills.. specially with OAuth 2.0. If you are comfortable with C# or other language .. use their official SDK found on...

If this is indeed the case, I am not sure why updating one field means blanking out the other, but as I mentioned I am probably missing a thing or...

Now if a field does not need updating, I guess the value in the table would stay null.

How to get around that in some cases (UPDATE X SET field4=7,...

abdullah.zarour (1/13/2016)

---

Hello Michael

Quick questions. Have you ever partitioned a table? If so, can you provide some actual facts as to what the performance gains you realized?

Yes , I did...

Eirikur Eiriksson (1/13/2016)

---

SQLRNNR (1/13/2016)

---

Jacob Wilkins (1/13/2016)

---

edwardwill (1/13/2016)

---

Jacob Wilkins (1/13/2016)

---

edwardwill (1/13/2016)

---

Eirikur Eiriksson (1/12/2016)

---

SQLRNNR (1/12/2016)

---

I dunno about the "correct" answer on this one. The statements compile for me but produce an error...