Thanks 🙂

are you saying TWO FK ? IS IT OK ?

question are different not relevant of each other

one member can create many groups it means one owner have many group owned.

what if this is the case?

thanks

i'm thinking to have ISOWNER column in 3rd table to set flag as tru/false.

IS IT GOOD APPROACH OR ANYTHING ELSE YOU SUGGEST TO ASSIGN A OWNER OF GROUP.

thanks i made it

no need of sunday to me problem is unable to take filename now ;(

"FILENAME"+

(DT_I4)DATEPART("weekday", GETDATE() ) ==2 || (DT_I4)DATEPART("weekday",@[System::StartTime]) ==7 ?

Replace((DT_STR, 20, 1252)(DATEADD( "D", -3,@[System::StartTime])),":","-") + ".xls" :

Replace((DT_STR,...

i'm trying like this -

(DT_I4)DATEPART("weekday",@[System::StartTime]) ==2 ?

Replace((DT_STR, 20, 1252)(DATEADD( "D", -3,@[System::StartTime])),":","-") + ".xls" :

Replace((DT_STR, 20, 1252)(DATEADD( "D", -1,@[System::StartTime])),":","-") + ".xls"

could you please help me in long expression , m total new bie

thanks

I have done by using having clause

SELECT name,SUM(price) as price

FROM table

GROUP BY name

HAVING SUM(price) = 0

Thanks 🙂

Hi,

I'm very thankful to you

sgmunson and others too

You gave me the right clue PortfolioId's need to be matched in too more LEFT JOINS as it is LEFT JOIN it...

thanks for help

I'm getting all the records correctly there are 3 records for same security id and because of this MERGE statement is not updating my all 3 statements...

ok but now the situation is i dont want to check with quantity i only need to know that quantity is '-' or '+'

i will give you an example.

my select...

Hi yes i need help in CASE statement my need is i need to only check wether that StateStreet.SharesParValue is positive or negative.

I was trying to put this case statement...

BondTradeId int Unchecked

TradeId int Unchecked

Par decimal(32, 4) Checked

TradeFee decimal(32, 4) Checked

AccruedInterest decimal(32, 4) Checked

AccruedPIK decimal(32, 4) Checked

AccruedFees decimal(32, 4) Checked

...