That would be the expanded format where the have a indicator for century, thanks to the y2k rollover. Your date you give reference to would tranlate to the 94th day...

Although this is highly debatable due to the fact that query optimizer handles the re-order in this case (as you can see in the execution plan), I will say that...

They are more than just theories. They are correct. The function fires for each and every row affected, and this would make the execution plan displayed practically useless. I know...

I've seen this situation in a lot of financial companies who were used to using spreadsheets. In my case, it always resulted in a lot of tedious coding, as there...

Is this a Sr position? And is it perm?

If you don't mind having a table of dates, you could use a set based solution.

Create a table containing every date for 20 years or so (a good wide range),...

Look up sp_articlefilter and sp_articleview in BOL......

Best way I know of scripting a proc dynamically with code is to use sp_helptext 'ProcName'

you can loop through your objects to provide the objectname of the proc. Works great.

Only...

What you say is exactly true jensk. I gave an abbreviated explanation which could have used much explanation, which you provided. I assumed that the page locks he was seeing...

JDE does not use traditional julian date format. What they use is actually a five digit representation of YYDDD which is the two digit year (03) followed by the day...

LMAO.... I just posted this in another thread but here you go anyway...

If you perform the replication by use of the system procs and scripting, as I do, there is...

If you perform the replication by use of the system procs and scripting, as I do, there is an option called schema_option which determines how the end tables are created....

The performance hit is really determined by how large the profile is. I generally limit this particular one to object scans, procs completing, and statements completing, and delimit the database...

Previous to version 2000, what he says is absolutley correct. And I have found many instances in 2000 where it doesn't do the optimization that I would have expected, so...

Absolutely. This will distribute the actual inserts across the table rather than causing them to all hit the last page, and increase concurrency in your inserts as well.

If your...