Viewing 15 posts - 136 through 150 (of 187 total)
The computer that ran the game in eXistenZ was pretty interesting too... I think computer infections will never be shown better as in this one.
December 19, 2008 at 7:16 am
EdVassie (12/19/2008)
Deep Thought.Marvin and Holly are very close contenders, but Deep Thought has the solution to Life, the Universe, and Everything, even though you won't like the answer.
helen.trim (12/19/2008)
December 19, 2008 at 5:36 am
After reading that 5 times, it sure comes through a lot better.. :crazy: Are you happy now with your query though? If not, please post the table structure, sample data...
December 18, 2008 at 11:05 am
R. van Laake (12/18/2008)
2)I changed the line to:
CASE WHEN @codelogic_agenda_daysahead>=01 THEN COUNT(DISTINCT CASE WHEN DATEADD(d,01,@agendaVan) + t.CalendarStartTime ag.dtvan THEN ag.relatie_agendapersoonpid END) END AS [01],
Oh, I love to see...
December 18, 2008 at 11:01 am
Hoekom nie? Ek het eek vraag in Fraans geseen. Nie maklik to antwoord nie.
Oh no, my ancestors went to your country and.... We're family! 😉
December 18, 2008 at 10:51 am
What are you trying to achieve with your query? Best explained to us in a straightforward way is to post table structure, sample data and required output. With all that,...
December 18, 2008 at 10:47 am
Jeff Moden (12/18/2008)
r.hensbergen (12/18/2008)
You know both internet and SQL Server are international? On forums like these people visit from all over world.
Nah... really? I thought the internet was just...
December 18, 2008 at 10:14 am
Jeff Moden (12/18/2008)Actually, there is... it's people like that who will come to my country and actually expect a job and, quite possibly, get my job just because of equal...
December 18, 2008 at 7:55 am
Have you tried to change the query from Files.Status = "Closed" to Files.Status <> "Active"? It's not the best for performance, but at least you might get the correct output.
December 18, 2008 at 7:23 am
It shows you haven't looked at the link I suggested, but your query gives enough input for now... I think this is what you would need:select sum(CASE table1.column2 WHEN 'N'...
December 18, 2008 at 4:12 am
Can you please post the table description in the way described in the link in my signature please? If you also throw in some sample input data and the required...
December 18, 2008 at 2:54 am
Domagoj Orec (12/17/2008)
ortek (12/17/2008)
GilaMonster (12/16/2008)
Right now I'm trying to get by BI skills up to a...
December 17, 2008 at 6:25 am
First of all, the name of your table shows a bit funny to me, since temp is often used differently. Dropping a temp table sounds a bit too logical to...
December 17, 2008 at 6:01 am
michael.breen (12/17/2008)
Adiwhen I execute this it ask for a parameter for @UID and when I provide a parameter the result is "command(s) completed successfully"
Yes, only when you provide a parameter,...
December 17, 2008 at 5:07 am
Almost the same as I would write the query, only I would make an alias for the dbo_tbl_Files table. But the query gave me the same error as you described....
December 17, 2008 at 4:56 am
Viewing 15 posts - 136 through 150 (of 187 total)