Glad you got it working ezlikesundaymorning-573799, but I'll have to follow up with a few comments as well. I fully understand your point of view that you are coming...

Hah, you're not kidding. It was like a 7 hour dry spell across all the forums I watch. I figured it had to be actually broken, that's way...

Welcome back. Just as a refresher, you might want to take a look over the article on posting sample data in my signature for any future posts.

If you're going...

You can probably hack something together with sp_helptext(which gives you the code of a stored procedure) or find a script online to do it.

You can use SSMS to generate scripts for all the stored procedures and then execute it on as many servers as necessary. That's not doing it through straight T-SQL,...

You're still using ODBC drivers coming the other way though aren't you? Via system DSN's? It's definitely not an exact match the article and you're probably right, it's...

Hrm... while your problem does not exactly fit this, it's a close enough parallel that the work around proposed for this might be worth trying.

http://support.microsoft.com/kb/936223

Is it an option to attempt...

I personally nest all update/delete statements to real data in transactions as well, just to be extra cautious.

something like:

BEGIN TRAN

--Your Delete Statement

ROLLBACK TRAN

--COMMIT TRAN

Is that the only error or is it followed by an error 107 as well?

Joe's code could also be made into one statement like this:

update @rank_test

set sales_man=

CASE WHEN (id+3)%4=0 THEN 1

...

My pleasure Alan, thanks for the feedback.

Unfortunately, I'll have to guess at what 'and so on...' means, but this should point you in the right direction:

; WITH

t1 AS (SELECT 1 N UNION ALL SELECT 1...

You should be able to use the same method, but the logic will get slightly more complex. Post back any specific questions if you have difficulty adapting it.

sherifffruitfly (11/27/2009)

---

I'm no sql genius or anything, but is anyone concerned that the poster apparently has 2+ versions of the truth running around in his or her database?

Besides the technical...

Very nice, and very close. A slight alteration will give you what you need.

; WITH

t1 AS (SELECT 1 N UNION ALL SELECT 1 N),

t2 AS (SELECT 1...