Viewing 15 posts - 556 through 570 (of 789 total)
ok..be more specific post the table structure and some sample data ... and someone will help you on it!
December 27, 2008 at 1:28 am
Jagger (12/26/2008)
Hvala!Thanks!
I don't recognize "Hvala" just Thanks = Faleminderit!
You are wellcome!
December 26, 2008 at 2:08 pm
Dugi (12/26/2008)
but can you explain to me this t.n*14 where did you find it ???
SELECT DATEADD(dd,t.n*14,'20090102') AS...
December 26, 2008 at 10:26 am
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
...
December 26, 2008 at 10:10 am
AHA you want to display just one record...ok you can do like this:
SELECT TOP 1 * FROM your_table
ORDER BY DATE DESC
December 26, 2008 at 9:27 am
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...
December 26, 2008 at 9:22 am
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...
December 26, 2008 at 7:02 am
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
December 26, 2008 at 2:58 am
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...
December 25, 2008 at 11:34 am
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!
December 17, 2008 at 11:51 pm
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!
November 25, 2008 at 12:10 pm
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:
November 25, 2008 at 12:07 pm
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...
November 25, 2008 at 12:04 pm
Interesting answer ha...
Hope that this will help you
http://www.sqlservercentral.com/articles/Disaster+Recovery/differentialbackuptricks/2439/
November 25, 2008 at 6:14 am
Viewing 15 posts - 556 through 570 (of 789 total)