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...

Forcibly terminate all user processes as step 1 of your scheduled task - here's a stored proc that I got from somewhere that does this, for a named db:

SET QUOTED_IDENTIFIER...

As you are not relying on the 'inserted' table in any way, is there any reason why you don't just create a view over the dbo.assay_sample table?

create view vwUDEF_PIMA as

SELECT...

You may like to keep the new tables in a completely separate database to allay management concerns relating to upgrades of the JDE databases. This would seem to be...

First thing: do you really need

select * ...

or can you just select the fields you need?

Next thing to do is replace the subquery with a join and replace the...

I've got an idea that I've read somewhere that EM returns the results of such a query in 'batch' mode - allowing you to see subsets of results as they...

So why not create a table in Oracle that contains UPC codes from SQL Server? This should do away with all that text file business.

Part 1: ensure that the...

Ken, I'm not sure that I can picture the sequence of events you are considering. Are you saying that you would analyse the existing SQL Server data and then...

Hmmm - tough one. Is there some way that you can start maintaining a "Transfer to SQL Server?" flag against the Oracle data. You will know from the...