Viewing 15 posts - 1,051 through 1,065 (of 3,543 total)
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
jcrawf02 (5/26/2011)
Actually, your English is better than most of the English-speaking folks, myself included. I should try responding in Italian...
Io non sarei schizzando senza senso
😀
May 26, 2011 at 9:11 am
Viewing 15 posts - 1,051 through 1,065 (of 3,543 total)