No sense in me taking something I would fail... remember, I'm the guy that ripped one off during an...

Marios Philippopoulos (3/19/2008)

---

OK, I hear poor old table variables sobbing in a corner somewhere, so I have to step in here...

I should mention, while we are on the subject,...

Would you share what you figured out, please? We'd like to know how you did it.

TonyP (3/19/2008)

---

Well, it is not exactly inserting each application file into many tables. It is more like taking information out of the application file and sending it to a...

Now, there's something I agree with... that's why the "shop" needs a...

I sure do understand that... politics and education, profit and learning... frequently, they are diametric opposites.

Grant is pretty much spot on... you're probably an absolute Ninja at Oracle and...

Heh... I'm just going to assume that you meant "Jeff"... 😛

When I originally read your solution, it seem like you got the impression that I was looking to take...

Heh... you mean besides "impressive" 😀

If I were you, I'd list the following in my objectives on a resume...

Manager/Director of IT/MIS

Hybrid DBA (Systems/Application/ETL)

Data Architect/Modeler

Certified Instructor/Mentor

If you don't want to be...

yep... that and if Crystal Reports is on the server, dunno if it still does this but it used to leave 1 file per page rendered and never removed them....

By that, do you mean it uses a DROP TABLE command, A DELETE statement to remove all rows, or a TRUNCATE to remove all rows?

Tony, let's not build this one little requirement at a time... how about posting a whole user (like I asked before, no private info, please) so we can help you...

Heh... did I make ya blow coffee out your nose, Matt? 😛

Heh... yeah... nothing like the "TimeStamp" data type here... isn't hind site wonderful? :hehe:

Heh... Hence the name... varDECIMAL 😛

No link required, actually... The term "Well formatted" should be common knowledge. But even if it's not, here's what your text attachments look like because you have no carriage...