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?
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...
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 ... 😉
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...
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...
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 😀
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...
August 29, 2013 at 6:04 am
Jan Van der Eecken (8/29/2013)
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.
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?
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. 🙂
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...
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...
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...
April 4, 2013 at 7:15 am
SELECT *
FROM tx_Main_Data
WHERE CONTAINS(Column1,'"This is for testing purpose"')
April 4, 2013 at 6:57 am
Viewing 15 posts - 931 through 945 (of 3,544 total)