Yeah, that's why I create a Common database for that kind of thing.

Yeah, I saw that part of your Catch, but wasn't sure if it was what I was suggesting or not. If it is, wonderful, we had the same thought...

You can use dateadd, or, because of the way DateTime data is stored in SQL Server, you can simply subtract from the date.

(DateAdd is in the prior example.)

and p21_view_invoice_hdr.invoice_date <...

One thing I recommend is create a proc that handles the logic of your generic error handling. If you find that every catch block you write has "select error_message()...

You have a couple of options.

One is to roll the business and customer tables together into one table, with a type column that indicates which ones are which....

The only thing I can think of on this is parameter sniffing.

If address type only has two values, in over 1-million rows, then indexing it isn't useful. You'd probably be better off partitioning the table into two tables, one for...

How unique does the random number need to be? As in, if someone or some process gets 10 today, then 10 can never, ever come up again, or as...

You can't set them that way in the data source in SQL, but you can either set the IsHyperlink property of the display, as mentioned above, or set an OnClick...

Tech_Newbie:

The place to start is with the files themselves. The main question is, do they have anything resembling a standardized format? Like, all the text files have the...

Oddly enough, I've never had any trouble at all getting managers to recognize tallent. I have, however, had tremendous trouble translating that recognition into anything that can go into...

insert into Employee (pg)

select pg

from Qualification

insert into Employee(street, city, state)

select street, city, state

from Address

Does that do what you need?

Trader Sam (5/7/2008)

---

Oh yeah, this is the same Microsoft that recently stated they can't find enough qualified workers in the US, and they say we have to import IT help...

Actually, if it's a repeated import with complex manipulation, you have another option which is to set up the Access database as a linked server, and do the whole thing...

I can't help you on that one. I have no clue how to go about bypassing the database engine and reading the data directly from the file.

(I have to...