Viewing 15 posts - 32,731 through 32,745 (of 59,102 total)
weitzera (8/24/2011)
Select ActName, PName
FROM SalesDetailsCTE
GROUP BY ActName, PName
HAVING COUNT(DISTINCT DATEPART(yyyy, SoDate)) = 5
(this says for each customer and product, show me the customers that have...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2011 at 10:40 am
Grant Fritchey (8/26/2011)
Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have four...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2011 at 9:58 am
tonyarp05 61903 (8/26/2011)
This doesn't work, I am getting an errorMsg 402, Level 16, State 1, Line 369
The data types varchar and varchar are incompatible in the modulo operator.
That means that...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2011 at 7:37 am
shew (8/25/2011)
paul.knibbs (8/25/2011)
Of course, all this lockdown presumably only applies to Windows machines...can't you set up Linux on an old PC and put Eventum or something on it? π
Afraid not....
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2011 at 7:33 am
kavinithi (8/25/2011)
I used pivot concept in my procedure. How can i add a row at the end...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2011 at 7:01 am
cidr (8/26/2011)
SELECT a.Day, a.Salesman, sum(Sales),
(select sum(Sales)
from Net_Sales b
where b.DaY <=...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2011 at 6:53 am
hlewis (8/26/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2011 at 6:40 am
R.P.Rozema (8/25/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2011 at 6:19 am
I strongly recommend not using any split function that has a WHILE Loop in it. Please see the following article:
http://www.sqlservercentral.com/articles/Tally+Table/72993/
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2011 at 5:32 pm
You could always do a join on LIKE with a trailing wild-card.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2011 at 5:14 pm
Robert Cain (5/4/2010)
You might look at SQL Server Compact Edition, not sure your exact requirements but it's small, light weight, and if you give...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2011 at 4:20 pm
Any idea how long it would take without the firewall monitoring? The reason I ask is that I've seen BULK INSERT import 5.1 million, 20 column rows from a...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2011 at 4:14 pm
Sriram.RM (8/4/2011)
Gianluca Sartori (8/4/2011)
If you like his code, please consider voting...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2011 at 3:59 pm
R.P.Rozema (8/4/2011)
Even though I personally don't share the ideas that it reads and looks better.
BWAA-HAAA!!!! When leading commas are present, neither do I! π
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2011 at 3:55 pm
WayneS (8/25/2011)
Jeff Moden (8/25/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2011 at 3:41 pm
Viewing 15 posts - 32,731 through 32,745 (of 59,102 total)