Here's a different twist. I find myself using more dynamic code recently because the current experience level of the people who could be expected to take over the T-SQL...

I should also ask forgiveness if I came across to anyone strongly. Sorry about that folks, I fully buy into the idea of a layer/object shouldn't know what another...

Why does everyone think we all flip companies and work in consulting. With all due respect to the consultants here the majority of projects designed by...

This sounds like someone is trying to argue one solution for the whole world.

I'm in the final stages of redesigning a system I inherited and I have to say using...

Hello. This mess came up again recently where I needed to get this working once and for all, I figured I pass on the solution and the unsatisfying conclusion

Using...

No problem. Again, thanks for the input.

No luck. Once again with the caveat that I'm understanding correctly, I did overkill and removed all comments from the current version that I'm playing with, and then recreated...

Nope, thanks again though.

I have to go off for a bit so some quick notes. The idea died on:

Server: Msg 8164, Level 16, State 1, Procedure sprSnapshotPriDepartment, Line 10

An...

Well, what I did didn't work. In the smaller of the two procedures (which has 4,886 characters) I added a few returns. The problem still persists.

Could I test...

Hello. It appears to be dying on both of the sub-procedures (working on undertanding it right now).

I do have a question, though. I can't see any way to...

Well, I didn't get rid of the temporary tables as much as I collapsed the script and the three stored procedures into one script - the DTS package worked.

Problem is,...

That would explain why I hadn't seen this issue before coming to my current position. I'll try replacing the temp tables with the code and see what happens. ...

CREATE PROCEDURE sprSnapshotWorkforceBuild @Type varchar(10) = '', @TableName varchar(8) = NULL AS

/*

@Type used to identify as either an official snapshot, HR update, or as a simple data pull

OfficialBuilds official snapshot...

CREATE PROCEDURE sprSnapshotPriTitle

AS

-- set current date variable to midnight, since snapshot need to include Distributions that end on snapshot date

DECLARE@CurrentDatedatetime

Set @CurrentDate = AcadPers.dbo.fnDateSetToMidnight(GETDATE())

-- create temporary table since data...

Well, OK. I'll post the three sprocs over three posts. Note that there are a few temporary tables, this is a situation where legibility is more important than...