Hopefully @Tablename cannot possibly be a table which contains 10 million rows each...

x 45204 (1/8/2015)

---

Hey

First time here, but have been enjoying the articles for some time now on this site.

But got a query question - I am trying to make a query...

Assuming you are not also new to Google, please try searching there and then come back here with any specific questions you may have....

Perhaps you can (incur yet another performance hit and) use LIKE?

Can you explain how one of the opening balance results is calculated please, from the sample data?

Eg, you have -449999.60 for (LDGR_ID1, 2014-10-01, 4).

Oliveoil (1/8/2015)

---

The 2 days should be a good motivation to move all the stuff to another cloud-service and never look back... 😉

Just got a business-idea: The meta-cloud! :-)) A...

I think that this query is complex enough to warrant a request for sample DDL, data and desired results. I've reread it a couple of times and still don't fully...

Koen Verbeeck (1/7/2015)

---

Phil Parkin (1/7/2015)

---

mrtrich99 (3/27/2013)

---

just like most people suggested, i now request for pipe delimiters,...

mrtrich99 (3/27/2013)

---

just like most people suggested, i now request for pipe delimiters, but sometimes I do...

A brief Google search turned this up.

Maybe the instance is not running in 'mixed' authentication mode?

The best way to do this, IMO, is to move processed files/folders to an Archive folder somewhere.

Then your FEL can remain as it is, picking up everything when it runs...

If something is non-deterministic, then it's very possible for the re-evaluations of the object test to miss all of the WHEN's and produce a NULL if there is no...

Thanks for posting back and I'm glad it worked out.

Sounds like the dev might have hard-coded something into the package which is not being overridden by the config.

I'd spend a few minutes editing the package to see whether you...