FYI, an SQL Server...

Both solutions run fine. If you're getting an error, it would be because you changed something and we don't know what it is.

You need to review your code for any...

Have you tried a ForEach Loop in SSIS? Would you be interested?

Something like this?

SELECT *

INTO #Test

FROM (Values

(1, 'A'),

(1, 'B'),

(1, 'C'),

(1, 'D'),

(1, 'E'),

(2, 'A'),

(2, 'C'),

(2, 'D'),

(2, 'E'),

(3, 'A'),

(3, 'B'),

(3, 'C'),

(3, 'F'),

(4, 'A'),

(4, 'B'),

(4, 'D'),

(4, 'F'),

(4, 'G'))x(id, value);

SELECT id,

...

Vyper426 (5/18/2015)

---

Ed Wagner (5/15/2015)

---

A SELECT * in a cursor...So that means if a column is added to a table the system uses, the interface breaks at every point where it...

This might at least help a bit, but it won't address the main problems of the query (user defined scalar function and function on columns in the where clause or...

You can use a subquery or CTE.

SELECT col1

FROM (

SELECT col1,

case when upper(col3) like '%HTEST%'...

Sean Lange (5/18/2015)

---

There is something missing here for sure. You stated that you use the DelimitedSplit8K function in your 2000 instance. In the original format it would NOT work in...

It's incomplete.

Changes in the data between runs?

If you run a query over a static set of data, it will always return the same result (except for nondeterministic functions).

Eric M Russell (5/15/2015)

---

Sean Lange (5/15/2015)

---

Luis Cazares (5/15/2015)

---

It's important for us that you'll be a good fit in our team, so the following question will define if you get the...

Grant Fritchey (5/15/2015)

---

Sean Lange (5/15/2015)

---

Luis Cazares (5/15/2015)

---

It's important for us that you'll be a good fit in our team, so the following question will define if you get the job...

Or you could prevent all that casting by parametrizing your query.

SELECT @sql = 'SELECT *

FROM #Temp

WHERE DocDate BETWEEN @EndDate AND GetDate()'

EXEC sp_executesql @sql, N'@EndDate date', @EndDate

It's important for us that you'll be a good fit in our team, so the following question will define if you get the job or not.

Leading commas or trailing commas?

Alvin Ramard (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Alvin Ramard (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server,...