Can you join a resident table to a sql table?

[denwo2010]

Hi,

Can you or how can you join a resident table to a sql server table? I have the below query but does not work and not sure if it can be done?

EngCalendar2:
LOAD [Engineer ID],
CalendarKey,
[Eng Date],
[Eng Week],
[Eng Month],
[Eng Year],
[Eng Day of Week],
[Std Hours],
[Avail Day Flag],
HOLS,
UNAV,
DOCT,
SICK,
SITE,
TRAIN,
[Min Arrive Time],
[Max Leave Time],
[Worked Hours],
[Worked Day Flag],
[Extra Day Flag],
[Extra Day Hours],
[Unavailable Days],
[Total Unavail Hours],
[Paid Time],
[First Name],
[Last Name],
[Person Type],
[Person Group],
[Person Class],
EmployedFlag,
[Engineer OSG B],
[Engineer OSG C],
[Engineer OSG D],
PersonCategory
resident EngCalendar;

left join (EngCalendar2)
LOAD personid as [Engineer ID];
SQL SELECT p.personid
From SCHDimension.dbo.dimOUTUser p
WHERE JobTitle = 'IC';

This is the error I get:

Table not found
left join (EngCalendar2)
LOAD personid as [Engineer ID]

Thanks

Denis

[#2]

Hi,

Try put tha command NOCONCATENATE before table EngCalendar2:

Ex.:

NOCONCATENATE

EngCalendar2:

LOAD [Engineer ID],

CalendarKey,

[Eng Date],

.....

Does exists any table create before you declare the table EngCalendar2???

[#3]

Hi Eduardo,

be sure you don't have already another table like EngCalendar2 named for example EngCalendar but having exactely the same structure.

If it is, EngCalendar2 is seen like EngCalendar and store in EngCalendar. That makes EngCalendar2 doesn't exists

best regards

christian

[llauses243]

Hi,

This is my offer ... replace 2 lines by one (see attached)

Good luck

/Luis.