Click here to Skip to main content
15,949,686 members

Comments by DT_2 (Top 37 by date)

DT_2 19-Feb-24 23:01pm View    
Duplicate records means below
CustNum|IsPlatform|Parent
253 |0 |253
253 |0 |132
253 |0 |0

What I need is as below
CustNum|IsPlatform|Parent
253 |0 |132
132 |0 |0
DT_2 19-Feb-24 9:33am View    
this is giving the duplicate records. @CHill60
DT_2 19-Feb-24 9:33am View    
WITH cte AS
(
SELECT CustomerId, ISSCustId, CustomerName, CustomerNum, IsPlatform, CustomerNum As TopParent
FROM [dbo].[VwCustomer]
--WHERE ParentCustomerNum = 0
UNION ALL
SELECT T.CustomerId, T.ISSCustId, T.CustomerName,
T.CustomerNum, T.IsPlatform, cte.TopParent
FROM [dbo].[VwCustomer] As T
JOIN cte
ON T.ParentCustomerNum = cte.CustomerNum
)

SELECT *
FROM cte
WHERE cte.CustomerNum = 253
ORDER BY TopParent DESC;
DT_2 18-Mar-19 3:58am View    
Hi, Did you get any solution over there? I need some guidance, how to start. I want an extension where i will press the extension image and feedback form will open. Please help in any way.
DT_2 18-Jan-16 4:47am View    
Thanks Sergey for your comment.

Below link has done my job.

http://stackoverflow.com/questions/26396468/how-to-set-text-box-value-to-upload-filename-using-javascript