Derek Robinson (6/20/2012)

---

It would have helped us respond to you quicker if you'd kindly posted a table create and data insertion SQL. It would also have cleared up any assumptions...

L' Eomot Inversé (6/20/2012)

---

The thread seems very quiet. I've been away three days and there are only 62 new posts on it.

But I may not find...

Rekonn (6/20/2012)

---

Hi, I need to take a stored procedure that currently returns a simple and small record set, and change it to return JSON as an nvarchar(MAX) instead. There seem...

And that is just a brief, 100,000 foot view. There is much more that could be discussed.

Data normalization is not done for speed. It helps to eliminate data redundency, and potetially various update anomilies that can occur. Sometime it is necessary to denormalize data...

Verify that the user has appropriate permissions to the server.

Okay, looks like a login failure: Login failed for user 'domain\x-yz$'

Glad we were able to help.

How you implement this in reporting services or JD Edwards code, I'm not sure. What I provided can be used in T_SQL queries.

Unless you are auditing for this, I don't think it is possible.

And to convert a date >= 1900-01-01 to a JD Edwards Julian date:

DECLARE @ThisDate datetime;

SET @ThisDate = GETDATE();

SELECT (YEAR(@ThisDate) - 1900) * 1000 + DATEPART(dy, @ThisDate);

Here is a better way:

DECLARE @jdejulian INT;

SET @jdejulian = 112074;

SELECT DATEADD(dd, (@jdejulian % 1000) - 1, DATEADD(yy, @jdejulian / 1000, 0));

Working on another way at this time as well.

Try this:

DECLARE @jdejulian INT;

SET @jdejulian = 112031;

SELECT

DATEADD(dd, CAST(RIGHT(RIGHT('0' + CAST(@jdejulian AS VARCHAR), 6),3) AS INT) - 1, DATEADD(yy, CAST(LEFT(RIGHT('0' + CAST(@jdejulian AS VARCHAR), 6),3) AS...

Don't know what a JD Edwards Julian Date is so I couldn't at the moment.