Thanks for sharing the test Harness script Eirikur and YES there is always room for improvements. 🙂

I think there was some kind of mistake really, there is no other option beside Option 4 and the column is not available in table. I was unable to answer...

I have tried to put a sample data to test the current query result with the new query. With a bit of data for stress test.

DDL Structure

USE TempDB

GO

IF Object_Id('dbo.ExchangeRate')...

Well its not so complicated in terms of understanding what current query is doing. its actually creating Start Date and End Date of you ExchangeRate for a currencyId.

This will...

if you mean that number of rows to be fetched of a single date. it would look something like this. You can give a parameter how many rows should be...

nice and easy thanks for the question Steve

Great story i will not say fiction at all. only the part when everything start to get happy. I heard from many that things do get better the door will...

Well its not about the OFFSET what you have shown in your desired output u need to get CurrentRow and two previous rows data for each 3 dates running total...

Thank you SIR, i also missed what you have written. i should take a snapshot of it and frame it on my wall 😎

Jeff Moden (12/22/2015)

---

koti.raavi (12/21/2015)

---

Hi All,

Below is the sample query

Select Month1,Month2,Month3......Month24 from #temp

I need to display data like below

Select Month1 as [Dec 2015], Month2 as [Jan 2016],Month3 as [Feb...

As you didnt share the your query i have to build a prototype query to generate the list of columns for u.

This query required two parameters i-e StartDate, EndDate. Rest...

when you are creating the temp table you must be knowing which month it is right. If yes then share us the schema of your SP so that this could...

i never recommend reading excel like this. if you want to read excel and want to avoid such issues you should be using script task in which you can write...

when you have added date column in the excel, Is the date column is show left align data or right aligned ?

nice question thanks for sharing.