SSIS can create Excel files from proc output.

If the "standards" have to be paid for, they are obviously copyrighted intellectual property. That means that following them puts you in a position of potentially violating copyright. ...

Either will work, since you won't be dividing by numbers high enough to cause rounding errors. Both are horrible ideas. Why not store the dates as dates?

And, of course, no source control or DDL logging in the database, right?

The best way to handle it is have the table DDL that adds/removes the pertinent column, be in...

I wouldn't bother with this level of complexity. Audit the tables individually. You can use timestamps and the usual Join criteria to audit related changes in related tables.

If...

Move the bit about the SIC code to the Where clause instead of the Join clause. See if that does what you need.

What is it you're trying to solve? Do you have a table that sometimes has a column and sometimes doesn't? That would be quite odd and unusual in...

Importing or exporting?

And have you checked out SSIS?

mister.magoo (11/30/2010)

GSquared (11/30/2010)

... the part that says:

1 duplicate record occurs ONLY in p table and none of the duplicate records have a reference to it in pic table:

- all records,...

First, rebuild the table so it's rows instead of columns on the multiple phone numbers. That's going to make things easier and better in the database all around. ...

Not really. Since you need data compression at both points, you're pretty limited on your options.

The best solution would be to fix the data structure so you have the name separate from the e-mail address. That allows 1 person to have multiple addresses, if...

Update before you run and you should be fine.

You're welcome.

Batch files from a scheduler is how I'd go about it, except I can't think of any reason I'd ever want to reboot a server on a fixed schedule. ...