hello, i found this site very helpuf and maybe someone can help me. i have a table in which i need to search for those opprtunities that have PL=HA and need to put "1" in the column[HA]. Lets say that the column HA is empty. my problem is that if the opportunities repeat i need to put "1" even if…

DECLARE @vt_Table TABLE ( [HPE Op] VARCHAR(50), [PL Name] VARCHAR(50), [SFDC_DATE] DATE, [PL] CHAR(2) ) INSERT INTO @vt_Table([HPE Op],[PL Name],SFDC_DATE,PL) VALUES('OPE-0007525935','S6 sy','20170727','S6') , ('OPE-0007525935','S7 sv','20170727','S7'…

SQLTeam.com Forums

Partition by problem

Transact-SQL

Alexa1 August 25, 2017, 10:53am 4

thank you so much, it worked