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,...

I think I understand what you are getting at, but some sample data highlighting what you are currently getting and what you want to get would help significantly. To...

It's pretty complex, but your problem might be in the WHERE clause, specifically the

WHERE (((t2.Subrouteeffdate)=(SELECT ...)))

bit. If you have a record in t1 with no matching record in...

Maybe! Please provide more detail about what you are trying to achieve, as it isn't clear from your post.

Thanks Jeff - do you have any examples of this?

Phil

As far as I know, there is no native support in SQL Server for rolling back specific transactions, though I believe there are third-party tools that can do this.

But a...

It looks like you want to round down in all cases - this code should do the trick:

declare @a varchar(100), @b-2 varchar(100)

set @a = '0.4567777777778999999999345677777777777777777'

set @b-2 = '10.3456789002322222222222545465565767888888888888888'

select cast(left(@a, charindex('.',...

First point is that the result of your example equates to 1%, not 5%

Secondly, there is no explicit 'percentage' datatype. Not that...

OK - may not be a great design, but it's very a common way of doing header/detail relationships.

So you now have several accounts which have got 19 header records but...

How is the DocID field (the primary key?) in ac_docdetail generated? Is it an IDENTITY field?

Regards

Phil