Errrmmm..... I'm sorry....

I left out a "tiny" piece of information: you'd need to split the data from your OLEDB source using the Multicast data flow item.

Assign a variable to the...

I don't know of any way to assign the permissions automatically.

The way we do it:

we use the following two queries (simplified) to find the roles not assigned yet:

EXEC sp_helprotect NULL,...

Something like this?

Or anything more specific?

We're frequently using database roles.

It makes it a lot easier if you have to assign identical permissions to more than one login.

You just change the...

Inside your data flow task, use a RowCount task and assign the result to a variable.

In your Control Flow task, add a Send Mail task and refernce the variable you...

... or you could use a subquery to return the ID per per zip code per customer with max(order date).

Use this subquery to join back to your original table.

I need to talk to our db admins...

We changed to DST last weekend, too (but not at 1am, time changed from 3am to 2am on Sunday. Location: Germany).

Since we did...

I would store that xml file in a table with an xml column and an identity col.

Add an XML index to that table. The insert should perform much better.

Another option...

How about using GROUP BY?

SELECT INV.Reference AS 'Invoice Reference'

...

Here's a slightly different approach using CROSS APPLY.

It usually is faster than the method Peso posted.

But you should try both and decide by yourself 😀

SELECT n.value('name[1]', 'VARCHAR(MAX)') AS Name,

...

Search either BOL or the web for "FOR XML EXPLICIT".

For more details we need more info. See Pesos reply.

The major question is: WHY?

If you need to deal with date values, use the DATETIME instead of a varchar. It makes it a lot easier to deal with.

But to answer...

please provide table def and sample data as described in the first link in my signature together with your expected result based on your sample.

Is there anything specific you're looking for?

What results did a google search return?

You should look into WITH ROLLUP (see BOL for details) to get your total value instead of using the UNION.

It's easy, but complicated 😉

SQL Server will evaluate each expression within your equation and will determine the returned data type. Based on that it will define each subresult as well...