Mark, just curios about this scenario. Did you find out the solution?

Thanks.

Even I was searching for something similar, and found the below. This works perfectly fine with "Pivoting dynamic number of rows TO columns"
Let me know if this works or you...

Nice 🙂

Right..

UNION works in this scenario.

You can find hundreds of them. Just try to google.

The below link is one suchtutorial, from microsoft's

http://msdn.microsoft.com/en-us/library/ms167559.aspx/

Thanks,

Satish

same query - with detailed data and output.

Run the below and confirm if you are looking for the something similar or not.

DECLARE @Customer_Bill_Table TABLE

(

[Custmoer NO] VARCHAR(3)

,...

Hi Rahul,

Please use the below query to get the no.of unique products purchased by Customer

SELECT [Custmoer NO],COUNT(DISTINCT [product name]) AS NoOfProductsPerCustomer

FROM @Customer_Bill_Table

GROUP BY [Custmoer NO]

Let me know if this...

Thank you. These are helpful.

Try looking into the below:

http://www.ideaexcursion.com/2008/11/24/set-ftp-password-in-ssis/

Thanks,

Satish Chandra.

- Report Data pane is visible only when report(.RDL) file is opened in VS. and also, you should be on the 'Design' view of the Report.

- Once you are on...

Hi,

Try adding .txt and .csv in the foreach loop editor.

I am not sure whether both can be added at once, in that case you can actually take 2 foreach...

Hi rockstar283,

Can you make sure mapping is done correctly?

I am sure you might have done this, but still, wanted to recheck.

Thanks,

Satish Chandra

Hi Nestor,

I am not sure of the actual requirement and costraints around your tables, but i think you can try .....

Take the differnece of Table rows with help of a...

Hi Gayatri,

I think, using of TimeOfDay() will populate the Reporting server's Data & Time, but it is not specific to region.

I am not sure whether this works this way.........

Thats a very intresting exercise.. Will try and let you know if found any lunck..