Ok, I was wrong.

Jan

Jeff and all others,

I have helped a lot of people here, but this game is becoming too anoying. Why should I continue this child play?

1) Would you be so kind...

Hi Jeff,

Sure my code works! I never post anything without testing it first. It is of course possible that we misunderstand what is needed, but even that is not the...

Yes, I also changed the quantity to a constant 1 in the query, but I forgot to color it....

SELECT     NBillingF.OrderNumber, NBillingF.Customerorderreference,

  AccountOwner.company, NewCARORDER.Orderaddressline5,                     

  customers.company AS Expr1, NewCARORDER.Orderaddressname,

  Product.[Manufacturer Part Number], ...

SELECT     NBillingF.OrderNumber, NBillingF.Customerorderreference,

  AccountOwner.company, NewCARORDER.Orderaddressline5,                     

  customers.company AS Expr1, NewCARORDER.Orderaddressname,

  Product.[Manufacturer Part Number],  Product.[Product Description],

  1, NewCARORDER.SystemOrderDate,

  NBillingF.DateInvoiced, NBillingF.Unitprice,              NBillingF.InvoicedValueBase

FROM         NBillingF INNER JOIN AccountOwner

    ON (NBillingF.Customer = AccountOwner.account)

   INNER JOIN NewCARORDER...

In that case, the identity will just increment as it should. Mind that there is no specific order in Table2 and I am not sure that an ORDER BY will...

Hossein,

The insert will only be allowed if this setting is set:

SET IDENTITY_INSERT table1 ON

and with explicit columns:

INSERT INTO table1 (col1, col2)

SELECT col1, col2 FROM table2

GO

SET IDENTITY_INSERT OFF

In this scenario the...

Hi Tymberwyld,

An int is 4 bytes and a datetime is 8 bytes. The smaller your datatype, the more you can get on a page and the better use of indexes...

I replied on:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=367397

I think most users would agree that it is annoying to post the same question in several threads. This is not helpful for other people who are...

David,

My solution did not show a duplicate. I just added a second employee because you were mentioning that you needed a group by employeeId; but in your test data there...

I have already posted the result in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=367397

Maybe it is better not to post the same question in 2 threads.

Jan

use

tempdb;

CREATE

TABLE test( EmployeeId int, Freight decimal