Because in the first case you are not comparing dates but char values, see the following example: -

select t.[c1] from

(

select 'a' as [c1]

unionselect 'b'

unionselect 'c'

) t

where t.[c1] between 'a' and...

The first approach won't work, the second will. Try declaring a variable first then assigning the TSQL statement to it then executing e.g.

declare @u varchar(200)

select @u = 'update '...

Try: -

update t1

set

t1.phonenum = t2.phonenum

from

table1 t1 inner join table2 t2 on t1.sno = t2.sno

Regards,

Andy Jones

Investigate using DTS (You could also use the bulk insert TSQL command or the BCP command line utility).

Breifly in DTS you would need 2 connections (file and database) then a...

Hi, try this article: -

http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp

Regards,

Andy Jones

Possible, but performance would be poor on a large table. You could maybe trigger the integer part into another column when inserting / updating or simply insert / update into...

Hi, you could incooperate the logic above in a UDF, although in 6.5 not sure??

Regards,

Andy Jones

Hi, try this: -

declare @AlphaStr varchar(10)

,@RtnStr varchar(10)

,@i int

select @i = 1, @RtnStr = '',@AlphaStr = 'a2c123'

while @i <= len(@AlphaStr)

begin

if ascii(substring (@AlphaStr, @i,1)) between 48 and 57

begin

select @RtnStr = @RtnStr +...

Hi, try: -

select * from TblData where CONTAINS(TxtData,'"ASP*"')

(i.e. '"ASP*"' and not 'ASP')

Regards,

Andy Jones

I know you didn't want a solution but I saw this which may be of interest to someone: -

http://www.microsoft.com/sql/techinfo/tips/development/ensuringnonnull.asp

Regards,

Andy Jones

Edited by - andyj93 on 12/20/2002 02:47:30 AM

What edition of SQL Server are you using and what operating system are you running on? Also check that the Microsoft Search Service is running.

Regards,

Andy Jones

I think the point was just being made was that using a trigger performs two writes to the database and not one (one to insert/update the record and then one...

Does the latest article offer any help?

http://www.sqlservercentral.com/columnists/glarsen/collate_part1.asp

(If not, this article also mentions a part 2 which may be of more help).

Regards,

Andy Jones

Are there any locks on [qry_door_codes]? Does this only happen for [qry_door_codes] or for other tables/views?

Regards,

Andy Jones

The osql command prompt utility can output to a text file. You can execute from TSQL using the xp_cmdshell extended stored procedure.

Regards,

Andy Jones