Please post the query that is generating the error and details of how it is submitted - eg are you using a pass-through query in Access?

You may be receiving the...

Try this in Northwind (try varying the table_name in the WHERE clause) and you should be on the right track:

select a.constraint_name, b.column_name from information_schema.table_constraints a

inner join information_schema.constraint_column_usage b

on a.constraint_name =...

I actually think that the JOIN method will execute faster than the subquery I proposed. However, the subquery method is easier IMO to write and I had a hangover...

Hi Karen

This should work:

DELETE FROM [SD_Order_Dev].[dbo].[ProjectDemand]

WHERE

dbo.ProjectDemand.ProjectNumber in

(select ProjNum from dbo.CADFilePath)

Phil

Jack, please do not post the same query on multiple SQLServerCentral forums.

Others, please refer to

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

for original post.

Your application sounds fairly standard in architecture (though what do you mean by 'agent', exactly?). Please be a bit more specific - what issues/problems do you foresee?

Phil

Please post some sample data - both source and how you would like it to look after processing.

If your question is: "Is it better to have a single table with the capacity for multiple addresses in a single row, or one master table linked to an address...

Correct, it doesn't - would be damn useful though.

Your use of CAST is incomplete. Do you mean

cast(b.begindate as datetime) perhaps?

Phil

Are you suggesting that you will need to store long strings of narrative? Will you need to perform any structured analysis on the data, or do you just need...

Yep, me too. Read it about 5 times & still getting nowhere!

If you are thinking about passing the entire SQL string as a parameter of the stored procedure, what is the point of even having the stored procedure? Why don't...

It's only brutal if the users are actually working at the time.  If you reread the original post, the suggestion is that the users who are still logged in on...

Not sp_delete_job and sp_delete_jobschedule, presumably? Is it that you want the final part of your job to be self-deletion?

Phil