Database

name	address
John	302 ABC Street
Smith	412 DEF Street

declare @tbl1 table(id int identity,name varchar(20), address varchar(50))

id	name	address
1	John	302 ABC Street
2	Smith	412 DEF Street

select ROW_NUMBER() over(order by name) id, * from @tbl1 

Steven J Jowett wrote:

If I execute a SELECT query on the receipts table WHERE ReceiptId = 330804 , I get 2 rows.

Steven J Jowett wrote:

SELECT * FROM vuProductReceipts WHERE ReceiptId = 330804 OR ReceiptId IS NULL

Steven J Jowett wrote:

I would expect to get 126 rows returned, but I am only getting 63.

select ProductId,ReceiptId,Quantity from
(SELECT TOP (100) PERCENT p.ProductId, r.ReceiptId, r.Quantity
FROM         @tblProduct p LEFT JOIN
             @tblReceipts r 
ON p.ProductId = r.ProductId ) X(ProductId,ReceiptId,Quantity)
where   X.ReceiptId = 2 OR X.ReceiptId is NULL

ProductId	ReceiptId	Quantity
1	2	40
1	2	12
1	2	40
1	2	12
1	2	45
2	2	45
2	2	45
3	NULL	NULL
4	NULL	NULL
5	NULL	NULL

ReceiptId
ProductId
Quantity

ProductId Quantity
1.........10
2.........NULL
3.........NULL
4.........5
5.........NULL

SELECT NULL as TicketId, *, NULL as Quantity 
FROM vuDepotProducts 
WHERE NOT EXISTS(
SELECT * FROM vuReceipts WHERE DepotId = vuDepotProducts.DepotId AND ProductId = vuDepotProducts.ProductId AND TicketId = 330804
)
UNION
SELECT * FROM vuReceipts WHERE vuReceipts.TicketId = 330804

SELECT @VideoId = VideoId 
  FROM Videos 
 WHERE Title = 'Monkeydog'

I are Troll

Set @VideoId = ( Select top(1) VideoId from Videos where Title='Monkeydog' )

Select @VideoId = VideoId from Videos where Title='Monkeydog'

select maid) from enquiry where regdate=#05/Nov/2009#

select maid) from enquiry where regdate=#2009/11/05#