Viewing 15 posts - 931 through 945 (of 3,543 total)
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
SELECT pi.ProductId, pi.name, pi.familyName,
CASE pp.priceAssigned
WHEN 'listPrice' THEN pi.listPrice
WHEN 'price1' THEN pi.price1
WHEN 'price2' THEN pi.price2
WHEN 'price3' THEN pi.price3
WHEN 'price4' THEN pi.price4
WHEN 'price5' THEN pi.price5
END AS [priceAssigned]
FROM Customer c
JOIN ProductPricePerCustomer pp...
April 3, 2013 at 6:30 am
Viewing 15 posts - 931 through 945 (of 3,543 total)