you can do it in number of ways. i prefer this one because is simple and you do not need to write to many lines 🙂

Something like this

Select *

from...

Nice question. Thanks for sharing

excellent question and very nicely explained. thanks for sharing

Nice question. Thanks for sharing

1.2 millions isn't a huge chunk and your should check if your joins are creating huge scans which they might in this case because scans on huge table kill the...

whats is average day data volume i means rows count? and whats is your hourly data count. I believe your SP is eating to much resources of your production server...

i think its the extended version of your previous thread Dynamically hourly data extraction in SSIS 2012. I think you should be posting that on the same thread so that...

Nice question. Thanks for sharing

Koen Verbeeck (12/2/2014)

---

Eirikur Eiriksson (12/2/2014)

---

Just and only for fun, here is a slightly twisted solution, recommend following Koen's suggestion

😎

DECLARE @STR VARCHAR(100)='My name is Shiva';

DECLARE @XSTR VARCHAR(MAX) = 'SELECT(SELECT CHAR(32)+Y.XN FROM(SELECT...

nice question. Thanks for sharing

i actually meant that were actually you are facing problem in For Loop in ssis ?

what exactly the issue you are facing right now?

Nicely done, will help a lot of people especially newbies. Thanks for sharing

Nicely done. good article. Not really a fan of PIVOT thou.

i would really interested to see the performance against to Cross tab queries as mentioned here Cross Tabs and Pivots,...

+1