You can get around that. You need to specify WITH RESULT SETS in your OLEDB source query and all will...

GilaMonster (6/13/2016)

---

I disagree MERGE is NOT atomic (it should be, it isn't) and hence both it and the...

fabriziodb (6/13/2016)

---

the goal is to update text valus if a record with...

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