CHECKDB TempDB also returns 9001 log unavailable error. obviously restart brings tempdb back but it happened 3 times when trying to initialize publication. 
Publication DB also returns 9001 from time...

Hi there, I was going through replies and also struggling with 9001 error . I am trying to deploy transaction replication between 2016 SQL vm instances and every time publication...

serg-52 (12/4/2015)

---

As well as only one value is needed scalar subquery will do

SELECT p.*,

value = ( SELECT TOP (1) [value]

FROM dbo.lkpTable l

WHERE l.ID = p.ID

ORDER BY l.Flag...

@aditya Daruka thanks, appreciated!

ScottPletcher (11/27/2015)

---

This may be more efficient (most people use LEFT rather than RIGHT join, so I switched it to that):

SELECT l.value, p.productname

FROM dbo.ProductTable p

LEFT OUTER JOIN (

...

got a brain wave , maybe there is better way of doing this but this looks like its working for me

SELECT b.value,...

thanks for reply guys. total fail on my side ...not sure why I got in to my head that I need to convert this to dd/mm/yyyy format before comparing it...

Thank you very much for quick reply and tip. I am running 2012 SSRS but data is in on 2008R2.

looks like handy function