Let's start over and go slowly.

Does your SELECT query display the results you expect when you run it without the INSERT statement?

If so, please post up some...

The following code could be incorporated into a stored procedure, user defined function, or an inline table valued function.

declare @input varchar(max)

declare @count int

set @count = 5

set @input = 'The skilful...

If PREMPL table is large, I'd bring the employee master data over. But you said your join was running acceptably fast?

SELECT convert(int,Empno) as Empno, other columns.....

INTO #Employee_Master

FROM SQLSERVER.SourceDatabase.dbo.Employee_Master...

Exactly. In the current loop, if the download fails for a particular db, we just log the error and move on to the next in the list. ...

Emperor Paulpatine,

XML makes db design much simpler too:

create table XMLTable (ID bigint, Data xml)

If something breaks in the middle of a loop, how is it different from breaking in the middle of one long sequential job with multiple steps? Either...

Steve, if I'm going to loop at all, I do a WHILE because I'm told it's bad to leave a cursor open if anything breaks. No danger of...

I do that when building batch tests of stored procedures, Jeff, but a WHILE loop through a table of 20 or so rows is going to run fast enough that...

A quick trick I stored in my cookbook.

I think I originally got it from one of Jeff's articles on concatenation.

declare @sample table (ID int, PID int, FILE_NO...

I was looking for "MUCK"[/url] to be an option.

"Open Schema" makes it sound like a legitimate approach to database design.

Just for fun. 🙂

select dateadd(ss,1296001,dateadd(month,datediff(month,0,getdate())-1,0))

Classic first day of previous month plus seconds equal to 15*24*60*60+1.

We have stored procedures somewhat similar in nature that pull data from a number of similar databases into a single database. They are driven by a while loop...

No accountants, how about statisticians?

Good luck, man.

Can you get a GMAIL account and use Google authentication, Roy?

Wayne, can you at least take escalate this within your organization to say the quality of the work that has...