Well, that is what they want you to do. so...

It is odd while I called that from asp.net . it also told me sp does not found. It used to give me error. can't convert the string to integer....

Thx.

There are few download for that.

AdventureWorksDB is the Adventure Works Cycles OLTP sample databases.

AdventureWorksBI is the Adventure Works Data Warehouse and Analysis Services database project.

AdventureWorksLT is a very simple...

Carl:

Where the query will run ? Thx.

select *

from

(select syslogins.name as LoginName

, syslogins.sid as LoginSID

, suser_sname(syslogins.sid) as ADName

from syslogins

where syslogins.isntname = 1

) as LoginAD

-- changed or not found

where ADName is null

or...

Tried Transform Data Task before. I do not remeber what reason I do not like it. It seems right now. DTS work fine. Thx.

I changed to

BULK INSERT License_LR_Only

    FROM 'C:\Working Folder\Maria\License_LR_Only.csv'

    WITH

    ( FIRSTROW = 2,

       FIELDTERMINATOR = ',',

      ROWTERMINATOR = '\n'

    )

still the same...

I am curious why you do not use Jeff Moden's suggestion bulk insert.

Any one know Trochanteric support belt mentioned here ? Thx.

I changed the

WHERE       E.Unit =COALESCE(@unit, Unit)

  AND       D.Quiz =COALESCE(@quiz, Quiz) 

it worked. Thx.

CREATE TABLE [dbo].[OcchEmp] (

 [SSN] [nvarchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [HIRE_DATE] [smalldatetime] NULL ,

 [DOB] [smalldatetime] NULL ,

 [EMPLNO] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [FULL NAME] [nvarchar] (26) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Unit] [nvarchar]...

Thx. I did not think about union join first and left join.

Lynn;

Thx.

 the parameter should be cc. secondly the sql error is  from

SELECT     h.[FULL NAME] AS Expr1,

                      COUNT(dt.[Employe Name)

FROM         Annual_Edu_2006.dbo.HREMP h INNER JOIN

                          (SELECT     [module log].[Employee Name],

                      [Module Log].DOB

FROM        ...

DECLARE @AllNames bit

SET @AllNames=0

IF @mName ='All' AND @ccName='All'

BEGIN

SET @AllNames=1

END

and

where (h.[CC] =@ccName or @ccName='All' )  etc can simplify the code.

Thx.

thx. the case query work but

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

FROM (SELECT @EMPID AS [EMPID]) x

LEFT JOIN @HREMP_adp a

    ON a.EMPID = x.EMPID

LEFT JOIN...

a parameter of '11113' will return. since it has EMPLSTS.

EMPID  NAME  LICENSE  EMPLSTS

11113  ABCE  NULL         OC

I do not know how to write this. Thx.