Database

CodingYoshi wrote:

SELECT TOP 10 *
FROM TableA
WHERE ColumnX IS NULL

CodingYoshi wrote:

WHERE ColumnX = 'NULL'

select *
  from
(select *
   from t
  order by id)
where rownum <= 10

where Trans_date between '' and ''

nelsonpaixao wrote:

BOB TUBOR lessons.

Declare @X xml<br />
Set @X = (SELECT RegionID, sum(Amount) Amount <br />
						FROM FactTran<br />
						where PeriodID = @PeriodID<br />
							and WFGroupID = @WFGroupID<br />
							and TranTypeID = @TranTypeID<br />
							and ISNULL(BUID,7) = 7<br />
						Group By <br />
							RegionID<br />
						 For XML Raw ('RegionID'), ROOT('Regions'))

LEFT OUTER JOIN (SELECT <br />
                                    x.item.value('@RegionID[1]', 'VARCHAR(100)') AS RegionID,<br />
                                    x.item.value('@Amount[1]', 'Decimal(30,2)') AS Amount<br />
                                    FROM @x.nodes('//Regions/RegionID') AS x(item)) R on R.RegionID = A.RegionID<br />