im getting an error whn i execute the query.......'tablename is ambiguous'

any ideas why?

If riding in a plane is flying, then riding in a boat must be swimming. To experience the...

actually, just read up on that..thanks guys.. ill give it a go and it looks like it should work..appreciate it

If riding in a plane is flying, then riding in a...

there is only one table.............

[/quote]

If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

What is 't1'??

DELETE MyTable

FROM MyTable t1 INNER JOIN MyTable t2

ON t1.Unique_ID = t2.Unique_ID

AND t1.DateField < t2.DateField

[/code]

This will delete all the records for a...

Dunno mate,I presume its whats in the temp table...

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

[/quote]

If riding in a plane is...

any ideas?

If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

Forgot all about that one actually! anyway, still got the same problem, refiner.exe is installed on the server and no user input is required. Just cant seem to see what...

dont think so Frank! Do you have any ideas? Youve been my saviour! 😉

If riding in a plane is flying, then riding in a boat must be swimming. To experience...

I have the following command:

exec master.. xp_cmdshell ' \pcplus\refiner.exe'

to run an application. when i execute it query analyser crashes. Any ideas why?

If riding in a plane is flying, then...

Take the following:

insert * from tablename

Is there a clause which enables me to insert all fields but one,rather than specifiying each of the fields by name and omitting the one...

Do you mean BEGIN at the very beginning of the statement and END at the end or two lots of BEGIN and END for each condition?

If riding in a plane...

Is using VB and chart controls a big task? I have basic/intermediate skills in VB..is it easy to pick up and utlise with SQL server?

Cheers Frank!

If riding in a...

no....no additional fields.......

If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

As I suspected, tried with spcific columns but still the same error..............

you know when something REALLY gets to you...;)

If riding in a plane is flying, then riding in a boat...

ive inputted the following:

insert into customer

select * from clnpers

WHERE NOT EXISTS (

SELECT * FROM customer WHERE

customer.cust_id = clnpers.cust_id

AND customer.rec_fname = clnpers.rec_fname

AND customer.rec_sname = clnpers.rec_sname

AND customer.rec_bday = clnpers.rec_bday)

and...