it is hard coded solution ... the values can be vary

Please consider all as integer datatype

i tried this

https://www.mytecbits.com/microsoft/sql-server/auto-generate-insert-statements

Hi Expert,

i want insert statement from table into file , this will consider as backup

Expected output

insert into table2

values('2022-02-02',22)

,('2022-02-03',22),

('2022-02-04',22)

expecting below output

insert into table2

values('2022-02-02',22)

,('2022-02-03',22),

('2022-02-04',22)

suggestion pls

7 is expected because prodnumber=prod1000 comes with Minstartdate. whatsover value with minstartdate that should come and maxstartdate,4_5,4_2 will be calculated as below

here is the calculation for 4_5 and 4_2

calculate max...

it would be 7  which means produnumber,min prodstartdate,prodid will remain same only maxprodstartdate and 4_5 and 4_2 value will change

see the output:

Here is the image.. attached again to main question

• This reply was modified 2 years, 6 months ago by  Shree23.
• This reply was modified 2 years, 6 months ago by  Shree23.

sure

suggestion please!!

i tried

;with mycte as (

select newdate,status,value

,count(*) over(Partition by status,value) cnt

,row_number() Over(Partition by status Order by newdate) rnAsc

,row_number() Over(Partition by status Order by newdate DESC) rnDesc

from test

)

select newdate,status,value

from mycte

WHERE (cnt>1 and...

suggestion pls