YEP your code here works perfect ... and I'm still working to retrieve the results from my table but nothing the results are zero!

I'm trying...to find the solution ...interesting why...

Yes

There is the structure of the table:

TR_ID NVARCHAR(15)

TR_YEAR NVARCHAR(2)

TR_OFFICE NVARCHAR(4)

TR_DATECREATED DATETIME

Sample Data: ...

ALZDBA

Thank you, you are brilliant with your codes here ... I confused and I'm just looking what happened ...I will try later in my table couz no way to find...

I cannot understand how to find the solution here, I'm doing it also when I export the data in Excel and using the function for comparing!

Is it possible to generate...

Jeff Moden (9/13/2008)

---

Not quite the business reason we were hoping for. 😉 There are several solutions depending on the requirements of a...

Should I collect data from WITH clause or where to put my column for compering!

Interesting ... but little bit confused couz for the moment I haven't any idea how to use it in my column ...my column is not datetime it is just a...

michael.bertelsmeier (9/12/2008)

---

I think there are two possible solutions.

1.

WITH Data (DataType, Name, Salary, K_DATE)

AS (

SELECT 'Lider', LiderID, LiderSalary, K_DATE FROM #tmpPoorlyDesignedTable

...

Yea Happy Birthday Steve ...have nice day and all other birthdays of your lifetime!

😉

HI again anyone has any idea how to retrieve the correct results from the situation that I posted above in my last post!

thnx !

:crying:

hello again,

the code is the same:

IDK K_DATE LiderID LiderSalary Assist1 Assist1Salary ...

But little problem is coming...I have the date and when I add it the records going to calculate the null values during the Union data...how can I add the Date...

Hi there...yesterday I was so tired so today I found the solution also for the MS Access comparing the code above...so everything is ok and now works perfect!

😉

Michael Earl

Thnx very much ti works perfect ...so thnx again!

just a little question if it any possiblity to implement this in MS Access, I found the solution to link it...

I know the risk if I work with only Fname for that reason I'm looking the solution to work with combination of FName and SName as FSName in both tables,...