Have you tried running in 32-bit mode?

sqlfriends (11/14/2016)

---

Yes , that was posted by me.

But I donot like to use recursive CTE, it is slow.

And I wonder if there are any other suggestions.

Thanks

Here is the...

Brandie Tarvin (11/14/2016)

---

AGGGGGHHHHHH!

I don't know if I'm having a language barrier issue with this vendor rep or if this person is truly this clueless.

VendorRep: Make sure to restore this copy...

sqlfriends (11/12/2016)

---

I have a truantday table that has students who has absent, each row is one student, one truant day starting from beginning of school year to current date.

I would...

rajemessage 14195 (11/12/2016)

---

following is the step:

initially some sequence is given to marble table, at that time glueid in marble table are kept null.

then one by one glue is attached to...

Dmitriy Burtsev (11/11/2016)

---

Let say you have to ETL several files to staging tables. You don't know how many tables. You don't know tables and files structure at design time.

Somebody...

SSIS packages are not compiled executables, they're just XML files.

I'm not sure for how many more years my marbles...

You've told us that you have to write a proc and I'm guessing that you want...

That's clever, Luis 🙂

OK, I think that...

For others' benefit, here's that image:

As the error message suggests, try changing this line

,'@DBName NVARCHAR(25), @BegDate DATE, @EndDate DATE',

to this

,N'@DBName NVARCHAR(25), @BegDate DATE, @EndDate DATE',

ShinyK (11/10/2016)

---

By default, the Lookup operates as an INNER JOIN - but we need a LEFT (OUTER) JOIN. Click the "Configure Error Output" button to open the "Configure Error Output"...

dndaughtery (11/10/2016)

---

Hey guys, I've been tasked with automating an excel sheet which has 2 tabs. One called "Raw Data" is where I'm loading the data and there's another tab that...