Requirement: In table which has row numbers and need to fill null value with previous non null value.

Solution: Using Cross Apply and Top 1 row

Tsql Syntax (Gen):

Select Coalesce(Tbl1.<Column1>,Tbl2.<Column1>) GTIN,Tbl1.* From Tbl Tbl1 --Coalesce would fetch first non Null Value
Cross Apply (Select top 1 <Column2> from Tbl Tbl2 -- Top 1 value would get only 1 record
             Where Tbl2.Row_Num <= Tbl1.Row_Num and <Column1> is not null --Row_N is row_number
             Order by Row_Num Desc) QE...
Continue reading ...

Yes, you got the title right. By default Administrator account is disabled. How did I get to know about this? Colleague of mine James Joseph who did extensive research on account and shared it with me. I remember once I even called Lenovo Support to seek help on Administrator account. It looks like Technical guy is not much aware of disable/enable of Administrator account.

So, if you wish to enable it. Here are the steps.
1. You need to have administrator rights account
2. Run Command prompt wit...
Continue reading ...