Viewing 15 posts - 931 through 945 (of 3,544 total)
Based in Chris' data
001Alvin12013-09-20 06:30:00.000
001Alvin22013-09-20 17:50:00.000
001Alvin12013-09-21 06:30:00.000
001Alvin22013-09-21 17:50:00.000
002Rebecca12013-09-20 22:10:00.000
002Rebecca22013-09-21 07:30:00.000
002Rebecca12013-09-21 22:10:00.000
002Rebecca12013-09-21 23:10:00.000
002Rebecca22013-09-22 07:30:00.000
002Rebecca22013-09-24 07:30:00.000
002Rebecca12013-09-25 22:10:00.000
002Rebecca22013-09-26 07:30:00.000
002Rebecca12013-09-28 22:10:00.000
003Aliyah12013-09-20 09:08:00.000
What should the output look like?
Far away is close at hand in the images of elsewhere.
Anon.
October 4, 2013 at 6:35 am
sun_kuang (2/13/2009)
Hi Guys,I created a query where it contains ID, Email, Class and a dynamic column which changes or grow depending on the parameter I select.
Your query selects data using...
Far away is close at hand in the images of elsewhere.
Anon.
October 4, 2013 at 6:18 am
Greg Edwards-268690 (9/27/2013)
...For the backfire, it would seem far more fitting on a return volley. :w00t:
:ermm: ... a boomerang pork chop ... 😉
Far away is close at hand in the images of elsewhere.
Anon.
September 27, 2013 at 9:21 am
Jeff Moden (9/26/2013)
SQLRNNR (9/26/2013)
The water cooler has done it again. Thanks Jeff et al for the laughs.:-D:-D:-D
Heh... after the last couple of weeks at work, pork chop acceleration technology...
Far away is close at hand in the images of elsewhere.
Anon.
September 27, 2013 at 2:21 am
HowardW (8/29/2013)
David Burrows (8/29/2013)
Jan Van der Eecken (8/29/2013)
The cost issue is normal here in the UK as electronic books are taxed (VAT) and paper ones not.
So you'd think, but Amazon...
Far away is close at hand in the images of elsewhere.
Anon.
August 29, 2013 at 8:01 am
Jan Van der Eecken (8/29/2013)
And thanks David for the tip on the PC Kindle version. Got it.
You're welcome 😀
Far away is close at hand in the images of elsewhere.
Anon.
August 29, 2013 at 6:05 am
Brandie Tarvin (8/29/2013)
Curious. I always thought that VAT was applied to all "processed" items. Could you inform a clueless American as to why paper books don't get VAT applied?
Stupid government...
Far away is close at hand in the images of elsewhere.
Anon.
August 29, 2013 at 6:04 am
Jan Van der Eecken (8/29/2013)
Far away is close at hand in the images of elsewhere.
Anon.
August 29, 2013 at 4:08 am
If you mean worksheet then you can add a group (with page break set) with an expression based on rownumber.
If you mean workbook then no.
Far away is close at hand in the images of elsewhere.
Anon.
August 22, 2013 at 2:00 am
Check the language for each of the logins as this determines conversion of character dates.
Are you passing the date parameters as character? If so is there a specific reason?
Far away is close at hand in the images of elsewhere.
Anon.
July 16, 2013 at 6:48 am
It was a great informative event Steve.
Great to meet you and Grant again and Gail for the first time. 🙂
Far away is close at hand in the images of elsewhere.
Anon.
July 3, 2013 at 6:38 am
Jack Corbett (5/31/2013)
2. I can't stand when developers create databases without a data professional involved.
:ermm:
I'm a developer, I create databases without a data professional as I do...
Far away is close at hand in the images of elsewhere.
Anon.
June 3, 2013 at 1:56 am
The is null condtions is used to set the flag to 1 if no prececeding year is present, 2 if there is no following year otherwise it is left at...
Far away is close at hand in the images of elsewhere.
Anon.
April 19, 2013 at 9:17 am
Assuming the space after hyphen is intentional to indicate heading then
;WITH cte (ID,Heading,FileDescription,Points)
AS (
SELECT LEFT(FileDescription,4) AS [ID],SUBSTRING(FileDescription,6,1) AS [Heading],FileDescription,Points
FROM @a
)
SELECT cte.FileDescription,SUM(p.Points) AS [Points]
FROM cte...
Far away is close at hand in the images of elsewhere.
Anon.
April 4, 2013 at 7:15 am
SELECT *
FROM tx_Main_Data
WHERE CONTAINS(Column1,'"This is for testing purpose"')
Far away is close at hand in the images of elsewhere.
Anon.
April 4, 2013 at 6:57 am
Viewing 15 posts - 931 through 945 (of 3,544 total)