I agree... breaking up a proc/script just to control size is a bit stupid but using GOTO, as you suggested, isn't the way to do it.  CASE and IF BEGIN/END is...

I know that, John... what are the statements?  You may not need the loop at all!  Loops are a form of RBAR and generally defeat the power of an RDBMS!

I suspect that part of the reason that it's taking so long is because of the self join during the insert... the criteria may have to be reevaluated after every...

"doesn't seem to lend itself to any sort of structure"???

As Serqiy said, you can create stored procedures that act as "main" routines that call other sometimes reuseable stored procedures as if they...

{insert theme song from Jeopordy here}

Get 'em Serqiy!

John,

What format is the p.Termination_Date column in?  Because it's a CDR, I'm thinking it's probably in the YYMMDD format but want to find out for sure before I spend any...

A far better question would be what are you going to replace "PRINT 'BOY'" with and why do you think you need a loop instead of a setbased solution.  Perhaps...

One way to do this is to pass the local date and time from the client to a stored procedure on the server where the data lives...

This should give you...

Daniel,

As I said on the "other" forum...

I don't think you can because "plaza" and "boulevard" are both street types.  Plus, there's all sorts of permutations for addresses.  It...

David, I think you posted the wrong URL... The one you posted is for THIS thread...

Thanks for the feedback, Ryan.

Value is one of those reserved words that may give you a problem... Name is more forgiving.  You may have to use some quotes or brackets around the word "Value"

Not sure what I'm missing here... As you said, load the file into the staging table and check the table for the necessary columns/permissions, etc.  If they're wrong, just empty...

One more thing... this isn't Oracle and you don't need a ref cursor to get a return... I'm fairly sure that OLE DB and ODBC in conjunction with ADO both...