I've never used this solution - though I see no reason for any drawbacks - except, perhaps, for the ugly message that could be sent back to client apps -...

Check out this link for more info on this:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=157147#bm157159

Or you could use

where isnumeric(column1) = 0

Cheers

Phil

Depends on your table - eg does it have a key field that gets bigger and bigger with each new record? Eg if the data look something like this:

ID,...

The multiple [null] occurences are treated as duplicates: the index is therefore not unique and cannot be created as such. As far as I know, there is no simple...

Several ways to do this. One is to create a new calculated field in your Products table:

NumericID = (convert(int,right([productid],6)))

and then it's just a straightforward query to find the next...

Having a single db for multiple disparate applications sounds like a bit of a maintenance nightmare to me. I would keep them separate, but perhaps create an extra database...

Not familiar with osql, but a couple of ideas ...

It sounds like osql is adding the spaces - I'm assuming that they do not exist in the raw data? ...

Tried and failed - same as you. How irritating!

I think that the error message is spot on, just a slight change required:

INSERT INTO Catalog (fieldname1, fieldname2, ... , fieldnamenn)

SELECT

catalogID AS [CatalogID],

cSubCategory AS...

Jim, I think that the requirement here is to create not only the table, but the data too - QA won't generate this SQL.

Cheers

Phil

max(x1.Subaddeffdate) Subaddeffdate

- Subaddeffdate is an alias for the column, and this alias is used elsewhere in the query. It is referring to the same column, hence no comma.

dbo is...

A scheduled DTS package should do this for you - it can be designed to create all 20 csv files, one after another and run automatically every week. As...

Try submitting the data in the format

'yyyy-mm-dd hh:mm:ss'

Phil

OK, this is a beast, as you've got multiple subqueries to cope with the required GROUP BYs in tables linked by a LEFT JOIN. Query works in SQL Server,...