Viewing 15 posts - 1,051 through 1,065 (of 3,544 total)
Steve Jones - SSC Editor (7/8/2011)
TGIFActually not so much. Leaving for the UK on Sunday, will be out of touch for most of the next week. Behave.
All being well, will...
Far away is close at hand in the images of elsewhere.
Anon.
July 8, 2011 at 10:02 am
ringovski (7/7/2011)
Far away is close at hand in the images of elsewhere.
Anon.
July 8, 2011 at 2:26 am
GSquared (7/7/2011)
Far away is close at hand in the images of elsewhere.
Anon.
July 7, 2011 at 6:48 am
1. where in the code do I put the alias i need for the column names, eg. issue date as Invoice Date.
Just add the alias to the end of the...
Far away is close at hand in the images of elsewhere.
Anon.
July 7, 2011 at 2:00 am
GilaMonster (7/5/2011)
... but it seems that just about every single QotD discussion has someone picking holes in the question.
Or repeated posts stating that the answer is wrong :rolleyes:
Far away is close at hand in the images of elsewhere.
Anon.
July 6, 2011 at 7:05 am
At a guess...
WITH cte (Invoice_id, IssueDate, Account, ApproveDate, RowId)
AS (SELECT h.Invoice_id, h.IssueDate, l.Account, l.ApproveDate, ROW_NUMBER() OVER(PARTITION BY h.Invoice_id ORDER BY h.Invoice_id ASC)
FROM Companies c
JOIN Invoice_head h ON...
Far away is close at hand in the images of elsewhere.
Anon.
July 6, 2011 at 6:52 am
Jeff Moden (7/5/2011)
This turned into a "watercooler" thread a long time ago and anyone with a minor dose of manners and a sense of humor is invited.
Damn! Counts me out...
Far away is close at hand in the images of elsewhere.
Anon.
July 6, 2011 at 2:03 am
Tom.Thomson (6/30/2011)
...All of IMS, IDS, IDMS used the term "primary key" long before 1970...
Wow! Tom, that takes me back :Wow:
IDMS was the first database I worked with :w00t:
Nice article by...
Far away is close at hand in the images of elsewhere.
Anon.
July 1, 2011 at 2:29 am
This will NOT work :
USE MYDATABASE
INSERT INTO MY_TABLE (TYPE,START_DATE,END_DATE,RATE)
VALUES
('DBLMS','01.03.2011','16.04.2011','104');
Default date format for conversion is dependant language setting for the login.
e.g.
British English accepts DD.MM.YYYY and YYYY.DD.MM
English accepts MM.DD.YYYY and YYYY.MM.DD
Far away is close at hand in the images of elsewhere.
Anon.
June 22, 2011 at 7:10 am
How are you getting the results into notepad ?
Far away is close at hand in the images of elsewhere.
Anon.
June 21, 2011 at 7:07 am
george sibbald (6/17/2011)
quick straw poll if you don't mind guys -how much access should developers have in a development environment?
None, they will only break it 😛
(only joking right ;-))
Far away is close at hand in the images of elsewhere.
Anon.
June 17, 2011 at 7:35 am
SQLRNNR (6/2/2011)
GSquared (6/2/2011)
opc.three (6/2/2011)
LutzM (6/2/2011)
Also, I will start to participate on the site more often. It has always been useful and seems to...
Far away is close at hand in the images of elsewhere.
Anon.
June 13, 2011 at 8:09 am
Ninja's_RGR'us (5/27/2011)
So in relation to your wife, what's the difference between union and union all? plz keep it PG! ;-):-P
The level of commitment 😉
Far away is close at hand in the images of elsewhere.
Anon.
May 27, 2011 at 6:57 am
tzanouch (5/27/2011)
I want to get the id's of everyone who has a specific value for every date.
Is that every date in the table or every date for each ID ?
eg....
Far away is close at hand in the images of elsewhere.
Anon.
May 27, 2011 at 6:53 am
Viewing 15 posts - 1,051 through 1,065 (of 3,544 total)