without knowing the table structure for sure, something like the sql below is what you need. an inner join shows only matches...so if a company in table1 did not have...

My shop is similar to yours Tristan; we deploy upgrade scripts that add tables or columns, alter columns, migrate data, etc. Those scripts are expected to be performed on lots...

After I Saw Davids answer, I gave my head a good slap because I knew better; I had even started writing a function when David posted the right answer.;

you can use Enterprise manager to create the scripts for you;

go to design view, edit the design of the table and notice the little used button at the top named...

The answer really is no; the right way to do it is to create a new table witht he column in the middle, migrate the data to the new table,...

you might be confusing a VIEW with "dynamic tables"; a VIEW is really a SELECT statement which has been saved, and is automatically updated whenever the underlying tables it references are...

here's my suggestions.

SELECT PRODUCTCODE, CONVERT(VARCHAR(30),EVENTDATE,103) Startdate,

COUNT(DISTINCT(PERSONURN)) AS 'BILLABLE CDRS',

COUNT(*) - COUNT(DISTINCT(PERSONURN)) AS 'COUNTS',

SUM(CASE WHEN EVENTTYPE & 4 = 4 THEN 1 ELSE 0 END) AS 'CUSTOMER',

SUM(CASE WHEN...

why can't you import into SQL , and after the import is completed alter the column definition to be a datetime field, or add datetime columns and migrate the data...

I think it has to do with the filepath containing a space between 'jeff seeman' and 'Documents and Settings' as well;

so it finds the file 'c:\Documents' and fails.

if a filepath...

the problem with this is what about all those forums you subscribe to to keep abreast of questions...I probably belong to a dozen different forums for various interests.

$108 ($9 x...

i poked around the MS KB, and wow they are purposefully vague on how to fix any underlying conditions that might raise error 18; i'm going to watch this thread...

why not just grant permission just to the specific procedure, instead of a role that has too many rights?

grant execute on pr_truncate_table to webdev

it sounds to me that the file is just a SQL Server backup; at our shop we see backup files with no file extension, some end in .BAK, others with...

As you'll see in david's example above , a calculated field must explicitly name the columns to be calculated; you cannot reference fields by column order, because the column order...

When i first read this i was confused as to whether you were asking for the table design/schema, or the sql to get the data;

Assuming you already have the 3...