Hi all,

no one has encountered such a problem yet....?

Thanks Ninja,

I already started doing this process using #temp table and While Loop as usual

Thanks for your time.

Hi Ninja,

The Update SP is not simple, in previous post i just specified that for example. Actually the update SP has some 350 lines with wide logics in it.

So i...

Hi Ninja,

The SP is already used for other Processes, so that it's not possible to make any modifications in the SP such as passing XML parameters etc.

Just we need...

Hi Ninja,

Thanks for the quick response.

Since SP is very big, i was not able to post that SP.

Can u post a example of the method with simple lines if possible.

Thanks

Prakash.C

Thank U Mark, It Works Fine, Thanks for solving my problem in short period of time.

Thanks Adi, i Got it Done.

Thanks for all

Thank u Eddie Wuerch,

I have completed the script which is similar to u, thanks for u'r replay

SELECT SI.SINumber, (DENSE_RANK() OVER (ORDER BY RoleID, PaymentTypeID, (I.OpenStock&I.PaidStock))) AS RANK

FROM

SI

INNER JOIN CUSTOMER...

The Problem is not retreving records in this format, but the Column Header must be Dynamic Date

--------------------------------------------------------------------------------------------

ProductId - Date 1 - Date 2 - Date 3 - Date 4 -...

Hi All,

Here's my description about my Query

i Have a Table with Columns as ProdId, Value, Date

Users will enter some value for each product on various date

The Task is to Retrieve...

Hi All,

Thanks for all u'r Replies.

Ok as per u people suggestions i try to add another column to store datetime

thanks for all

Prakash.C

Hi Markus Bohse,

Thanks for u reply, It's good to have created or registration date, but in my case i have left that, now i cannot make any change in Table...