Thank you so much for that thorough explanation and for your kind and encouraging words. I understand much better now! I'm going to read it a few more times to...

Ok, this works, but it's the ugliest thing I've ever seen. Surely, there is a better way. Keep in mind I'm trying to get the 9.5 to an NVARCHAR because...

I feel really stupid that I cannot figure out this CAST issue. I have a situation where I need some records in a column to be INT & some to...

This script is very helpful and it's close to what I need but not quite. I need the week# and month# to be built off the startdate parameter.

So, my client's...

Well, I thought I could use that article to get what I need, but it's still not quite right. This is my ultimate goal:

DECLARE @CycleStartDate DATETIME='09-16-2014'

, @CycleEndDate DATETIME='10-26-2015'

I am...

I think I found my answer in a previous post!

http://www.sqlservercentral.com/Forums/Topic1320527-392-2.aspx#bm1322829

Thanks for all the suggestions. I think I'm going to use the Import/Export wizard to create the initial package & then go in and modify each step to include rowcount...

No, there are not frequent schema changes. In fact, Schema changes are handled through source control deployment. The movement of the data itself is not, though. I've not used the...

Thanks, Steve! I talked about the options with my boss & he thinks it will be extremely rare. He said to go with the -1 for now, but I...

I'm overwhelmed with gratitude for the multiple solutions posed! I thought I'd give a little more background on the business requirements to try to illustrate what we're doing. I'm a...

MM-- I think that's it! I'm staring at your code and not understanding exactly why it's working, but that is definitely the result set I was hoping for. I'm going...

All,

Thank you again for your responses. Lynn's code is very close, but Eugene had 2 additional insert rows to demonstrate the issue I'm worried about. Below is the full create/insert...

SSCrazy, that is very close to what I need but the problem you brought up is definitely something I have to solve. I read through the "quirky update" article, but...

Any updates? We're looking to do some simple modifications to an 837 file. I just need to replace the billing name/address and append an invoice# in a specific segment.

I think I figured it out. In order to make your reports sort by the # of the month rather than alphabetically (so January comes before February), click on the...