select
	[Transaction].Time, 
	Batch.RegisterID,
	[Transaction].CashierID,

	CASE when TenderEntry.TenderID = 8 then 'Visa'
		 when TenderEntry.TenderID = 9  then 'M-Card'
		 when TenderEntry.TenderID = 11 then 'Disc'
		 else TenderEntry.TenderID
	End 'CC-Type',
		
	Tenderentry.Amount,	
	TenderEntry.CreditCardApprovalCode AS AuthCode


FROM     TenderEntry 
         JOIN [Transaction] 
           ON [Transaction].TransactionNumber = TenderEntry.TransactionNumber 
         JOIN Batch
	   ON Batch.BatchNumber = [Transaction].BatchNumber

WHERE    TenderEntry.TenderID IN (8,9,11) and
	 [Transaction].Time >= '09/01/2009' and 
         [Transaction].Time <= '09/05/2009'

order by [Transaction].Time

quote:

---

Originally posted by TG

It is good practice to have all possible CASEs result in the same datatype. Three of the four possiblities are varchar but your ELSE case is INT. If you don't have a difined type for TenerIDs besides those three then perhaps return 'Other' or NULL. Another alternative for your ELSE case is to cast TenderID as varchar. But even though that will work I don't logically like the idea of returning a mixture of descriptions and IDs in the same column.

Be One with the Optimizer
TG

---

quote:

---

Originally posted by TG

So you're saying that 8 isn't readable but 2 and 6 are? If so then you can go with the CAST alternative I suggested.

Be One with the Optimizer
TG

---