Any rollback rolls back all the nested transactions.

psc032802 (11/24/2014)

---

What is the "machine in question"? The one the actual database is stored on?

If so, then SSIS needs to be installed on the database server and also on...

use a Conditional Split Transformation on the Data Flow. Look for your data there.

Good walkthrough here: http://weblogs.sqlteam.com/joew/archive/2008/08/22/60695.aspx

anglais, svp

abhas (11/24/2014)

---

Hi all,

I am having SP which gives dynamic resultset. i.e.number of columns varies from min 5 to max 10.

I am able to create a table with this SP...

Lynn Pettis (11/22/2014)

---

g.britton (11/21/2014)

---

Lynn Pettis (11/21/2014)

---

Here is an alternative that does not use a cursor or while loop. You will have to test it yourself to be sure it...

Do you have a link on Microsoft.com that describes that? I've...

Lynn Pettis (11/21/2014)

---

Here is an alternative that does not use a cursor or while loop. You will have to test it yourself to be sure it does what you...

good point, though the standard...

ZZartin (11/21/2014)

---

g.britton (11/21/2014)

---

ZZartin (11/21/2014)

---

Sean Lange (11/21/2014)

---

Under the hood a cursor is a just a...

ZZartin (11/21/2014)

---

Sean Lange (11/21/2014)

---

Under the hood a cursor is a just a while loop...

Luis Cazares (11/21/2014)

---

Damian-167372 (11/21/2014)

---

Luis Cazares (11/21/2014)

---

Damian-167372 (11/21/2014)

---

yes your absolutely right I agree table variable is a overhead for this query,

but for any other large queries I can use...

davidandrews13 (11/21/2014)

---

i've been trying to get TRY_CONVERT to work but it states its an unrecognized built in function for sql server 2012 (even though sql server *does* recognises it because...

super48 (11/18/2014)

---

yep sorry i mentioned everything except ssrs yeah its in ssrs.

in ssrs when you add dataset and right click and select fields option and click add there are two...