yes and might increase at any point of time.

Because formula are different for Different Scenario

I need to make it dinamic so that based on the Scenario Formula should be Take and Calculated.

SCENARIO - TGT_PAYMENT_TYPE - PAYMENT_FORMULA

NORMAL ...

Chris. I agree with your Query. My problem is that i need to make it Dynamic.

I can not use the Static way of implimenting this.

Can you please help me with...

there are 3 formula....!

SAL = SAL-ADV

COMM = ALL_1+ALL_2-ALL_3

BONUS = SAL * 1.1

Data in the Test Formula is

TGT_PAYMENT_TYPEPAYMENT_FORMULA

SAL ...

CODE 1:

DECLARE @cols AS NVARCHAR(MAX),

@query AS NVARCHAR(MAX),

@cols2 AS NVARCHAR(MAX);

SET @cols = STUFF((SELECT distinct ',' + QUOTENAME(c.PAYMENT_TYPE)

...

Yes they has SAL.

the broblem is that I have multiple of such in my Scenarion

Thanks for the above input.

Now I am stuck to write a Dynamic SQL which will inter update the Data in the cursor, as per teh data format needed.

1. Formula is...

Thanks for the Reply, If you observe my Example, the Payment Type is not Static for all the user and payment Type has nearly 5000 types 🙁

Writing Pivot is a...

Hi All,

Please need some help or clues...! 🙁

Yes it running Perfectly in all the places....! But Fails on one Server. that to when the File size is greater than 2 MB

Yes all the needed Access are available.

yes...!

If Packages are Deployed based on MSDB, Take up the 10 packages and Right Click on MSDB and import the Packages.

Else if you are using File System, go to the...