Dave Convery (10/13/2015)

---

Currently there are filters based on post numbers, with automatic approval for people over a certain number of posts. This is a bit more robust than just the...

Table A has a row where Id = 4.

Table B does not have...

Try changing it to 'Required' on the container. Leave the data flows within as supported.

sqlbaby2 (10/12/2015)

---

I want to join 2 tables, table a and table b where b is a lookup table by left outer join. my question is how can i generate a...

dudekula.kareemulla (10/12/2015)

---

I have a package with 3 parallel data flow tasks added in a sequence container. I need to implement transaction such that, the transaction completes if all the 3...

I have an idea.

If the subject of a post contains either "http://" or "https://", mark it as spam.

Felix Pamittan (10/12/2015)

---

Yeah! I've been lurking this forum for quite some time now...

Nice code, Felix.

Not sure how quick it was though; have you been listening to Eirikur?

kdefilip (10/11/2015)

---

Hi

I have two tables, INCIDENT and PEOPLE

INCIDENT has two fields, ID and Date

PEOPLE has three fields, INC_ID [foreign key to INCIDENT.ID], PersonIteration, Complaint

There is always only one incident, but...

Jason A. Long (10/9/2015)

---

Correct me if I'm wrong (a strong possibility), but I don't think we're able to reference...

Jason A. Long (10/9/2015)

---

Phil Parkin (10/9/2015)

---

I found a 'GetNumbers' function here [/url] and that, when combined with Jeff's function, allows you to take the CLR out of the equation ......

Here's an iTVF version of the query I posted earlier.

create function dbo.GetNumbers ( @data varchar(8000) )

returns table

return

select nums = left(substring(@Data, patindex('%[0-9.-]%', @data), 8000),

...

I found a 'GetNumbers' function here [/url] and that, when combined with Jeff's function, allows you to take the CLR out of the equation ... at least for the data...

anthony.green (10/9/2015)

---

7 packages, a bit overkill.

Why not 1 package...

+1