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

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