ok..be more specific post the table structure and some sample data ... and someone will help you on it!

I don't recognize "Hvala" just Thanks = Faleminderit!

You are wellcome!

Dugi (12/26/2008)

---

Jeff you are amazing ...I'm going to delete my answers ah :hehe:

but can you explain to me this t.n*14 where did you find it ???

SELECT DATEADD(dd,t.n*14,'20090102') AS...

Jeff you are amazing ...I'm going to delete my answers ah :hehe:

but can you explain to me this t.n*14 where did you find it ???

SELECT DATEADD(dd,t.n*14,'20090102') AS BiFriday

...

AHA you want to display just one record...ok you can do like this:

SELECT TOP 1 * FROM your_table

ORDER BY DATE DESC

as I can see you just select the data with date ordering desc and you will find the max value of date and the first row is what you are...

try this:

CREATE TABLE #PAPI

(

ID CHAR(4),

STATUS CHAR(2),

CNT INT

)

INSERT INTO #PAPI

SELECT '0001', 'XX', 10

UNION ALL

SELECT '0004', 'YY', 30

UNION ALL

SELECT '0005', 'XY', 40

SELECT * FROM #PAPI

SELECT ID,

MAX(CASE [STATUS] WHEN 'XX' THEN cnt ELSE...

or if you want to see also the date with dayname you can do like this:

SELECT DATENAME(weekday,Date_col) + ' ' + CONVERT(VARCHAR, Date_col, 103)

FROM Your_Table

Yea, nice solution from ps!

to bad I'm wrong too I didn't see very well Elton JOIN....this JOIN on the other hand I hate Elton John tooooo mucchh that was the reason for my...

Hmmm...indexed views I know but they are only for performance if you have lot of data...but it is not same functional as MV in Ora!

Hmm.. is better if you post the scritp of you tables structure and some sample data just to clarification the problem for what you are searching!

Too bad for me ... I wasn't there this year but hope that I will be there next year...have you any information for the next summit !?

:hehe:

Toooo bad... at least one backup you should have or copy of that DB! - :w00t:

Try to restore the files with other application for restoring maybe you can find something...

Interesting answer ha...

Hope that this will help you

http://www.sqlservercentral.com/articles/Disaster+Recovery/differentialbackuptricks/2439/