Two procs trying to delete and insert the same @Id at the same time? Why would you expect anything other than a PK violation?

Another instance = another install of SQL Server.

This is important...

Brandie Tarvin (6/10/2016)

---

Ed Wagner (6/10/2016)

---

WayneS (6/10/2016)

---

Phil Parkin (6/8/2016)

---

And why not ask them to make it idempotent while you're at it:

IF COL_LENGTH('dbo.mytable', 'col1') IS NULL

BEGIN

...

komal145 (6/10/2016)

---

Here is the agebucket column: 12-24

need lowerbound :12 and upperbound:24

Right now I wrote expression in tsql something like below:

Substring([AgeBucket],0,CharIndex('-', [AgeBucket])) As LowerBound

,LTRIM(REPLACE(Substring([AgeBucket],CharIndex('-', [AgeBucket]),3),'-','')) As UpperBound

How can we re-write...

komal145 (6/10/2016)

---

i have destination table with not null columns. So in oledb destination mapping from source to destionation. i selected "ignore" and trying to insert data. The task keeps failing....

--deleted

etl2016 (6/9/2016)

---

Dear All,

We use ROW_NUMBER () to partition results and hand-pick the needed records, mostly to address duplicate records scenario.

However, how do we sense that there is a potential threat...

Try

Case when LogDate = cast(LogDate as date) ...

Lynn Pettis (6/8/2016)

---

Brandie Tarvin (6/8/2016)

---

<headdesk>

User asks me to move this bit of code into QA:

ALTER TABLE MyTable

ADD Col1 INT,

Col2 INT

GO

I push back and say "Please add...

Response removed as a result of the change from 'rows' to 'columns'!

Really? So what is this?

https://community.oracle.com/community/database/developer-tools/sql_and_pl_sql

So your problem is solved?

OK. Next step is to remove the WHERE conditions one by one and rerun. Hopefully, removing one of the conditions will make rows appear ... then we can focus troubleshooting...

This is difficult, because we don't know what your data looks like. But first of all, here is your query again, reformatted for readability:

SELECT CustomerAccount.AccountNumber

, ...