The keys to this being properly 'thinned' is werknum table and the DR alias... which includes this lovely inline function to obfuscate any chance at using an index:

dbo.GetFirstDate(CJ1.Jaar, CASE WHEN...

Don't force join types unless you're VERY sure of why you've chosen to...

Happy Friday.

I fly to Vegas this weekend to visit some family for Mother's Day. Anyone else in town that might like to try to grab a beer or three...

I've been thinking this issue over and to be honest, I think you're asking the right question in the wrong place.

We're SQL guys/Database Dudes. If you wanted to discuss...

polkadot (5/11/2012)

---

Users will open a Word template which will allow for free text summary of project status. It should also contain two fields each of which accepts a parameter which...

princa (5/7/2012)

---

Good question, it's actually the same scenario I am facing right now!!!

But I still have some questions:

#1 - I am using a partitioned view to union two tables, one...

Unfortunately not that I'm aware of. Because the Join will distribute the two halves of the join into both counts, you have to use correllated subqueries (basically the CTE...

Dave beat me to it. You either pivot or crosstab, and he's provided an excellent example of the crosstab.

Pivots tend to be slower optimization-wise, and they're not necessarily easier,...

If I had to guess you're not seeing all the errors being kicked back all the way to .NET and you're dealing with a double-hop issue.

What's your linked server set...

Considering the number of views of this and that noone's responded, and that I'm utterly boggled by the occurence as I understand your description, this might be one to tag...

opc.three (5/3/2012)

---

Using the Excel Object Model is what I would do. I suspect that's what Craig (mentioned VBA, don't think he meant true Office Automation) and Revenant (Excel interop) are...

Well, now, that's interesting. These are ISO dates with milliseconds, but the don't conform to actual standards. Instead of dissassembling the data, I'd recommend we adjust the data...

sqlbi.vvamsi (5/2/2012)

---

Exactly!! That's what I've done for Flat File and CSV File, putting all columns data under one column and split using a script component. However, I do not have...

You've got variable meta-data. You can't do this directly in SSIS, it wants hardened metadata that doesn't change between iterations. There's some third party connections that can help...

Soul, let me see if I understand what you're looking for. You're basically looking for something that looks like:

82 | Madrid | USA, Spain, Brazil

Or something that looks like:

82...