Hi

I guessing that the type is the main part of this, so something like

CASE

WHEN Type = 'Type 1' THEN

...

Unfortunately it's not really supported in SSIS.

There is a couple of things that can be done though. Here's a couple of links that may help.

http://www.sqlservercentral.com/Forums/Topic965972-391-1.aspx

http://blog.strictly-software.com/2011/11/error-copying-tables-importing-or.html

What in particular...

I'll take a quick stab in the dark at this. Have no idea if it'll return the right results or perform any better, but as Sean said you haven't...

Hi

Here's my attempt at it. I am making some assumptions about your data that you will need to take into account.

1. There will only be up to a...

Despite my issue with the back story on this question, I do really enjoy Andy's questions as they get the old grey matter working. I find that they quite...

The concept of putting the foreign key on databases didn't make sense to me.

Wouldn't it be make more sense to put the foreign key on the backuplist rather...

tod.novak (4/10/2014)

---

mickyT,

This worked perfectly! Thank you so much for the help. I'm going to look up COALESCE to help me understand how it worked.

Thank you everyone for the replies....

Have you tried the ROLLUP? I have altered your original slightly to match the result set you wanted (without the printer name) and it should provide the result you...

Hi

Have a look at ROLLUP, I think this will do what you want.

SELECTComputerName AS 'Computer Name',

SUM(BlackWhiteTotalCount) AS 'Total B&W Pages',

SUM(FullColorTotalCount) AS 'Total Color Pages',

Name AS 'Printer Name'

FROM...

+1 🙂 ... Looked for the gotcha and fortunately found it.

Hi

The simple answer is no. To get a better answer you should post up more information as outlined in this article Forum Etiquette: How to post data/code on...

There is likely to be a better solution, but the concept was to count the the number of visits to each airport. The first visit would be on the...

Hi

Here's my attempt at it. It should also handle situations where a direct flight is taken back to the origin. Sorry it's a bit ugly looking:-)

WITH presort AS...

Hi

Dwain Camps did a nice article about arrival and departures here. Departures from Origins and Arrivals at Destinations[/url]

Hi

Had a bit of time to play around with a multi point line. The following will do a parallel for both sides of an input geometry. I've left...