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

If it's not slow on all the servers, then you may be having some router or hub problems.  For example, if the port and card the server is on are...

Juan,

I'm a bit confused.... you say the users are going to do deletes, sorts, filters, and analysis but you have concerns about their capabilities with the software (Access)?  I'm thinking...

Thanks David... and I agree, but it's nothing quite so serious... our standards currently have some fairly strict naming conventions that do not include Hungarian Notation (except for the letter "p"...

If you need a text column for Results, tell me why this won't work...

select RGnameLast+', '+RGnameFirst AS Adjuster, RGnameLast, COcity AS ClientOffice, IOofficeName, WRworkOfficeId,

WRid, SRnameLast+', '+SRnameFirst AS Subject,

CONVERT(CHAR(8),...