now who said sql server does not have a heart 😛

thanks for sharing STEVE 🙂

your table structure is already showing running total column, i think you want to repeat the data until the new value come.

the date column is not a proper date,...

very good question for the beginners to understand what OR , AND does.

Thanks for sharing ..

hoseam (2/12/2014)

---

This is what I have but it errors

DECLARE @Product_Id VARCHAR(50), @Fund_Id VARCHAR(50),

@NewFund_Id VARCHAR(50),@NewProduct_Id VARCHAR(50)

SET @Product_Id = 'PIC2'

SET @Fund_Id = ''

SET @NewProduct_Id = 'PCCV'

SET @NewFund_Id = ''

IF @NewFund_Id = ''...

you can assign 'null' to the parameter, so it will update the column with null

like this

Declare @param as varchar(20)

Declare @table1 table ( id int identity(1,1), name varchar(20))

insert into @table1...

following is the solution for your as per the provided sample data.

Declare @table1 table (ID int,name varchar(10),[sep-12] varchar(10),[oct-12] varchar(10))

Declare @table2 table (ID int,Abc numeric(10,3), cde numeric(10,3),monthnbr int,yearnbr int)

insert into @table1

values

(1,'Abc',null,null),

(2,'cde',null,null)

insert...

as per the design you will be adding 12 new columns in the table1 each year.

why you need a table1 in a first place, what exactly the problem you want...

very nice question ... but excellent third option ... Raining ... :hehe:

cheers !!!

did you tried to connect to the server from SSMS with the same credentials you have in connection string?

all you need is a PIVOT on the query, my question is what happened if you have 2013 year data for same months then what will be your result set...

are there to many joins you are using in your query (including these char columns). if yes then you can create a non clustered index on these two columns.

this link will help you in this regard

http://www.sqlservercentral.com/articles/Best+Practices/61537/

share the a proper sample data table for us to understand the problem to provide any help.

help us to help u 🙂

MAX() is working upon as per the definition of the base table.

in your query u are using left join, if you try to use right join u will be even...

nice question ... thanks for sharing