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

Sorry for asking the bloody obvious, but has tempdb been deleted? As you cannot start the SQL Server service, check in Windows Explorer for existence of C:\Program Files\Microsoft SQL...

Yes - Print does an implicit conversion to char or varchar if it can.

Phil

I think it is the cast to varchar where you are losing data. Try using the STR() function:

DECLARE @a as float(53)

DECLARE @DynSQL1 varchar(1000), @DynSQL2 varchar(1000)

SELECT @a = 367970.45

SELECT @DynSQL1...