At the time, i did not test and put the date time variable to test. i set that as null. so no date time conversion error. Thx.

I tried this

SET @sql = @sql + 'AND CTDate <= CAST('''+@todate+''' AS DATETIME))' .

It will give me error as

Server: Msg 241, Level 16, State...

I do not know what is pc image file , too. since there are  not so many pictures files,  I renamed the image file and add extension as .jpg.

resolved the problem.  thx.

By the way, how to check the database recovery mode ?

By the way, how to check the database recovery mode ?

Thx. Today I need to take my son to visit school. I will not have time to test. I will test and get back tomorrow. Thx for big help.

I read the link you mentioned about, too.

It is hard to implement. Here what I want to accomplish ?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=315364

Thanks.

convert the data to string.

date time conversion error.

convert(datetime,CTDate)

this line

IF @fromdate IS NOT NULL                                         

 set @sql = @sql + ' AND convert(datetime, CTDate) >='+@fromdate          

IF...

but right now it is error.

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

/*.  according the due date end user select and ALTER  temp table

find the nomatch table in the occh and...

sorry the test and quiz here is the same.

test data are in the quiz log

 12799 8/11/2006 9:05:49 AM Driver Safety              

 101984 7/13/2006 Back Injury Prevention     

 101983 7/13/2006 Back Injury Prevention     

empinfo table data

emplID  CC                   unit

100912  030527100       52

101549  010206220      ...

Thanks.

CREATE TABLE [dbo].[tblCurrentWinTrainingLog] (

 [EmplNO] [bigint] NOT NULL ,

 [CTDate] [datetime] NULL ,

 [QuizName] [char] (25) COLLATE Latin1_General_CI_AS NULL ,

 [ModuleName] [char] (25) COLLATE Latin1_General_CI_AS NULL ,

 [Score] [char] (3) COLLATE Latin1_General_CI_AS NULL

) ON...

thanks. It worked after I put the select there.

Where is the SQL Server browser ? Thx.

What do you mean you need to map the server ?

I always go to the server and make the database as the name from the old server and do...

If the collation is the same, I always create a database with the same name and copy the full back up file of the database to the new server.