SSC experts would definitely have an answer to this .. my wild guess though is :unsure: ....probably firstly converting it to excel and then reading that excel... or writing some...

Probably some unicode character featuring in one of the rows from those columns.:unsure:

You may have to use combination of charindex() and len() function to determine this. If you could please provide the sample set then we can give it a go.

probably you are looking for something like this

select pincode,sales,SUM(sales) from #cust

group by pincode,sales with rollup

sorry, what is the issue, again :unsure:?

Please provide statements to create sample set and what exactly is expected ?

Did you go through following link ?

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/749bb98a-5317-43bd-a548-e0cdef5a12d9/failed-to-decrypt-protected-xml-node-dtspassword-with-error-0x8009000b-key-not-valid?forum=sqlintegrationservices

why not use conditional split transform to eliminate empty rows ?

is it ? can you please try to execute the entire query again.. isn't it returning the expected result = DUPLECHEIN, KELLIE and LANDRY, MICHELE..of course except for MICHELE..

The logic...

I agree with JohnFTamburo on using split function and the probable inconsistency of hypen in the text... still wanted to give a shot so ended up writing following ......

Not sure about the performance but tried doing it following way... please consider cte and cte1 as tables wrt to update statement written at the end

;with cte as

(

select 1...

I was about to update the post and saw your comment Thank you MyDoggieJessie for pointing that out.

select date_value,monthly_total,(select sum(monthly_total) from sales s where date_value <= tst.date_value )

monthly_total_sum from

(

select *,ROW_NUMBER() over ( order by date_value )tst from sales

)tst order by date_value

For date conversion you may use

SELECT convert(date,CONVERT(varchar(10),columname,101))

For time please take a look at http://stackoverflow.com/questions/12568408/how-to-convert-an-integer-time-to-hhmmss00-in-sql-server-2008

Experts, is there any other easy way to convert integer to time ?

here in a comma separated input string ',' is replaced by " ' as tags UNION SELECT ' " so that you get a output with distinct...

I tried doing this though I was successful but I feel there has to be a easy way around... I do not have SQL 2012 so did it in 2008......