the ordinal position CAN matter. Not everyone writes good SQL or applications and you can often fid yourself with "Select *" or "insert into x select *" in which case...

using convert(real,0.10) will give you the correct answer, but only because the precision is lower. - you may still get the same problem...

you might try creating this as an inline...

i wish - i'm in the office

select convert(float,rate)

however float is an approximation, so beware the type conversion - you may find some = operations do not return the results you would expect.

you should also be aware...

can you post the structure of AHDPROD.call_req and the indexes that are on it

yes - something like

sp_configure 'allow updates',1

go

reconfigure with override

go

alter table mytable add column col3 char(1) NULL

go

update syscolumns set colorder=5 where name='col4' and id=object_id('mytable')

update syscolumns set colorder=3 where name='col3' and id=object_id('mytable')

update syscolumns...

last=

select top 1 * from mytable order by myfield desc

first=

select top 1 * from mytable order by myfield asc

??

C++ is one of the most efficient object orientated languages microsoft offer, however it's also proboably the most difficult of the languages MS offer, which means that developers have...

i assume you're looking for someting a little more complicated than

select * from family where id_ancestor_m=123456

you're looking for a complete chain of descendants rather than just the children??

are you...

do you have an identity on the tables ? if so you can't assume the sql will ignore this column

try the following

rather than

insert into tablex select a,b,c...

hi colin - wonder which company that was??? sounds like the one we've both contracted at ???

but why ? setting to simple and then back to full acheives nothing other than forcing you to take another backup to start a new LSN chain.

what does setting to...

i vote for pre-recorded...

the point of attenting one fo these sessions is to listen to the man making the speech.

the point of visual aids is to assiste the man making...

what on earth are you doing jdixon?

if you set recovery simple you risk breaking the LSN chain so that reverting back to recovery mode full will be useless

you don't need...

and to find the log file number do the following

use isalog

go

select * from sysfiles

look for the log file and replace the first number of the above command with teh file...