Nice, Alan. I saw the word 'split' and I was off like one of Pavlov's four-legged friends. Did not even consider alternatives.

mcfarlandparkway (12/27/2016)

---

Set based approach? How to do this?

How to parse(split) this 9000430944:7|Information

-> 9000430944 - emp number

-- 7 - stud number

--Information - Description

How to split on pipe? and How to...

mcfarlandparkway (12/27/2016)

---

In the stored procedure - I need to implement a loop based logic after update statement ..

Now I have to add a logic in this stored procedure

after update...

mcfarlandparkway (12/27/2016)

---

Hello,

I have data from two different sources - Source1 and Source2 - we have a dtsx package where it loads...

wweraw25 (12/27/2016)

---

Yes you are right. I have a two date fields to compare.

But whats the thing I should do in SSIS to achieve this since it is across different...

wweraw25 (12/27/2016)

---

I'm comparing on combination of keys.

I know lookup is not a good option for millions of rows.

Is there any other way to grab the difference and insert into table...

wweraw25 (12/27/2016)

---

Hello,

I have two tables

-- Table A in Server A of Database A

-- Table B in Server B of Database B

My Source is Table A and Destination is Table...

SQL Prompt to the rescue!

For the benefit of others, here's that query again, with line-breaks :w00t:

SELECT

Account02_ACCOUNT_ID6 ...

meiry242 (12/24/2016)

---

Thank you very much for you replay , i found info about this tool ,

but i haven't found any info about my situation where i need to fill data...

meiry242 (12/24/2016)

---

I have generated 200 mega data script from local SQL Server, which I generated via Tasks -> Generate Script in SQL Server Management Studio.

When I try to execute it...

If the statements to be executed come directly from a table whose contents cannot be manipulated, except by suitably authorised...

Welsh Corgi (12/23/2016)

---

Lowell (12/21/2016)

---

Dts.Events.FireError is what you want.

is your account used by a team of users, and not an individual?

Trivially adapted from part of an answer I posted for...

hamzajosh (12/22/2016)

---

Phil, Like Drew pointed out, your solution returns formulas that have even ONE ingredient in common, while I am looking for a exact match on ALL ingredients. I appreciate...

I'd also be interested to hear why my solution...