You want to generate a single data item which (somehow) combines both Category and Date, is that correct?

What form should this composite value take?

Something like

XXnnnnnn,

where XX is a code for...

Thanks for posting the second link, Frederico. That is a useful technique.

What exactly do you mean by 'flip'?

Yes, I have sensitive parameters assigned from SSISDB, but I think you must mean something more involved than that.

From the top of my head, some pros are as follows:

1. Comprehensive execution logging, with built-in reports, is available to you as a 'freebie'. No additional config required.
2. The ability...

One big con depending on what version you are doing is that in Project mode deployment of individual packages isn't possible.  You have to deploy the entire project.  This...

Keywords indeed! OK, here is one way, which (for ordering purposes) relies on every person having a unique Id column.

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
 ...

Never seen this function before!

Having said that, if you can transform your source query so that the results look like this, it would be straightforward.

I don't think that there is a 'no code' way of achieving this.

But if you know how to code and use Script Components, this is possible.

There is no support in SSIS for creating PDFs.

However, if you can work out how to create PDFs using .NET assemblies, you may be able to do this by using...

Stored procedure OUTER_TEST calls stored procedure INNER_TEST.

If an error in INNER_TEST, how do I capture the error message (to store in a table). When I have a try-catch...

• This reply was modified 3 years, 2 months ago by Phil Parkin.

Something like this, I think:

DECLARE
    @Route   VARCHAR(50)
,   @USRoute VARCHAR(50);

SELECT
    @Route = 'x'
,   @USRoute = '';

SELECT...

That's useful functionality, for sure. I think you should have mentioned somewhere that this is third-party software available at a price, not something which comes with the product.

OK, that's an example of the source data. Based on that, what do you want to see? I do not see any 'subgroups' in this example.

We have to insert the records for each student key based on type and sub type. but in select we have to use id as with type HOLL and...