but I think back up did not give me the DTS pacage, the connection.

Thanks. It is cool. I know this function. but I do not know why Microsft come out as CoALESCE as Returns the first nonnull expression among its arguments. while...

If I have two fields I want cancatenate by adding lastname, space firstname.

ABC LastName

EFC

I want to my outcome as LastName, ABC and EFC since the EFC does not have last...

Thanks. but I do not know why query is right which post on the other website.

I set that as string. Even though I set my criteria directly and it did not return any value. My vb.net code work with two parameters. so I suspect the...

Thanks. I changed the

if @mName ='PartI'

BEGIN

    set @moduleName  ='Part I'

                          SELECT DISTINCT  LicenseNumber  , DoctorName

                            FROM          dbo.[Doctor Module Log]

  Where  (dbo.[Doctor Module Log].[Access Module Time] >=...

The problem is not join. Once I took off the right. It worked. Thanks.

I put a begin there before. It still have the error.

RIGHTNOW IT IS END HAS ERROR. Thanks..

Server: Msg 156, Level 15, State 1, Procedure get_phy_list, Line 30

Incorrect syntax near the keyword 'END'.

CREATE PROCEDURE [dbo].[get_phy_list]

 @DateFrom datetime,

 @DateTo...

Thanks.

I have one running stored procedure. I did not put the () there ,too.

The errro is this line. I think it must be single code for @moduleName    Thanks.

SELECT  *  from  ...

What is the purpose to run Try running DBCC UPDATEUSAGE(0) then running sp_spaceused in this case.

You just need to set the field as text.

I got error from 'SUSTRING' is not a recognized function name.

I got error from 'SUSTRING' is not a recognized function name.

Here is

if exists

(select * from dbo.sysobjects where id = object_id(N'[dbo].[login]') and...