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...
July 8, 2011 at 10:02 am
ringovski (7/7/2011)
July 8, 2011 at 2:26 am
GSquared (7/7/2011)
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...
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:
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...
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...
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...
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
June 22, 2011 at 7:10 am
How are you getting the results into notepad ?
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 ;-))
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...
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 😉
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....
May 27, 2011 at 6:53 am
Viewing 15 posts - 1,051 through 1,065 (of 3,544 total)