tom.w.brannon (8/14/2015)

---

sipas (8/14/2015)

---

Do models contain the values of entities? I thought the model contained entities, as in their attributes and hierarchies, but the attribute values are in the entity rather...

Here's what I did. May not be the best approach but it works:

SELECT 'EXEC dbo.[sp_ssis_addfolder] ''00000000-0000-0000-0000-000000000000'', N'''

...

I seem to recall that the construct:

SELECT @var = @var + ...

is not officially supported and may not always work. Or, am I misremembering something I read long ago?

Found...

Essentially, you're trading a hot-spot, with latch problems, for a fragmented index. If your table is write-mostly, this might be OK.

BTW, this is the sort of problem that In-Memory...

Daryl AZ (8/4/2015)

---

I understand now that this is newID() functionality.

I am familiar with using CTEs for recursion for ',' delimiting and see the difference. It just sorta,...

use a dataflow task with an Excel source and Excel connection

Basically, if you've got the skills and experience a company needs, and no one else fits their requirements (timing, salary, location etc), you have a good chance.

However, if you need...

I used:

SELECT [LEV5],[BF_ACTY_CD], COUNT(*) as cnt

FROM MyCTE

GROUP BY [LEV5],[BF_ACTY_CD]

HAVING COUNT(*) > 1;

and got:

LEV5 BF_ACTY_CDcnt

AC_53980_1207 2

AC_21200_1402...

Remembering that a CTE is just another way to code sub-queries, your update with CTE is the same as this:

UPDATE #tReceive

SET PoReceiveHeaderGuid = hdr.PoReceiveHeaderGuid

FROM #tReceive tr

INNER JOIN

(

...

You could:

1. set up an Event to trap the error and process the error.

2. Set up a conditional constraint (failure) on the ForEach task to process the error.

Alternative solutions:

SELECT Value

FROM #tmpNewValue

WHERE Value not in(

SELECT Value FROM #tmpOldValue where Value is not null

)

SELECT Value

FROM #tmpNewValue

WHERE Value <> all(

SELECT Value FROM...

scorchpc 96170 (7/14/2015)

---

g.britton (7/14/2015)

---

depends what you mean by preserves data types. ...

depends what you mean by preserves data types. Can you post...

Samuel Vella (7/14/2015)

---

I've used BIML for a large scale project before

~200+ ETL interfaces which included CSV, XML, Oracle etc...

My concerns are:

1. BIML might be free but to use it...

Here's one way I use this trick:

Suppose you're working on a stored procedure. You want to be able to test each section. However, you have a problem in...