David;

right now I added Status in the license table.

SELECT x.EMPID,COALESCE(a.[NAME],'') AS [NAME],COALESCE(l.LICENSE,'') AS [LICENSE] , COALESCE(l. EMPLSTS,'')

FROM (SELECT @EMPID AS [EMPID]) x

LEFT JOIN HREMP_adp a

    ON a.EMPID =...

David:

Thx. Your query is working. If I added the condition on the license which I have two field verify and not expired. how will i write this query. Also as...

Do understand this part:

(SELECT N'111111' AS [EMPID]) x

LEFT JOIN @HREMP_adp a ON a.EMPID = x.EMPID

LEFT JOIN @License l ON l.EMPID = x.EMPID

where those @HREMP_adp variable come from...

this one is working with similiar syntax. It seems it did not consistently. Today I checked the data, just find that out. but I tested. It work well. 

Not sure about

in this link metion about

Transactions that involve table variables last only for the duration of an update on the table variable. Therefore, table variables...

Since I am new to SQL server DBA, too. If I understand well about this.

Check the min and max ram assigned to the SQL Server. Make the minimum less than...

the title is Problems In Building a Data Warehouse.

David:

Will you please explain to me why you use max here ? Thx.

I did Exec sp_changedbowner 'sa' to my database and refreshed the table and check in my object browser. I still have the table as dbo.tablename. I might not understand well...

she said an user tried to enter an application and it displays an error message. i do not know whether she need to set up the application account to...

since it is money , why not return value as money, too.

since it is money , why not return value as money, too.

in practice, if it have so many join, it will really slow.

ALTER           PROCEDURE dbo.DueListWithPreviousTraining_Temp

@quiz VARCHAR( 25 ),

@fromdate  datetime     = NULL,                  

@todate    datetime     = NULL,

@unit    nchar(5)     = NULL,

@cc   nvarchar(4000) = NULL,

@debug     bit          = 0

as

DECLARE @sql        nvarchar(4000)                         

begin                                                                  

Set...

yes.

1. find the most recent quiz empl take

2. not in the current training table.

-->get the due date.