Forum Replies Created
Viewing 15 posts - 346 through 360 (of 844 total)
-
RE: Fun at Work
Steve Jones - SSC Editor - Friday, August 24, 2018 9:28 AM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret. -
RE: EXCEPT
They don't have to be the same name. Just same number of columns and same order and data type.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret. -
RE: Today's Random Word!
Ed Wagner - Thursday, August 16, 2018 9:54 AMTomThomson - Thursday, August 16, 2018 9:14 AMRE: The Best Days
The days in which I was able to take a process that were running for hours in production and get them to run in just minutes or less.
The...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Today's Random Word!
Racing
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Talking baseball
Ray K - Monday, August 13, 2018 2:46 PM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Today's Random Word!
Jason A. Long - Monday, August 13, 2018 11:24 AM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Count the amount of times values appear in the database
paul 69259 - Monday, August 13, 2018 6:46 AM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Today's Random Word!
Ed Wagner - Monday, August 13, 2018 7:05 AM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: The Lost Last Value
Just another way around the barn.
-- How far the Player is Behind the Player ahead of them.
WITH Rank_Scores_CTE AS
(
SELECT s.playername AS Player,
s.points AS...-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Count the amount of times values appear in the database
And you really don't want a table called service and a field called service. This will be very confusing.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Count the amount of times values appear in the database
paul 69259 - Wednesday, August 8, 2018 9:19 AM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Count the amount of times values appear in the database
I created it as a temp table, but is this what you want?
SELECT [service], vehicle,
COUNT(*) AS Quantity,
SUM(subtotal) AS subtotal,
SUM(TaxAmount) AS TaxAmount,
SUM(total) AS Total
FROM #jobs
GROUP BY [service], vehicle
;
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Today's Random Word!
ZZartin - Tuesday, August 7, 2018 10:45 AM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.RE: Today's Random Word!
Sean Lange - Monday, August 6, 2018 1:55 PM-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.Viewing 15 posts - 346 through 360 (of 844 total)
