sudhirnune (4/9/2013)

---

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 ...

sudhirnune (4/9/2013)

---

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...

Did you test the query I posted above somewhere?

SDG1 (4/9/2013)

---

Ok, so I recreated the table defining the Project ID as UNIQUE, NOT NULL rather than as a primary key and everything works great now. There are no...

An index on #d2 supporting this join ([#d2].MARIMSSALESID) = ([DynamicsV5Realtime].[dbo].[SALESTABLE].MARIMSSALESID) would reduce the exaggerated estimated row counts, but that's besides the point. This lot is unlikely to run well unless...

sudhirnune (4/9/2013)

---

Data in the Test Formula is

TGT_PAYMENT_TYPEPAYMENT_FORMULA

SAL ...

Thank you, Vinu. Insufficient information yet to determine whether or not it will be useful...

How many rows does the table TEST_FORMULA contain?

Can you post a few rows please?

Yes:

DECLARE @STARTDATE DATETIME, @StartTimeChar CHAR(5), @EndTimeChar CHAR(5)

SELECT

@STARTDATE = CAST(GETDATE() AS DATE),

@StartTimeChar = '08:00',

@EndTimeChar = '10:00'

SELECT...

Thanks.

DROP TABLE #Sampledata

CREATE TABLE #Sampledata (NAME VARCHAR(25), PAYMENT_TYPE VARCHAR(10), PAYMENT DECIMAL(5,2))

INSERT INTO #Sampledata (NAME, PAYMENT_TYPE, PAYMENT)

SELECT 'SUDHIR', 'SAL', 30.3 UNION ALL

SELECT 'SUDHIR', 'ADV', 10.3 UNION ALL

SELECT...

SSC has several related articles [/url]which may help. It's tricky and time consuming, and you may find it worthwhile purchasing a commercial application.

UPDATE c

SET CmDclnWdwnDt = s.DecWdrwnDt

FROM Claims...

greg.bull (4/9/2013)

---

Dear All,

Thanks for the posts - this is an old one that I solved a while back (just using case statements as I recall). Didn't expect any further postings...

I understand that you have multiple payment types, and an employee may have several rows with different payment types.

Do ALL employees have at least one row with payment type...

DECLARE @DecWdrwn as TABLE(CtryId smallint, CmId int, DecWdrwnDt int);

WITH s AS

(

SELECT

c.Ctryid, c.CmId,

-- Dt, not used

MaxDec = ISNULL(MAX(c.CmHistDtTmId),0),

x.MaxSet

FROM ClaimHistory c

OUTER APPLY (

SELECT MaxSet = ISNULL(MAX(l.CmHistDtTmId),0)

FROM...