I don't understand your question. The row is 41 bytes wide in that table with that data.

If you're trying to find out how big the final table will be,...

An Outer Join from Periods to Sales will get you what you need.

I've tried various voice recognition systems, and found them inadequate to my needs. I also type about 100 WPM, so maybe it's not a fair comparison.

First, you can do that, but I recommend checking the table data with the IsDate function first. That way, you can find any that aren't going to work.

Second, test...

I haven't been through that, but the first thing that pops into my mind is that converting all varchar columns to nvarchar can certainly have effects, at least on the...

If you attach a text file with a sample of the XML, and post the create scripts for the tables, I'll see if I can help you get what you...

You might be able to use a Look Up transformation for that. Take a look at that one, see if it does what you need.

It doesn't like calculating values within the execute command. Do it like your first example.

As an aside, I'd change the way you're doing the end date. Make it...

You could use the DataLength function on the columns to get how much they are holding. Will that do what you need?

Take a look at the "Output Clause" in Books Online. It allows you to grab the UniqueIDs (or whatever else) from data you insert into a table, store it...

Can you insert the whole table into a temp table, with an ID on it, and then transfer to the other table with the temp table as the source, in...

;with CTE (Row, ID, MostRecent, Ben) as

(select row_number() over (partition by ID order by Date desc),

ID,

Date,

Ben)

select ID, MostRecent, Ben

from CTE

where Row =...

Please don't double-post in multiple forums with the same question.

I generally include master and msdb in those steps. Definitely don't include tempdb in most/any of them. I don't even back up model unless I've made changes to...

Do you mean you want the most recent date for each ID? If so, then Max(Date) and Group By ID should do what you need.