I got you..Thanks much...

Jus

You welcome..

For Convenience, i have also taken 3 sets for Item/Qty/Value..Is this the solution you are looking for?

I have created test table with some dummy data...

use tempdb

if object_id('tempdb..#testsplit') is not null

drop...

I guess these kind replies bcoz of UI in SSC.

When we reply in SSC, No history of the post will be shown underneath. that some times confuses users when keeps...

Lynn..you are right..I should have tried first. But when i saw the code i found few oracle objects like dual , connect which am unaware of...hence posted..this was not for...

Do you get the fixed number of columns as output everytime you execute [SP_LogView2]

--- If Yes, You can have a permanent table with those many column...

Sample data should have been helped us to help you..

any way, if the data is Continuous (with no spaces or no delimiters), you can use still bulkinsert to dump into...

your DB Design and how they related should tell you the answer.

Does all the columns in your select query (apart from loanid) will occur only once for every loanid?

if not,...

There are two things. 1) Split the values in to separate columns 2) define view.

For point no 1) You can use Tally tables (Search for "Tally table" in SSC)...

Thanks all replied...

Create table TestDiff (DateCol datetime,daysdiff int)

WITH DaysDIffCTE AS

(SELECT Datecol,daysdiff,ROW_NUMBER() OVER (order by Datecol asc)as RowNumber FROM TestDiff)

select a.datecol 'Fromdate', b.datecol 'Todate',b.daysdiff - a.daysdiff 'DIff'

from DaysDIffCTE a...

Garadin..This was plain self join i know....Some time back i have seen a solution to simillar kind of problem in SSC in a different form, i guess they were using...

Thanks Steve..I guess we need some appliocation (.net) to accomplish the required functionality.

Set @P_Amt = (Select Sum(Cast(P_Amount as Numeric)) FROM tblArchive Where RunDate >= @First_Day_Prev_Month AND RunDate <= @Last_Day_Prev_Month)

Steve..first of all..can this be done using procedure?

No problem even if its tough to do this...but i want to know.is this really doable in a proc?

am not sure the table names and clolumn names in each table. This new program should handle all..If Proc p1 returns 3 record sets, new program should be able to...