Viewing 15 posts - 1 through 15 (of 29 total)
Another advantage (hinted at in the introduction) is the potentially maintenance-free nature of the algorithm for when the column profile of the source/target tables changes, assuming they remain the same.
A...
April 16, 2020 at 7:41 am
@Eirikur - I think the ct comes from COUNT at the bottom of the query:
COUNT(DISTINCT DATEPART(MONTH, Call_Start_Time)) AS Ct
FROM Agent_Details
WHERE DATEPART(YEAR, Call_Start_Time) =...
February 6, 2017 at 1:36 am
Do you mean Forum Etiquette: How to post data/code on a forum to get the best help (this should be a clickable link)? If so click the link (also given in my...
February 2, 2017 at 1:36 am
@pietlinden - I think your script's missing a line.
Possibly something on the lines of this would be more complete:
February 2, 2017 at 1:13 am
Some sample data in an easily run format that covers the scenario and gives the result set you've shown would be helpful. See Jeff Moden's guide:
February 2, 2017 at 1:00 am
@Saig1417 - no problem, live and learn. Thom's use of a temporary table for test data is better practice than mine, and Jeff's How to Post Guide (linked...
January 27, 2017 at 7:16 am
Okay, here goes with some setup code. I've added in a couple of earlier records with just weekly data.
CREATE TABLE [dbo].[HoursWorked](
[EmpID] [INT] NOT NULL,
...
January 27, 2017 at 2:40 am
You'll be more likely to get help if you can post your query in a form that makes it easier for prospective helpers to use. Read article:
January 27, 2017 at 2:04 am
How about this?
-- Using Common Table Expression (CTE) to get Ecode date ranges to process
WITH EcodeDateRanges AS
(
SELECT dayBefore.Ecode, cl.Startdate, cl.Enddate FROM dbo.Absentdata dayBefore
...
December 9, 2016 at 1:33 am
PS: regarding the overview, when which job will run: you can get a simple table with next runtime etc. in the SQL Server Agent (job activity monitor)
Sure, but what I'd...
December 2, 2016 at 4:37 am
Like the idea. If implemented, I would also like to see some sort of management system that gives a DBA simple way of getting an overall view of all...
December 2, 2016 at 1:13 am
Thanks George. That triggered a further bit of research.
The puzzle for me was where the extra decimal places came from in the AVG result. I've found...
September 29, 2016 at 7:43 am
Why do we get an answer like "9.000000" instead of "9" when the length is 0 (i.e. rounded to no decimal points)? The answer here has two parts. I...
September 29, 2016 at 2:29 am
Aaron N. Cutshall (6/29/2016)
Personally, I prefer using an account name as email addresses are much more subject to change.
I can understand that view, but the issue I've had is where...
June 30, 2016 at 2:09 am
Unlucky. At the moment I’ve little problem with the use of email addresses for authentication despite the issues with that, though I'm aware there may be some ancient bulletin...
June 29, 2016 at 2:22 am
Viewing 15 posts - 1 through 15 (of 29 total)