Hi,

I am new to BIML, I am trying to create BIML for SSIS package which is using Merge join , and per Merge Join concept we need sorted...

Thanks livingstone :-), this one is perfect .. meanwhile I have done like this

SELECT *,LEAD(Amount,1,0)OVER (ORDER BY date) nextv,lag(Amount,1,0)OVER (ORDER BY date) PRevv

FROM #tmp

),CTE1 as (

SELECT...

Thanks Dixie Flatline for the answer, It is almost what I am expecting, except we have value for null should be replaced by next value of buyPrice.

Also, this data was...

there are buy betwwen them, but we have to just take the first buy against each sell.

Thanks you all for guidance. Problem resolved by using decimal as data type .. Thanks again 🙂

Thanks Mitesh. 🙂

I also find the way way to do it , but with MERGE : --

DECLARE @tbl11 TABLE (date1 DATE ,WSH VARCHAR(3),ITN int ,Executions INT ,MCG INT ,...

Thanks for the suggestion. Actually I do not have any column on the basis of which I can segregate the blocks. I have to process one row as one block.

I need massage to be stored not the results..

Eg:-

(1 row(s) affected)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

I need the result like this..all missing number between '001' to max(bid)

IDBID

1232

1253

1256

1283

If we have '010', '030', Missing items will be '011','012'....'029' .

Thanks for the catch :hehe:

Actually

for 123 I need to find the missing sequence BID '003'

for 125 I need to find the missing sequence BID '002'...

Thanks 🙂

@dwain.c

Please guide me for solution through the dynamic SQL if number of column is dynamic(not fixed)..

Thanks

@dwain.c ...Thanks a lot 🙂

😀 I can do this by join ..but unable to do this with cursor ...