bteraberry

Edited my post to note my assumptions - per your comments at 5:40 PM

Here is a step by step conversion of the application format to SQL format

** Note this assumes that the application is passing the date in char format not some...

june.troxel

In order to get a tested solution to your question, please post table definitions, sample data and required results. To assist you in doing that please post as outlined in...

tsmith-960032

In order to get a tested solution to your question, please post table definitions, sample data and required results. To assist you in doing that please post as outlined...

Nevyn Posted Yesterday @ 11:27 PM

Basically the same thing. Note that adding the AND derived2.A_ID =b.A_ID to my original will also fix the issue of duplicate B_IDs throwing it off....

Nevyn

I asked the OP a question :

Another question. What defines the first row in Table B? Remember there is no explicit guarantee that rows return by a SELECT statement are...

Nevyn changed my create table statements to use your table names and ran your code:

SELECT *

FROM Table_A a

LEFT OUTER JOIN

(SELECT...

Nice question

Source for the above quote:

http://download.microsoft.com/download/5/7/1/5718A94A-3931-457B-8567-AA0995E34870/ReleaseNotesSQL2005SP3.htm#BKMK_SetupIssues

Also read:

http://download.microsoft.com/download/5/7/1/5718A94A-3931-457B-8567-AA0995E34870/ReleaseNotesSQL2005SP3.htm

Alvin Ramard

You know what upsets me about this issue? Lots of companies would not have any second thoughts about doing this with SQL Server but wouldn't dare do this with...

I revised table B by adding a column and an additional vaue of A_ID:

CREATE Table #B(B_ID INT,A_ID INT,City VARCHAR(5),State VARCHAR(2),Zip VARCHAR(10),Entered DATETIME)

INSERT INTO #B

SELECT...

OP reposted at

http://www.sqlservercentral.com/Forums/Topic961609-1291-1.aspx

helpdesk-1100431

First of all to get tested answers please post your table definitions along with sample data as outlined in the first link in my signature block. It would...

OOPs posted incorrectly -- hence removed...

Do you mean unable to copy and paste the T-SQL into SSMS for testing or

it can be cut and pasted but returns...